php mysql_insert_id() returns the latest id implementation method of the database_PHP tutorial

die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db("test_db",$con); $sql = "INSERT INTO person VALUES ('Carter','Thomas','Beijing')"; $result = mysql_query($sql,$con); echo "ID of last inserted record is: " . mysql_insert_id(); mysql_close($con); ?> mysql_insert_id() returns the ID number of the AUTO_INCREMENT generated in the previous INSERT query in the given link_identifier. If link_identifier is not specified, the last opened connection is used. If the previous query did not produce a value for AUTO_INCREMENT, mysql_insert_id() returns 0. If you need to save the value for later use, be sure to call mysql_insert_id() immediately after the query that produced the value. LAST_INSERT_ID() MySQL also provides an API with the same function. It always saves the latest AUTO_INCREMENT value and will not be reset between query statements. That is to say, after executing the INSERT operation, execute SELECT, UPDATE, and DELETE. Statements will not affect the return value of this API. You can use SELECT LAST_INSERT_ID(); to query the return value of LAST_INSERT_ID(). Use a single INSERT statement to insert multiple records. LAST_INSERT_ID() only returns the AUTO_INCREMENT value generated by the first record inserted. http://www.bkjia.com/PHPjc/630741.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630741.htmlTechArticlephp mysql_insert_id() returns the latest id implementation method of the database. Students who need it can refer to it. The code is as follows Copy the code mysql_insert_id() mysql_insert_id() The function returns to the previous step INSERT...