Get the ID after performing an insert statement in laravel

Question

I have this code to insert the information about the user in the database:

DB::table('users')->insert(
       array( 
        'first_name'   =>   $first_name,
        'last_name' => $last_name,
        'birth_date' => $birthDate,
        'email' => $email,
        'password' => $password,
        'profession' => $profession,
        'gender' => $gender,
        'age' => $age
    )
   );

It runs sweet and then I have the user redirected to a dashboard page. But, I need the id of the user to get info about him/her. So, How do I get the id returned after the insert statement has been done!

usually you'll be looking for something like @@INDENTITY or LOCAL_SCOPE() but I suspect there is something specific for laravel — sniperd, May 01 '18 at 14:38
Check [some answers here](https://stackoverflow.com/a/46482971/2815635) — Niklesh Raut, May 01 '18 at 15:51

score 0 · Accepted Answer · answered May 01 '18 at 14:11

0

use insertGetId();

$id = DB::table('users')->insertGetId(
   array( 
    'first_name'   =>   $first_name,
    'last_name' => $last_name,
    'birth_date' => $birthDate,
    'email' => $email,
    'password' => $password,
    'profession' => $profession,
    'gender' => $gender,
    'age' => $age
   )
);

or just laravel eloquent

$users = User::create([
'first_name'   =>   $first_name,
'last_name' => $last_name,
'birth_date' => $birthDate,
'email' => $email,
'password' => $password,
'profession' => $profession,
'gender' => $gender,
'age' => $age
]);

dd($user->id); // If you modified Id add into model $primaryKey = "modified_id" $user->modified_id;

answered May 01 '18 at 14:11

Ralph Mirasol

137
5

That was it! Thank You! – May 01 '18 at 14:21
No problem :D +1 if useful – Ralph Mirasol May 01 '18 at 14:26
1

I dont have enough reputation! – May 01 '18 at 15:37

Get the ID after performing an insert statement in laravel

1 Answers1