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