WorldWideScripts.net Delivering the best Add-Ons in more than 37 languages.

中文(简体), English, हिन्दी/हिंदी, Español/Castellano, العربية, Русский язык, Français, 中文 (台灣), বাংলা, Bahasa Indonesia, اردو, Português, Deutsch, Bahasa Melayu (بهاس ملايو‎), 日本語 (にほんご), فارسی, Italiano, తెలుగు, Türkçe, ગુજરાતી, Język polski/polszczyzna, Tiếng Việt, ಕನ್ನಡ, Українська мова, ไทย
PHP Scripts / Database Abstractions

Simplified DB - PDO, Mysqli, Mysql Helper Class

— Add-On to WorldWideScripts.net

Subscribe to our feed to stay up to date!

New! Follow us as you want it!


Simplified DB - PDO, Mysqli, Mysql Helper Class - CodeCanyon Item for Sale

Ads

Ad: Bluehost hosting

Version 1.3 is out now. Click here to check what’s new in V1.3*
SIMPLIFIED PDO, MYSQLI MYSQL HELPER CLASS Lp4tz iLpNteU LBatch Transacuon Gioup NOT Between 1CM Ltir LRVDNG Get Vanable Get Columns Get all Rows Get Tables

  • Now supports PDO Transactions also *

Simplified DB is a PHP database abstration class that helps developer perform MySQL operations easily using PDO, Mysqli and Mysql. Using Simplified DB, you can easily create and run both simple and advanced database driven application in PHP without having any knowledge of SQL.

Simplified DB provide a single solution for all you need to perform CRUD operation on Mysql DB using PHP as it covers all the 3 major ways (PDO, Mysqli and Mysql) of doing it.It has various shorthand methods that reduce code lines, improve readability of your code, improve security, performance & simplify your database operations.

SIMPLIFIED PDO, Mysqli Mysqi Helper Class Use either PDO Mysqli Mysqi for insert,update,delete,select operations. Now supports transactions for PDO Group by, Join, order by, limit, between, in, not in,like,limit etc. all supported Well documented, easy integrate, Easy debugging Best practices and use prepared statement for PDO, Mysqli Insert batch array, get all tables, get all data from table, get columns, execute query Helper functions like generate html table html form directly from select query result

Click here for more examples and documentation

Examples

 // include appropriate class file require_once("SimplifiedDBPDO.php"); //create object of class $sdb= new SimplifiedDB(); /** Connect to database **/ $sdb->dbConnect("servername","username","password","database"); /* Example of insert update and delete operations*/ $sdb->dbInsert("table_name",array("first_name"=>"Jerry","last_name"=>"Smith")); $sdb->dbUpdate("table_name",array("first_name"=>"John"),array("user_id"=>15)); $sdb->dbDelete("table_name",array("user_id"=>15)); /*Selecting all data*/ $sdb->dbSelect("table_name"); /*Selecting some columns(first_name,last_name) with where condition(user_id=10)*/ $sdb->dbSelect("table_name",array("first_name","last_name"),array("user_id"=>10)); // Example of using!= operator,(you can use any valid operator like '>','<','>=','<=') $result=$sdb->dbSelect("table_name",array("firstName","email"),array("gender!="=>"male")); // Applying group by, order by,limit,like conditions // you need to set them before calling select function $sdb->group_by_column="gender"; $sdb->order_by_column="first_name"; $sdb->limit_val="0,10"; $sdb->like_cols=array("firstname"=>"r%"); $sdb->in=array("user_id"=>"'10','8','12'"); $res=$sdb->dbSelect("table",array("first_name","last_name"),array("gender"=>"male")); 

It supports following SQL operations and commands using PDO, Mysqli and Mysql.

SELECT

INSERT

UPDATE

DELETE

WHERE CONDITION

JOIN

GROUP BY

ORDER BY

LIMIT

LIKE

BETWEEN

IN

NOT IN

(!=, >=,<=,>,<) OPERATORS

HAVING

version 1.3 released 21 Dec 2013
 1. Simplified DB PDO now support 'and' 'or' with same column name 2. 'update' 'delete' function where condition now supports comparison operators 
version 1.2 released 16 Aug 2013
 1. Added new function for batch update operation 2. Added new function for batch delete operation 3. Fixed a small bug related to '>=','<=' and using alias in join condition 
*Version 1.2 is out now. Click here to check what’s new in V1.2*
version 1.1 released 15 may 2013
 1. Supports PDO transaction 2. Reset Setting option added 3. Get all table names from database function added 4. Get value of single variable function added 5. Short hand function for getting all rows from table added 6. character set support added 7. fixed a small bug in update where condition 
Version 1.1 is out now. Click here to check what’s new in V1.1* If you like the script,please take a min. to rate it. It will motivate me to add new features. Thanks :)

Download
Other components in this categoryAll components of this author
CommentsFrequently asked questions and answers

Properties

Created:
22 February 13

Last Update:
22 December 13

Files Included:
JavaScript JS, CSS, PHP, SQL

Software Version:
PHP 5.3

Keywords

eCommerce, eCommerce, All Items, batch insert operation, crud operation, database abstraction, database transactions, generate html form, mysql, mysql abstraction, mysqli, mysqli abstraction, pdo, pdo abstraction, pdo transctions