CODEWITHSUNDEEP
phpmysqlpdo
Chetan Patel
Chetan Patel

Reputation: 183

Last Insert ID is not returning

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

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

here userid is primary key 

  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" => "[email protected]",
            ":password" => "1234567"
        );
        $statement->execute($bind);
        echo $dbh->lastInsertId();
    } catch (PDOException $e) {
        echo $e->getMessage();
    }

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

Upvotes: 4

Views: 2703

Answers (3)

lanzz
lanzz

Reputation: 43208

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.

Upvotes: 10

Ja͢ck
Ja͢ck

Reputation: 173662

The userid doesn't have an auto_increment attribute in your database, so lastInsertId() will never return anything useful.

You can only lastInsertId() if your field is:

  1. the primary key
  2. not null
  3. an integer type (int, bigint, etc.)
  4. auto_increment

Upvotes: 5

user1107107
user1107107

Reputation: 44

first you need to check insert query.

if its run proper then use mysql function like mysql_insert_id().

if this function is run property then may be possible to mistake in your $dbh->lastInsertId()

this function.

Upvotes: 0

Related Questions