// 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
PDOHelper::PA($q);
// Example -5 (Bulk Insert)
// loop start to create insert data
for ($i = 0; $i < 1000000; $i++) {
$dataArray[] = array('first_name' => 'Sid', 'last_name' => 'Mike', 'age' => 45);
$dataArray[] = array('first_name' => 'Scott', 'last_name' => 'Dimon', 'age' => 78);
$dataArray[] = array('first_name' => 'Meena', 'last_name' => 'Verma', 'age' => 23);
}
// use insertBatch function to insert multiple row at once and get all last insert id in array
$q = $db->insertBatch('test', $dataArray, true)->showQuery()->getAllLastInsertId();
// print array last insert id
PDOHelper::PA($q);
$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 */
/********************************************/
//place this before any script you want to calculate time
$time_start = microtime(true);
// loop start to create insert data
for ($i = 0; $i < 1000000; $i++) {
$dataArray[] = array('first_name' => 'Sid', 'last_name' => 'Mike', 'age' => 45);
}
// use insertBatch function to insert multiple row at once
$q = $p->insertBatch('test', $dataArray, true)->traceEnable()->getLastInsertId();
// get end time
$time_end = microtime(true);
//dividing with 60 will give the execution time in minutes other wise seconds
$execution_time = ($time_end - $time_start) / 60;
//execution time of the script
echo '<b>Total Execution Time:</b> ' . $execution_time . ' Mins';
// print array last insert id
PA($q);
