php - 选择最后一个插入 ID

Question

我正在插入一条记录，我想使用最后插入的记录的 ID。这是我尝试过的:

$sql = 'INSERT INTO customer
                (first_name, last_name, email, password, 
                date_created, dob, gender,  customer_type)
        VALUES(:first_name, :last_name, :email, :password, 
                :date_created, :dob, :gender, :customer_type)' 
        . ' SELECT LAST_INSERT_ID()' ;

我收到错误:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT LAST_INSERT_ID()'.

谁能告诉我我的错误在哪里？谢谢!

Answer 1

查看 mysql_insert_id()

mysql_query($sql);
$id = mysql_insert_id();

当您在 mysql_query() 命令中执行 INSERT 语句后运行该函数时，其结果将是刚刚创建的行的 ID。