PHP Classes

DB Access using PDO: Query MySQL tables with prepared queries using PDO

Recommend this page to a friend!
  Info   View files Example   View files View files (10)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 200 All time: 8,386 This week: 778Up
Version License PHP version Categories
db-access-wrapper 1.0The PHP License5.4PHP 5, Databases
Description Author

This class can query MySQL tables with prepared queries using PDO.

It can connect to a given MySQL server using PDO.

The class can execute prepared queries binding given parameter variables.

It can also execute table update queries given the identifier of the record to update and an associative array with values for each field.

Picture of Dustin Ruckman
  Performance   Level  
Name: Dustin Ruckman <contact>
Classes: 1 package by
Country: United States United States
Age: 45
All time rank: 4081508 in United States United States
Week rank: 523 Up56 in United States United States Up

  Files folder image Files  
File Role Description
Plain text file DatabaseAccess.Class.php Class DatabaseAccess Class
Accessible without login Plain text file Example.Consolidated.php Example Example showing a few of the most commonly used functionality of the class
Accessible without login Plain text file Example.InsertAndGetID.Simple.php Example Use the simple nonQuery method to do an insert and get the Inserted ID
Accessible without login Plain text file Example.SelectMultipleRows.php Example Use the class to select multiple rows and cycle them.
Accessible without login Plain text file Example.SelectMultipleRows.Simple.php Example Same as SelectMulitpleRows example but uses the single method call.
Accessible without login Plain text file Example.SelectSingleRow.php Example Example showing how to select a single row of data.
Accessible without login Plain text file Example.UpdateByReusingQuery.php Example An example using variable data with a static query to update multiple records
Accessible without login Plain text file Example.UpdateSingleRow.php Example Update a single row by ID using parameters.
Accessible without login Plain text file Example.UpdateTableWithArray.php Example Update a table using an array of values by a unique id
Accessible without login Plain text file Example.UseReturnO...mToCreateRecord.php Example Create a new user record from a form.

 Version Control Unique User Downloads Download Rankings  
 0%
Total:200
This week:0
All time:8,386
This week:778Up
For more information send a message to info at phpclasses dot org.