What is the recommended method to retrieve the ID of the last inserted entry in PHP when using MySQLi or PDO_MySQL?

When using MySQLi or PDO_MySQL in PHP, the recommended method to retrieve the ID of the last inserted entry is to use the `mysqli_insert_id()` function for MySQLi or the `lastInsertId()` method for PDO_MySQL. These functions return the auto-generated ID that was created during the last INSERT query. 

// Using MySQLi
$mysqli = new mysqli("localhost", "username", "password", "database");
$mysqli->query("INSERT INTO table_name (column_name) VALUES ('value')");
$last_insert_id = $mysqli->insert_id;

// Using PDO_MySQL
$pdo = new PDO("mysql:host=localhost;dbname=database", "username", "password");
$pdo->query("INSERT INTO table_name (column_name) VALUES ('value')");
$last_insert_id = $pdo->lastInsertId();

Keywords

PHP MySQLi PDO_MySQL last inserted ID retrieve

Related Questions