Home  >  Article  >  Backend Development  >  php mysql_insert_id() returns the latest id implementation method of the database_PHP tutorial

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

WBOY
WBOYOriginal
2016-07-13 17:05:551374browse

php mysql_insert_id() returns the latest ID implementation method of the database. Students in need can refer to it.

The code is as follows
 代码如下 复制代码

mysql_insert_id()
mysql_insert_id() 函数返回上一步 INSERT 操作产生的 ID。如果上一查询没有产生 AUTO_INCREMENT 的 ID,则 mysql_insert_id() 返回 0。

Copy code

mysql_insert_id()

The mysql_insert_id() function returns the ID generated by the previous INSERT operation. If the previous query did not produce an AUTO_INCREMENT ID, mysql_insert_id() returns 0.

 代码如下 复制代码

$con = mysql_connect("localhost", "hello", "321");
if (!$con)
{
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);
?>

Syntax: mysql_insert_id(connection)

Parameter connection, optional. Specifies the MySQL connection. If not specified, the previous connection is used.


mysql_insert_id() returns the ID number of the AUTO_INCREMENT generated in the previous INSERT query in the given connection. If connection is not specified, the last open connection is used.

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.

$con = mysql_connect("localhost", "hello", "321");

if (!$con)

{

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...
The code is as follows

Copy code
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn