最后插入ID不返回 [英] Last Insert ID is not returning

问题描述

我有以下代码，可以使用PDO将数据插入数据库.

I have following code for inserting data into database using PDO.

它将数据插入数据库，但不返回ID中最后插入的数据.

It inserts data into database but not return last inserted in ID.

此处userid是主键

  try {
        $dbh = new PDO('mysql:host=localhost;dbname=crud_demo', "username", "password");

        $sqlQuery = "INSERT INTO users(userid,first_name,last_name,email,password)
            VALUES(:userid,:first_name,:last_name,:email,:password)";

        $statement = $dbh->prepare($sqlQuery);
        $bind = array(
            ":userid" => "bhavik",
            ":first_name" => "Bhavik",
            ":last_name" => "Patel",
            ":email" => "[e-mail]",
            ":password" => "1234567"
        );
        $statement->execute($bind);
        echo $dbh->lastInsertId();
    } catch (PDOException $e) {
        echo $e->getMessage();
    }

$dbh->lastInsertId();总是返回0，无论我为用户ID插入什么值

$dbh->lastInsertId(); always return 0 whatever i insert value for userid

推荐答案

lastInsertId()仅返回在AUTO_INCREMENT列中自动生成的ID.您的PRIMARY KEY显然是一个字符串(或者至少您要在其中插入一个字符串).由于您要插入一个已知值，因此实际上不需要找出插入的ID，您可以自己指定它.

lastInsertId() only returns IDs automatically generated in an AUTO_INCREMENT column. Your PRIMARY KEY is apparently a string (or at least you're inserting a string in it). Since you're inserting a known value, you don't actually need to find out the inserted ID — you've specified it yourself.

这篇关于最后插入ID不返回的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！