// 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
$dataArray = array('first_name' => 'Sid', 'last_name' => 'Mike', 'age' => 45);
// use insert function
$q = $db->insert('test', $dataArray)->showQuery()->getLastInsertId();
PDOHelper::PA($q);
// Example -2
$dataArray = array('first_name' => 'Scott', 'last_name' => 'Dimon', 'age' => 55);
// use insert function
$q = $db->insert('test', $dataArray)->showQuery()->getLastInsertId();
PDOHelper::PA($q);
// Example -3
$dataArray = array('first_name' => 'Simran', 'last_name' => 'Singh', 'age' => 25);
// use insert function
$q = $db->insert('testt', $dataArray)->showQuery()->getLastInsertId();
PDOHelper::PA($q);
// Example -4
// use insert function
$q = $db->insert('test', $dataArray)->showQuery()->getLastInsertId();
// print array last insert id
* 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();
//insert example #1
$dataArray = array('first_name' => 'Sid', 'last_name' => 'Mike', 'age' => 45);
// use insert function
$q = $p->insert('test', $dataArray)->traceEnable()->getLastInsertId();
$dataArray = array('first_name' => 'Scott', 'last_name' => 'Dimon', 'age' => 55);
// use insert function
$q = $p->insert('test', $dataArray)->traceEnable()->getLastInsertId();
$dataArray = array('first_name' => 'Simran', 'last_name' => 'Singh', 'age' => 25);
// use insert function
$q = $p->insert('test', $dataArray)->traceEnable()->getLastInsertId();
// use insert function
$q = $p->insert('test', $dataArray)->traceEnable()->getLastInsertId();
// print array last insert id
PA($q);
die;
//insert example (bulk insert) #2
/********************************************/
/* GET Execution Time To check Bulk Insert */
/********************************************/
