PHP classes for PDO
How to use.
Include Files
include_once "singleton.php";
include_once "db.php";
Create Singleton Object
$db = DB::getInstance();
Fetching
$result = $db->select("SELECT * FROM `product` WHERE name = :name ",['name'=>'test']);
print_r($result);
Updating
$affected = $db->update("UPDATE `product` SET `name` = :name, updated_at =:updated_at WHERE `id` = :id",['name'=>'test200','id'=>2,'updated_at'=>date('Y-m-d H:i:s')]);
echo "Updated Rows: ".($affected);
Inserting
$insert = $db->insert("INSERT INTO `product`(`name`, `status`, `created_at`) VALUES (:name,:status,:created_at)",['name'=>'test','status'=>1,'created_at'=>date('Y-m-d H:i:s')]);
echo "Insert ID: ".($insert);
Deleting
$affected = $db->update("DELETE FROM `product` WHERE `id` = :id",['id'=>2]);
echo "Deleted Rows: ".($affected);