How to get the last inserted id in Laravel?

Here is my code

 $users = DB::table('users')->insert(array(
            'email_id' => $email_id,
            'name' => $name,
        ));

         $lastInsertedID = $users->lastInsertId();

         return $lastInsertedID;

I want to get the last inserted id for a specific record. I tried using Eloquent ORM. but it didn’t work.

Any help would be greatly appreciated.

Thank.

+4
source share
3 answers

Use insertGetId ()

$id = DB::table('users')-> insertGetId(array(
        'email_id' => $email_id,
        'name' => $name,
));
+8
source

Follow the code to get the last inserted id using → insert ()

$lastInsertedID = DB::table('users')
                     ->insert( array(
                                   'email_id' => $email_id,
                                   'name' => $name
                               )
                     )
                    ->lastInsertId();
+2
source

, ? :

//UserController.php

$user  = new User;
$user->name = $request->name;
$user->email = $request->email;
if($user->save()){
    echo "User record id is ".$user->id; *//$user->id is your lastest record id*
}
0

All Articles