Download PDO CRUD Class nulled download

This small class will save you time by providing CRUD methods for quickly building SQL query statements. This can be used and integrated into any existing project with ease. Also, it is great at handling exceptions when SQL errors are produced.

System Requirements
PHP 5
PDO Extension
Supported PDO Driver(s) – PDO_SQLITE, PDO_MYSQL, PDO_PGSQL
Usage
require(‘class.db.php’);
// Create
$bind = array( “:id” => $_POST[‘user_id’], “:user” => $_POST[‘username’]);
db::inst()->insert( “users”, array(“:id”, “:user”), ‘user_id, username’, $bind );
// Read
db::inst()->init( “SELECT * FROM users ORDER BY last_name” );
// Update
$bind = array( “:signature” => $_POST[‘signature’] );
db::inst()->update( ‘users’, array(‘signature’ => “:signature”), array(‘username’,$_SESSION[‘username’]), $bind );
// Delete
$bind = array(“:id” => $_POST[‘pID’]);
db::inst()->delete( “posts”, “postID = :id”, $bind );

Live Preview


average based on ratings.