Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > PHP gets Mysql insert record ID

PHP gets Mysql insert record ID

WBOY
Release： 2016-07-25 08:54:57
Original
993 people have browsed it
  3. $query="INSERT INTO `testtable` (`clou1`,`clou2`) VALUES ('testvalue','test')";
  4. mysql_query($query);
  5. $query="SELECT LAST_INSERT_ID()";
  6. $result=mysql_query($query);
  7. $rows=mysql_fetch_row($result);
  8. echo $rows[0];
复制代码


Related labels：
PHP获取Mysql插入记录ID
source：php.cn
Previous article：Three ways to import sql files with PHP Next article：Several methods to obtain domain names in PHP
Statement of this Website
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
Latest Articles by Author
Latest Issues
How to insert multiple rows in MySQL table and return new IDs? Normally I can insert a row in a MySQL table and get the last_insert_id. But now, I want t...
From 2024-04-06 10:03:44
0
2
294
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template