PDO CRUD Class

CodeCanyon PDO CRUD Class 3543667
Script \ PHP Script \ Database Abstractions
Username \ Signature \ Dbinst \ Delete \ Updated \ Parameters \ Update \ Emulation

PHP Script - PDO CRUD Class 3543667 by parkerj @ CodeCanyon

Script \ PHP Script \ Database Abstractions

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']);
dbinst()->insert( "users", array(":id", ":user"), 'user_id, username', $bind );
// Read
dbinst()->init( "SELECT * FROM users ORDER BY last_name" );
// Update
$bind = array( ":signature" => $_POST['signature'] );
dbinst()->update( 'users', array('signature' => ":signature"), array('username',$_SESSION['username']), $bind );
// Delete
$bind = array(":id" => $_POST['pID']);
dbinst()->delete( "posts", "postID = :id", $bind );

Changelog

- (08.07.2013) v1.1

- Emulation set to false for true PDO

- Fixed issue when error reporting set to E_ALL

- Added DSN_PREFIX instead of hardcoding the prefix for more flexibility

- No need to double quote bind parameters anymore

- Updated for PHP 5.4.x

- Fixed query method to use bind parameters when not false

- Updated documentation to reflect changes

Last Update: 7 August 13; High Resolution: No; Files Included: JavaScript JS, HTML, CSS, PHP; Software Version: PHP 5.x, MySQL 5.x.

tinyCampaign; PHP Secure Stateless Cookies Class.

Keywords: mysql, pdo, postgresql, sqlite.


Create CodeCanyon PDO CRUD Class 3543667 style with After Effect, Cinema 4D, 3DS Max, Apple Motion or PhotoShop. CodeCanyon PDO CRUD Class 3543667 from creative professional designers. Full details of CodeCanyon PDO CRUD Class 3543667 for digital design and education. CodeCanyon PDO CRUD Class 3543667 desigen style information or anything related.

Comments:

Name:*
E-Mail:*
Add Comments:
Enter Code: *