CodeCanyon PDO CRUD Class 3543667

CodeCanyon PDO CRUD Class 3543667

CodeCanyon PDO CRUD Class 3543667
PHP Script \ Database Abstraction
Sqlite \ Postgresql \ Mysql


PHP Script - PDO CRUD Class 3543667 by parkerj @ CodeCanyon

PHP Script \ Database Abstraction

Last Update: 2 December 12; Software Version: PHP 5.x, MySQL 5.x; High Resolution: No; Files Included: JavaScript JS, HTML, CSS, PHP.

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 );

PHP Secure Stateless Cookies Class.

Keywords: mysql, pdo, postgresql, sqlite.



Tags: Postgresql, Sqlite, Mysql, Class

Premium CodeCanyon PDO CRUD Class 3543667 WordPress Themes, Website Templates, Mobile Themes, Flash Templates & Scripts 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: *