Search code examples
phpmysqldatabasepdolastinsertid

PDO: lastInsertId what value return?

in PHP if I use 

$last_id = $db->lastInsertId();

The variable $last_id does will get the value of the last row I've inserted in that instance or the latest row of the entire db?

if there are many users that connect and update database at the same time, the last id that I need in my application, will probably not fill the same as the latest of entire db.

Thanks in advance for response.

Solution

  • $last_id = $db->lastInsertId(); returns last inserted id for this DB conection.remember PDO will always return you the last ID inserted by the current active database connection.