Home > Article > Backend Development > PHP gets Mysql insert record ID

PHP gets Mysql insert record ID

WBOYOriginal: 2016-07-25 08:54:57964browse

$query="INSERT INTO `testtable` (`clou1`,`clou2`) VALUES ('testvalue','test')";
mysql_query($query);
$query="SELECT LAST_INSERT_ID()";
$result=mysql_query($query);
$rows=mysql_fetch_row($result);
echo $rows[0];

复制代码

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

Previous article：Three ways to import sql files with PHPNext article：Three ways to import sql files with PHP

See more

How to use cURL to implement Get and Post requests in PHP
How to use cURL to implement Get and Post requests in PHP
How to use cURL to implement Get and Post requests in PHP
How to use cURL to implement Get and Post requests in PHP
All expression symbols in regular expressions (summary)

PHP gets Mysql insert record ID

Related articles