What is the purpose of mysql_insert_id in PHP and how does it work?

The purpose of mysql_insert_id in PHP is to retrieve the ID generated by a query (usually an INSERT statement) on a table with an AUTO_INCREMENT column. This function returns the auto-generated ID of the last query. It can be useful when you need to know the ID of the last inserted row in order to perform further operations. 

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

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

// Use the ID for further operations if needed
echo "The ID of the last inserted row is: " . $last_insert_id;

Keywords

mysql_insert_id PHP database auto-increment primary key

Related Questions