如何插入一条数据到ID自增的表中,并且返回这条插入的数据呢?
mysql_insert_id()是php本身的函数,用来返回插入数据中AUTO_INCREMENT定义的字段的值
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('mydb');
mysql_query("INSERT INTO mytable (product) values ('kossu')");
printf("Last inserted record has id %d\n", mysql_insert_id());
?>