Getting the id of inserted row in Laravel

Question

Here is my code:

User::create([
    'name' => $request->name,
    'email' => $request->email,
    'cell_phone' => $request->cell_phone,
    'province_id' => $request->province,
    'city_id' => $request->city,
    'job' => $job,
    'company' => $company,
    'member_num' => $member_num,
]);

As you know, it inserts a new row in the database. Now I need to get the id of inserted row. How can I get that?

Noted that I know, I can do the same if I use $obj->save(), and the id will be $obj->id;. But I want to know how can I do that when I'm using create().

$userDetials = User::create([ 'name' => $request->name, 'email' => $request->email, 'cell_phone' => $request->cell_phone, 'province_id' => $request->province, 'city_id' => $request->city, 'job' => $job, 'company' => $company, 'member_num' => $member_num, ]); — Ankur Tiwari, Dec 13 '17 at 06:40

Ankur Tiwari · Accepted Answer · 2017-12-13T06:52:31.103

3

You can get user inserted id using code

$userDetials = User::create([
     'name' => $request->name,
     'email' => $request->email,
     'cell_phone' => $request->cell_phone,
     'province_id' => $request->province,
     'city_id' => $request->city,
     'job' => $job,
     'company' => $company,
     'member_num' => $member_num,
]);
if(isset($userDetials->id))    
{
    //if inserted 
    return $userDetials->id;
}
else
{
   //not inserted
}

The create method returns the saved model instance

edited Dec 13 '17 at 06:52

answered Dec 13 '17 at 06:42

Ankur Tiwari

2,762
2
23
40

@stack Welcome :) – Ankur Tiwari Dec 13 '17 at 06:53

score 1 · Answer 2 · answered Dec 13 '17 at 06:41

1

As per the docs

The create method returns the saved model instance:

In your case it would be

$user = User::create(...)

answered Dec 13 '17 at 06:41

M Khalid Junaid

63,861
10
90
118

I see, thank you, upvote. Just can you please tell me how can I check was inserted successfully? I mean is it correct? `if( isset($user->id) ){ /* row inserted */ }` – stack Dec 13 '17 at 06:50
@stack you can check it using like `if($user instance of User){...}` check if $user is an instance of your model – M Khalid Junaid Dec 13 '17 at 06:52
it returns the model instance regardless of whether `save` was successful or not – lagbox Dec 13 '17 at 07:13
@lagbox then you can use isset also and `if($user->id){...}` – M Khalid Junaid Dec 13 '17 at 07:21

score 1 · Answer 3 · edited Dec 13 '17 at 06:46

$data = User::create([
      'name' => $request->name,
      'email' => $request->email,
      'cell_phone' => $request->cell_phone,
      'province_id' => $request->province,
      'city_id' => $request->city,
      'job' => $job,
      'company' => $company,
      'member_num' => $member_num,
]);

After create, $data->id should be the last id inserted.

return Response::json(array('success' => true, 'last_insert_id' => $data->id), 200);

score 1 · Answer 4 · answered Dec 13 '17 at 08:54

Here create and save both method returns last generated id but make sure you are make the field auto increment.

$userobj = User::create([
'name' => $request->name,
'email' => $request->email,
'cell_phone' => $request->cell_phone,
'province_id' => $request->province,
'city_id' => $request->city,
'job' => $job,
'company' => $company,
'member_num' => $member_num,
]);
echo $userobj->id;

if you want to use create method you have to define all the fields as a fillable in you model, and save() method used in both for create and edit so habit of using save method is good,

example of save method

 $user = User::first();
 $user->email = 'updated@domain.com';
 $user->save();
echo $user->id;

both method returns last inserted id. i hope it helps, Thank you...

Getting the id of inserted row in Laravel

4 Answers4