How to Get MySQL's Last Inserted ID in PHP?

Accessing MySQL's Last Inserted ID in PHP

Retrieving the last inserted ID of a MySQL table is a common requirement in various programming scenarios. This guide will explore different methods to accomplish this task in PHP.

PDO

When using PDO (PHP Data Objects), simply call the PDO::lastInsertId() method after inserting data into the table. This method returns the ID of the last inserted row.

mysqli

Similarly, when working with MySQLi, use the mysqli::$insert_id property. This property contains the ID of the most recent insert operation.

mysql_insert_id (Deprecated)

Note that the mysql_insert_id function is deprecated and should be avoided in new code. Instead, use PDO or MySQLi for database operations.

Sample Code

Here is an example of how to get the last inserted ID using PDO:

// Insert data
$statement = $db->prepare('INSERT INTO table (name) VALUES (?)');
$statement->bindParam(1, $name);
$statement->execute();

// Get last inserted ID
$lastId = $db->lastInsertId();

For MySQLi, the code would look like this:

// Insert data
$mysqli->query('INSERT INTO table (name) VALUES ("' . $name . '")');

// Get last inserted ID
$lastId = $mysqli->insert_id;

The above is the detailed content of How to Get MySQL's Last Inserted ID in PHP?. For more information, please follow other related articles on the PHP Chinese website!