<?php /** * Function to print array with pre tag * * @param array $array */ function PA($array) { echo '<pre>', print_r($array, true), '</pre>'; } // include pdo class wrapper include_once 'class.pdowrapper.php'; // create new object of class wrapper $p = new PdoWrapper(); // simple delete #1 // where condition array $aWhere = array('age' => 35); // call update function $q = $p->delete('test', $aWhere)->traceEnable()->affectedRows(); // print affected rows PA($q); // simple delete #2 // where condition array $aWhere = array('age' => 45, 'first_name' => 'Sonu'); // call update function $q = $p->delete('test', $aWhere)->traceEnable()->affectedRows(); // print affected rows PA($q);
<?php // include pdo helper class to use common methods include_once '../class/class.pdohelper.php'; // include pdo class wrapper include_once '../class/class.pdowrapper.php'; // database connection setings $dbConfig = array("host" => "localhost", "dbname" => 'sampledb', "username" => 'root', "password" => ''); // get instance of PDO Wrapper object $db = new PdoWrapper($dbConfig); // get instance of PDO Helper object $helper = new PDOHelper(); // set error log mode true to show error on screen or false to log in log file $db->setErrorLog(true); // Example -1 // where condition array $aWhere = array('age' => 35); // call update function $q = $db->delete('test', $aWhere)->showQuery()->affectedRows(); // print affected rows PDOHelper::PA($q); // Example -2 // where condition array $aWhere = array('age' => 45, 'first_name' => 'Sonu'); // call update function $q = $db->delete('test', $aWhere)->showQuery()->affectedRows(); // print affected rows PDOHelper::PA($q);