How to get last insert id in Eloquent ORM laravel

Question

I am performing a database operation with "Eloquent ORM in Laravel". I just want to take the last insert id (not the maximum id) in the database.

I searched to get last insert id in laravel Eloquent ORM, I got following link (Laravel, get last insert id using Eloquent) that is refer to get last insert id from following function "$data->save()".

But I need to get

"Model::create($data)";

My Query:

GeneralSettingModel::create($GeneralData);

User::create($loginuserdata);

How can I retrieve the last inserted id?

Possible duplicate of [Laravel, get last insert id using Eloquent](http://stackoverflow.com/questions/21084833/laravel-get-last-insert-id-using-eloquent) — Luís Cruz, Oct 27 '15 at 14:22
If `If the table has an auto-incrementing id` Try this : https://stackoverflow.com/a/46482971/2815635 — Niklesh Raut, Sep 29 '17 at 06:37

score 50 · Accepted Answer · edited Aug 07 '15 at 16:03

Like the docs say: Insert, update, delete

"You may also use the create method to save a new model in a single line. The inserted model instance will be returned to you from the method. However, before doing so, you will need to specify either a fillable or guarded attribute on the model, as all Eloquent models protect against mass-assignment.

After saving or creating a new model that uses auto-incrementing IDs, you may retrieve the ID by accessing the object's id attribute:"

$insertedId = $user->id;

So in your sample:

$user = User::create($loginuserdata);
$insertedId = $user->id;

then on table2 it is going to be

$input['table2_id'] = $insertedId;
table2::create($input);

It's worth noting that the doc is misleading because the first method shown is `->save();` and it doesnt, IMO, do enough to explain that `save()` returns a boolean while *only* Insert, update, and delete return the instance. Especially since in says "After **saving** or creating" — Wesley Smith, Dec 09 '16 at 11:06

Majbah Habib · Answer 2 · 2016-07-25T11:55:54.987

22

**** For Laravel ****

$user = new User();

$user->name = 'John';

$user->save();

//Getting Last inserted id

$insertedId = $user->id;

edited Jul 25 '16 at 11:55

answered Aug 05 '15 at 04:24

Majbah Habib

8,058
3
36
38

$lastInsertedID = DB::table('users') ->insert( array( 'email_id' => $email_id, 'name' => $name ) ) ->lastInsertId(); – Majbah Habib Jul 31 '16 at 05:00
Thanks for answer but I solved my issue. It's about primaryKey. I was changed primarkey in Model. So I didnt get last id. After change primarykey to id, it worked. – Yasin Yörük Aug 01 '16 at 14:29
Thanks for your response – Majbah Habib Aug 02 '16 at 05:02

score 6 · Answer 3 · answered Jan 14 '16 at 13:37

6

You could wrap your data in the insertGetId() method like this

$id = DB::table('table')->insertGetId( $data );

In this case the array $data would look something like this

$data = [ 'field' => 'data' , 'field' => 'data' ];

and if you’re using the DB façade you could just append the lastInsertID() method to your query.

$lastInsertedID = DB::table('table')->insert( $data )->lastInsertId();

answered Jan 14 '16 at 13:37

Pankaj katiyar

464
10
26

1

It's worth noting that `insertGetId` only works if the column is actually named `id`. – Captain Hypertext Dec 15 '16 at 20:20

score 3 · Answer 4 · answered Oct 27 '15 at 10:20

3

$lastId = User::create($loginuserdata)->id;

answered Oct 27 '15 at 10:20

user2339271

96
1
2

Krzysiek Grzembski · Answer 5 · 2016-03-21T08:35:41.307

2

As others said bfore me you may retrieve id by using

$model->id;

but only if you are using standard naming convention for eloquent. If you want to use other name for primaryKey column, eg:

class Users extends Model{
    $primaryKey = 'userid';
}

you may retrieve last inserted id by calling

$model->userid;

It is described in: https://laravel.com/docs/master/eloquent#eloquent-model-conventions where one can find:

Eloquent will also assume that each table has a primary key column named id. You may define a $primaryKey property to override this convention.

In addition, Eloquent assumes that the primary key is an incrementing integer value, which means that by default the primary key will be cast to an int automatically. If you wish to use a non-incrementing or a non-numeric primary key you must set the public $incrementing property on your model to false.

edited Mar 21 '16 at 08:35

answered Jan 07 '16 at 12:49

Krzysiek Grzembski

960
10
20

Dear @Krzysiek Grzembski I need it in my controller.I changed it in the model as you written it in the model.But now $model->userid; is where accessible.I need it in my controller.Please guide... – Raham Mar 10 '16 at 11:59
@Raham Please see my updated answear. It is hard to tell what is your problem without any piece of code. – Krzysiek Grzembski Mar 21 '16 at 08:40
actually I solved my problem.My problem was that how can I retrieve the last inserted one from table.Now I looked up for your answer that how you return the last inserted one.where you defined $model... – Raham Mar 22 '16 at 11:38
The problem is the trigger generated keys – SaidbakR Apr 08 '17 at 13:50

score 2 · Answer 6 · answered Mar 22 '16 at 11:41

2

You may do it as,

public function store(Request $request,ModelName $obj)
{
        $lastInsertedId = $obj->create($request->all())->id;

}

Hope this will help you.

answered Mar 22 '16 at 11:41

Raham

4,781
3
24
27

score 2 · Answer 7 · edited Jan 02 '20 at 22:51

2

This is an eloquent model:

$user = new Reports();        
$user->email= 'david@example.com';  
$user->save();
$lastInsertId = $user->id;

A solution using Query Builder:

 $lastInsertId = DB::table('reports')->insertGetId(['email' => 'david@example.com']);

edited Jan 02 '20 at 22:51

S.S. Anne

15,171
8
38
76

answered Oct 21 '17 at 19:25

Md. Saidur Rahman Milon

2,761
23
29

score 2 · Answer 8 · answered Jun 19 '19 at 18:56

2

This is my try:

$model_ins = Model::orderBy('id', 'desc')->take(1)->first();

And use $model_ins->id.

answered Jun 19 '19 at 18:56

horse

707
4
11
30

score 1 · Answer 9 · edited Jan 02 '20 at 22:52

1

$user = (new user)->create($request->all()) ;

        \Session::flash('message', 'Thanks , Your record No (' .$user->id . ') has been Successfully added');

This is my solution. I return the inserted object and get its ID or any other property.

edited Jan 02 '20 at 22:52

S.S. Anne

15,171
8
38
76

answered Aug 20 '16 at 21:54

mercury

2,390
3
30
39

score 1 · Answer 10 · edited Jan 02 '20 at 22:50

1

This code works with Laravel 5.3:

$upstatus = User::create($status);
return response()->json($upstatus);

User pages/site I was call data.id

edited Jan 02 '20 at 22:50

S.S. Anne

15,171
8
38
76

answered Jan 05 '17 at 10:28

MD Ashik

9,117
10
52
59

Mohsen · Answer 11 · 2020-01-02T22:55:35.437

1

This is an easier way that works on all of the ways that you inserted:

DB::getPdo()->lastInsertId()

edited Jan 02 '20 at 22:55

answered Jan 02 '20 at 20:56

Mohsen

4,049
1
31
31

How to get last insert id in Eloquent ORM laravel

11 Answers11

Linked