Sometimes, we want to get the last ID inserted with PDO and PHP.
In this article, we’ll look at how to get the last ID inserted with PDO and PHP.
How to get the last ID inserted with PDO and PHP?
To get the last ID inserted with PDO and PHP, we can use the lastInsertId method.
For instance, we write
$stmt = $db->prepare("...");
$stmt->execute();
$id = $db->lastInsertId();
to create a prepared statement object with $db->prepare called with a insert statement SQL string.
Then we call execute to run the statement.
Next, we call $db->lastInsertId to return the ID of the last inserted entry.
Conclusion
To get the last ID inserted with PDO and PHP, we can use the lastInsertId method.
