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

PHP gets Mysql insert record ID

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

$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

round robin weighted round robin algorithm php implementation code
PHP strip_tags() function to remove HTML, XML and PHP tags from strings
Introduction to PHP strip_tags() to remove HTML, XML and PHP tags
PHP removes html tags--detailed explanation of the difference between strip_tags and htmlspecialchars
PHP strip_tags method to retain multiple HTML tags

PHP gets Mysql insert record ID

Related articles