How to get last insert ID of MySQL table in PHP?

Question

I have a table into which new data is frequently inserted. I need to get the last ID of the table. How can I do this?

Is it similar to SELECT MAX(id) FROM table?

Answer 1

There is a function that can know what the last id inserted in the current connection is

mysql_query('INSERT INTO FOO(a) VALUES(\'b\')');
$id = mysql_insert_id();

Plus using max is a bad idea as it may cause problems if your code is used simultaneously in two different sessions. .

The function is called mysql_insert_id

Answer 2

If you are using PDO, use PDO::lastInsertId.

If you are using Mysqli, please use mysqli::$insert_id .

If you are still using Mysql:

_{But if you must, use mysql_insert_id .}