Simplified DB is a helper PHP class that helps developers perform MySQL operations easily using PDO, Mysqli and Mysql.
Simplified DB project contains three separate files for the PDO, Mysqli and Mysql that helps developer to perform Mysql CRUD operations without any knowledge of the queries. It provides same function definition for performing CRUD operation for PDO, Mysqli and Mysql. This enables you to switch from one extension like upgrading from Mysql to PDO or Mysqli to PDO easily and also helps to remember less function definitions.
PHP has now three major ways of running queries PDO (newest), Mysqli and Mysql (oldest). Developer sometimes needs PDO functionality for new applications developed in PHP, sometimes Mysqli and sometimes they need to use Mysql extension for older applications. Simplified DB covers most of the operation you need to perform with different extension PDO,Mysqli and Mysql.
e.g.
For PDO (include “SimplifiedDBPDO.php” )
$db->dbInsert($table_name,$insert_array);// same parameters for insert operation
For Mysqli (include “SimplifiedDBMysqli.php” )
$db->dbInsert($table_name,$insert_array); //same parameters for insert operation
For Mysql (include “SimplifiedDBMysql.php” )
$db->dbInsert($table_name,$insert_array); //same parameters for insert operation
Examples
$sdb= new SimplifiedDB();
$sdb->dbConnect("localhost","username","password","dbuser");
$sdb->dbInsert("user_roles",array("role"=>"Admin","role"=>"Manages"));
$sdb->dbUpdate("user_roles",array("role"=>"Editor"),array("roleid"=>15));
$sdb->dbDelete("user_roles",array("role_id"=>15));
$sdb->dbSelect("user_roles");