How can the mysql_insert_id function be used to efficiently retrieve the ID of the last inserted record in PHP?

To efficiently retrieve the ID of the last inserted record in PHP, you can use the mysql_insert_id function. This function returns the ID generated by a query on a table with a column having the AUTO_INCREMENT attribute. After executing an INSERT query, you can call mysql_insert_id to get the ID of the last inserted record. 

// Execute an INSERT query
$result = mysqli_query($connection, "INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2')");

// Get the ID of the last inserted record
$last_insert_id = mysqli_insert_id($connection);

// Use the $last_insert_id as needed
echo "The ID of the last inserted record is: " . $last_insert_id;

Keywords

mysql_insert_id function retrieve last inserted record PHP

Related Questions