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