PHP Classes
elePHPant
Icontem

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    
Last Updated Ratings Unique User Downloads Download Rankings
2015-02-27 (1 year ago) RSS 2.0 feedNot yet rated by the usersTotal: 198 All time: 7,840 This week: 1,043Up
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

  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:198
This week:0
All time:7,840
This week:1,043Up