3 ways to get the ID value of new MySql records in PHP_PHP Tutorial

1. Use sentences:

What you get using this method is the largest ID value, which is indeed the last value. However, when there are multiple link threads, this largest ID is not necessarily the auto-increment ID value of the data we insert, so it is not suitable for multi-threading.

Two, use the function: msyql_insert_id();

In PHP, it is often necessary to retrieve the id value inserted into the database, and there is exactly such a function:

The PHP function mysql_insert_id() returns the value of the field defined by AUTO_INCREMENT after the last INSERT query was executed.

When the system executes INSERT and then executes SELECT, it may have been distributed to different back-end servers. If you use PHP programming, you should use mysql_insert_id() to get the latest inserted id at this time. After each INSERT is completed, , in fact, the corresponding autoincrement value has already been calculated and returned to PHP. You do not need to issue a separate query, just use mysql_insert_id().
When a statement is inserted, it automatically returns the last id (mysql auto-increment value).
And this function is only useful for the current link, that is, it is multi-user safe.
It is recommended to use this function;
Problem: When the id is of type bigint, it no longer works.

3. Use query

last_insert_id() is a function of mysql and is also effective on the current link
This usage solves the bigint type problem encountered in mysql_insert_id ()
Summary:
It is recommended to use method two. In special circumstances, method three can be considered.