// 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 */ /********************************************/