PHP+MySQL insert数据到ID自增的表中相关指令
如何插入一条数据到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()); ?>