sudhirvi / php-classes-for-pdo

Simple PHP Classes for PDO Singleton Design Pattern

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