Get Last inserted record ID in PHP

 

Description :

I have two tables one is 'Persons' and other is 'orders'. If you want insert Persons table primmary_key(unique id) into oredrs table the below pieceof code will help you. The below '$last_record_id' is primary_key of 'Persons' table that inserted into 'Orders' table.   Add below code will show you to Get Last inserted record ID in PHP [php] $query1="insert into persons(column1, column2, column3, column4) values('value1', 'value2', 'value3', 'value4')"; $res1 = $db->query($query1); $last_record_id=$db->lastInsertId(); // ID of last inserted record in your table $query2="insert into table2(column1, column2, column3, column4) values('value1', '$last_record_id', 'value3', 'value4')"; $res2 = $db->query($query2); [/php]