Get the Last Inserted Id Using Laravel Eloquent

Question

I'm currently using the below code to insert data in a table:

<?php

public function saveDetailsCompany()
{
    $post = Input::All();

    $data = new Company;
    $data->nombre = $post['name'];
    $data->direccion = $post['address'];
    $data->telefono = $post['phone'];
    $data->email = $post['email'];
    $data->giro = $post['type'];
    $data->fecha_registro = date("Y-m-d H:i:s");
    $data->fecha_modificacion = date("Y-m-d H:i:s");

    if ($data->save()) {
        return Response::json(array('success' => true), 200);
    }
}

I want to return the last ID inserted but I don't know how to get it.

Kind regards!

$id = DB::table('users')->insertGetId( array('email' => '[email protected]', 'votes' => 0) ); — Nahid
– Nahid, Commented Aug 29, 2021 at 9:07

vimuth · Accepted Answer · 2020-05-16 10:19:46Z

569

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

$data->save();
$data->id;

Can be used like this.

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

For updated laravel version try this

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

edited May 16, 2020 at 10:19

vimuth

5,87355 gold badges98 silver badges128 bronze badges

answered Jan 13, 2014 at 6:06

xdazz

161k38 gold badges255 silver badges278 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Cas Bloem Over a year ago

An object always returns an object, ofc. This is the only way to go.

Luís Cruz Over a year ago

Beware that if the id is NOT autoincrement, this will always return 0. In my case the id was a string (UUID) and for this to work I had to add public $incrementing = false; in my model.

SaidbakR Over a year ago

@milz I have MySQL trigger that generate the uuid for a custom field named aid and I have set $incrementing = false; but It does not returned too!

Damilola Olowookere Over a year ago

@SaidbakR while true, please can you indicate the section of the Laravel doc where you got this very important information?

shaedrich Over a year ago

By using $user->getKey() you make sure, the primary key can be something else than id.

|

Community · Accepted Answer · 2017-05-23 12:18:13Z

188

xdazz is right in this case, but for the benefit of future visitors who might be using DB::statement or DB::insert, there is another way:

DB::getPdo()->lastInsertId();

edited May 23, 2017 at 12:18

CommunityBot

11 silver badge

answered Apr 23, 2014 at 10:33

Benubird

19.7k28 gold badges97 silver badges148 bronze badges

5 Comments

Casey Over a year ago

Actually you can do it right in the insert $id = DB::table('someTable')->insertGetId( ['field' => Input['data']);

Rafael Over a year ago

@Casey doing it this way will not update timestamps in the DB

Frank Myat Thu Over a year ago

@Rafael, if you want to update timestamps using insertGetId, kindly check here

Captain Hypertext Over a year ago

Exactly what I was looking for the other day! Also, insertGetId only works if the id columns is actually called "id".

Stefan Pintilie Over a year ago

And if you use a specific database connection DB::connection("conn_name")->getPdo()->lastInsertId()

Barry · Accepted Answer · 2018-08-17 17:45:54Z

88

If the table has an auto-incrementing id, use the insertGetId method to insert a record and then retrieve the ID:

$id = DB::table('users')->insertGetId([
    'email' => '[email protected]',
    'votes' => 0
]);

Refer: https://laravel.com/docs/5.1/queries#inserts

edited Aug 17, 2018 at 17:45

Barry

3,3287 gold badges26 silver badges43 bronze badges

answered Jun 22, 2016 at 9:34

Aamir

2,2932 gold badges34 silver badges61 bronze badges

2 Comments

Jeffz Over a year ago

What you described looks like capturing last insert using Fluent. Question was about Eloquent. It would look more like: $id = Model::create('votes' => 0])->id; As described in this answer above: stackoverflow.com/a/21084888/436443

Charles Wood Over a year ago

And of course, as mentioned in other comments, don't forget that using insert will ignore events and $fillable, so take that into consideration!

dave · Accepted Answer · 2015-07-05 10:20:33Z

74

For anyone who also likes how Jeffrey Way uses Model::create() in his Laracasts 5 tutorials, where he just sends the Request straight into the database without explicitly setting each field in the controller, and using the model's $fillable for mass assignment (very important, for anyone new and using this way): I read a lot of people using insertGetId() but unfortunately this does not respect the $fillable whitelist so you'll get errors with it trying to insert _token and anything that isn't a field in the database, end up setting things you want to filter, etc. That bummed me out, because I want to use mass assignment and overall write less code when possible. Fortunately Eloquent's create method just wraps the save method (what @xdazz cited above), so you can still pull the last created ID...

public function store() {

    $input = Request::all();
    $id = Company::create($input)->id;

    return redirect('company/'.$id);
}

answered Jul 5, 2015 at 10:20

dave

2,2984 gold badges23 silver badges21 bronze badges

3 Comments

timgavin Over a year ago

This example didn't work for me in 5.1, but this did: $new = Company::create($input); return redirect('company/'.$new->id);

mosid Over a year ago

This assumes that the request fields name are the same as their respective database columns. Which is not always the case ( legacy codes for example)..

shaedrich Over a year ago

By using $user->getKey() you make sure, the primary key can be something else than id.

Majbah Habib · Accepted Answer · 2016-07-25 06:16:43Z

55

**** For Laravel ****

Firstly create an object, Then set attributes value for that object, Then save the object record, and then get the last inserted id. such as

$user = new User();        

$user->name = 'John';  

$user->save();

// Now Getting The Last inserted id

$insertedId = $user->id;

echo $insertedId ;

edited Jul 25, 2016 at 6:16

answered May 28, 2016 at 9:15

Majbah Habib

8,6064 gold badges41 silver badges42 bronze badges

1 Comment

shaedrich Over a year ago

By using $user->getKey() you make sure, the primary key can be something else than id.

Abdulhakim Zeinu · Accepted Answer · 2020-12-14 19:30:16Z

32

There are several ways to get the last inserted id. All are based on what method do you used when inserting. In your case you can get last Id like the following:

$data->save();
$data->id;

For others who need to know how can they get last inserted id if they use other insert methods here is how:

Using create() method

$book = Book::create(['name'=>'Laravel Warrior']);

$lastId = $book->id;
Using insertGetId()

$id = DB::table('books')->insertGetId( ['name' => 'Laravel warrior'] ); $lastId = $id;
Using lastInsertId() method

$lastId = DB::getPdo()->lastInsertId();

Reference https://easycodesolution.com/2020/08/22/last-inserted-id-in-laravel/

edited Dec 14, 2020 at 19:30

answered Aug 25, 2020 at 9:01

Abdulhakim Zeinu

3,8712 gold badges37 silver badges39 bronze badges

Comments

Barry · Accepted Answer · 2018-08-17 17:48:19Z

20

This worked for me in laravel 4.2

$id = User::insertGetId([
    'username' => Input::get('username'),
    'password' => Hash::make('password'),
    'active'   => 0
]);

edited Aug 17, 2018 at 17:48

Barry

3,3287 gold badges26 silver badges43 bronze badges

answered Feb 26, 2015 at 17:34

user28864

3,4731 gold badge28 silver badges19 bronze badges

Comments

Mujibur · Accepted Answer · 2015-02-21 07:48:14Z

19

In laravel 5: you can do this:

use App\Http\Requests\UserStoreRequest;
class UserController extends Controller {
    private $user;
    public function  __construct( User $user )
    {
        $this->user = $user;
    }
    public function store( UserStoreRequest $request )
    {
       $user= $this->user->create([
            'name'              => $request['name'],
            'email'             => $request['email'],
            'password'          => Hash::make($request['password'])
        ]);
        $lastInsertedId= $user->id;
    }
}

answered Feb 21, 2015 at 7:48

Mujibur

1,0278 silver badges12 bronze badges

Comments

Barry · Accepted Answer · 2018-08-17 17:47:03Z

17

Here's an example:

public static function saveTutorial(){

    $data = Input::all();

    $Tut = new Tutorial;
    $Tut->title = $data['title'];
    $Tut->tutorial = $data['tutorial'];   
    $Tut->save();
    $LastInsertId = $Tut->id;

    return Response::json(array('success' => true,'last_id'=>$LastInsertId), 200);
}

edited Aug 17, 2018 at 17:47

Barry

3,3287 gold badges26 silver badges43 bronze badges

answered Apr 16, 2014 at 10:42

jsdev

6726 silver badges16 bronze badges

Comments

Niklesh Raut · Accepted Answer · 2017-09-29 06:32:07Z

15

Use insertGetId to insert and get inserted id at the same time

From doc

If the table has an auto-incrementing id, use the insertGetId method to insert a record and then retrieve the ID:

By Model

$id = Model::insertGetId(["name"=>"Niklesh","email"=>"[email protected]"]);

By DB

$id = DB::table('users')->insertGetId(["name"=>"Niklesh","email"=>"[email protected]"]);

For more details : https://laravel.com/docs/5.5/queries#inserts

answered Sep 29, 2017 at 6:32

Niklesh Raut

34.9k17 gold badges82 silver badges112 bronze badges

Comments

dustypaws · Accepted Answer · 2019-07-16 17:51:22Z

15

Although this question is a bit dated. My quick and dirty solution would look like this:

$last_entry = Model::latest()->first();

But I guess it's vulnerable to race conditions on highly frequented databases.

answered Jul 16, 2019 at 17:51

dustypaws

3012 silver badges8 bronze badges

1 Comment

Daantje Over a year ago

Thanks! This I could use in my pipeline. So no worries about race conditions and beautiful code.

JON · Accepted Answer · 2019-12-31 11:34:33Z

14

For insert()

Example:

$data1 = array(
         'company_id'    => $company_id,
         'branch_id'        => $branch_id
     );

$insert_id = CreditVoucher::insert($data1);
$id = DB::getPdo()->lastInsertId();
dd($id);

edited Dec 31, 2019 at 11:34

JON

1,0232 gold badges12 silver badges28 bronze badges

answered Dec 1, 2018 at 11:14

Faridul Khan

2,0571 gold badge20 silver badges29 bronze badges

Comments

Qamar Uzman · Accepted Answer · 2014-04-30 07:45:48Z

Here is how we can get last inserted id in Laravel 4

public function store()
{
    $input = Input::all();

    $validation = Validator::make($input, user::$rules);

    if ($validation->passes())
    {

     $user= $this->user->create(array(
            'name'              => Input::get('name'),
            'email'             => Input::get('email'),
            'password'          => Hash::make(Input::get('password')),
        ));
        $lastInsertedId= $user->id; //get last inserted record's user id value
        $userId= array('user_id'=>$lastInsertedId); //put this value equal to datatable column name where it will be saved
        $user->update($userId); //update newly created record by storing the value of last inserted id
            return Redirect::route('users.index');
        }
    return Redirect::route('users.create')->withInput()->withErrors($validation)->with('message', 'There were validation errors.');
    }

Barry · Accepted Answer · 2018-08-17 17:49:00Z

8

After saving model, the initialized instance has the id:

$report = new Report();
$report->user_id = $request->user_id;
$report->patient_id = $request->patient_id;
$report->diseases_id = $request->modality;
$isReportCreated = $report->save();
return $report->id;  // this will return the saved report id

edited Aug 17, 2018 at 17:49

Barry

3,3287 gold badges26 silver badges43 bronze badges

answered Nov 3, 2015 at 9:25

Amir

8,9397 gold badges47 silver badges52 bronze badges

Comments

Priyanka Patel · Accepted Answer · 2020-05-08 04:47:04Z

8

You can easily fetch last inserted record Id

$user = User::create($userData);
$lastId = $user->value('id');

It's an awesome trick to fetch Id from the last inserted record in the DB.

edited May 8, 2020 at 4:47

answered Feb 22, 2020 at 5:31

Priyanka Patel

3534 silver badges16 bronze badges

5 Comments

Alex Over a year ago

two concurrent users adding the to the company model at the same time. this isn't reliable as the 1st post might get the id of the 2nd if the timing is right. the accepted answer is reliable.

Priyanka Patel Over a year ago

@Alex kindly check, this is working and the best solution to get last inserted id from records.

Alex Over a year ago

the updated solution is fine, however it requires more code than the accepted answer. Simply doing $user->id is enough after creating to get the inserted id.

Eben Watts Over a year ago

This is exactly the answer I wanted on Eloquent

shaedrich Over a year ago

By using $user->getKey() you make sure, the primary key can be something else than id.

Abhishek Goel · Accepted Answer · 2017-03-31 06:48:36Z

4

After

$data->save()

$data->id will give you the inserted id,

Note: If your autoincrement column name is sno then you should use $data->sno and not $data->id

answered Mar 31, 2017 at 6:48

Abhishek Goel

19.9k11 gold badges89 silver badges66 bronze badges

Comments

moodymudskipper · Accepted Answer · 2017-08-17 11:27:02Z

4

You can do this:

$result=app('db')->insert("INSERT INTO table...");

$lastInsertId=app('db')->getPdo()->lastInsertId();

edited Aug 17, 2017 at 11:27

moodymudskipper

47.7k12 gold badges131 silver badges185 bronze badges

answered Aug 17, 2017 at 10:30

Dnyaneshwar Harer

8628 silver badges13 bronze badges

Comments

Tayyab Hussain · Accepted Answer · 2015-11-03 10:30:45Z

3

After saving a record in database, you can access id by $data->id

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

answered Nov 3, 2015 at 10:30

Tayyab Hussain

1,8481 gold badge19 silver badges21 bronze badges

Comments

bobbybackblech · Accepted Answer · 2016-05-08 11:30:45Z

3

In Laravel 5.2 i would make it as clean as possible:

public function saveContact(Request $request, Contact $contact)
{
   $create = $contact->create($request->all());
   return response()->json($create->id,  201);
}

answered May 8, 2016 at 11:30

bobbybackblech

1,8866 gold badges20 silver badges22 bronze badges

Comments

Sᴀᴍ Onᴇᴌᴀ · Accepted Answer · 2017-03-21 18:47:59Z

3

For Laravel, If you insert a new record and call $data->save() this function executes an INSERT query and returns the primary key value (i.e. id by default).

You can use following code:

if($data->save()) {
    return Response::json(array('status' => 1, 'primary_id'=>$data->id), 200);
}

edited Mar 21, 2017 at 18:47

Sᴀᴍ Onᴇᴌᴀ

8,3028 gold badges38 silver badges61 bronze badges

answered Mar 15, 2017 at 9:06

HItesh Tank

6861 gold badge6 silver badges14 bronze badges

Comments

Barry · Accepted Answer · 2018-08-17 17:50:10Z

2

$objPost = new Post;
$objPost->title = 'Title';
$objPost->description = 'Description';   
$objPost->save();
$recId = $objPost->id; // If Id in table column name if other then id then user the other column name

return Response::json(['success' => true,'id' => $recId], 200);

edited Aug 17, 2018 at 17:50

Barry

3,3287 gold badges26 silver badges43 bronze badges

answered Jun 20, 2018 at 12:36

Kamal Maisuriya

394 bronze badges

Comments

automatix · Accepted Answer · 2018-12-03 14:49:37Z

2

The shortest way is probably a call of the refresh() on the model:

public function create(array $data): MyModel
{
    $myModel = new MyModel($dataArray);
    $myModel->saveOrFail();
    return $myModel->refresh();
}

answered Dec 3, 2018 at 14:49

automatix

15.2k32 gold badges119 silver badges245 bronze badges

Comments

President James K. Polk · Accepted Answer · 2025-01-07 02:58:20Z

2

Here is how it worked for me, family_id is the primary key with auto-increment I am using Laravel7

public function store(Request $request){
    $family = new Family();
    $family->family_name = $request->get('FamilyName');
    $family->family_no = $request->get('FamilyNo');
    $family->save();
    // family_id is the primary key and auto-increment
    return redirect('/family/detail/' .  $family->family_id);
}

Also, in the Model Family file which extends Model, should have the increment set to true otherwise the above $family->family_id will return empty

public $incrementing = true;

edited Jan 7 at 2:58

President James K. Polk

42.2k34 gold badges113 silver badges149 bronze badges

answered Jun 27, 2020 at 10:14

surajav

211 silver badge3 bronze badges

Comments

Md. Saidur Rahman Milon · Accepted Answer · 2017-10-21 19:21:39Z

1

Using Eloquent Model

$user = new Report();        
$user->email= '[email protected]';  
$user->save();
$lastId = $user->id;

Using Query Builder

$lastId = DB::table('reports')->insertGetId(['email' => '[email protected]']);

answered Oct 21, 2017 at 19:21

Md. Saidur Rahman Milon

2,93125 silver badges29 bronze badges

Comments

PPL · Accepted Answer · 2018-02-26 10:09:36Z

1

For get last inserted id in database You can use

$data = new YourModelName;
$data->name = 'Some Value';
$data->email = '[email protected]';
$data->save();
$lastInsertedId = $data->id;

here $lastInsertedId will gives you last inserted auto increment id.

answered Feb 26, 2018 at 10:09

PPL

6,5551 gold badge13 silver badges32 bronze badges

Comments

Barry · Accepted Answer · 2018-08-17 17:51:02Z

1

After Saving $data->save(). all data is pushed inside $data. As this is an object and the current row is just saved recently inside $data. so last insertId will be found inside $data->id.

Response code will be:

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

edited Aug 17, 2018 at 17:51

Barry

3,3287 gold badges26 silver badges43 bronze badges

answered Apr 9, 2017 at 8:51

sabuz

8499 silver badges10 bronze badges

Comments

Md Masud · Accepted Answer · 2019-08-23 11:32:51Z

1

You can get last inserted id with same object you call save method;

$data->save();
$inserted_id = $data->id;

So you can simply write:

if ($data->save()) {
    return Response::json(array('success' => true,'inserted_id'=>$data->id), 200);
}

answered Aug 23, 2019 at 11:32

Md Masud

2,7511 gold badge24 silver badges16 bronze badges

Comments

ventaquil · Accepted Answer · 2019-12-31 21:30:41Z

1

You can also try like this:

public function storeAndLastInrestedId() {
    $data = new ModelName();
    $data->title = $request->title;
    $data->save();

    $last_insert_id = $data->id;
    return $last_insert_id;
}

edited Dec 31, 2019 at 21:30

ventaquil

2,8584 gold badges25 silver badges52 bronze badges

answered Dec 31, 2019 at 17:55

Md Rasheduzzaman

1

Comments

Shadow · Accepted Answer · 2017-09-08 11:36:54Z

0

public function store( UserStoreRequest $request ) {
    $input = $request->all();
    $user = User::create($input);
    $userId=$user->id 
}

edited Sep 8, 2017 at 11:36

Shadow

34.5k10 gold badges67 silver badges76 bronze badges

answered Sep 8, 2017 at 11:30

temporary account

171 bronze badge

3 Comments

Syfer Over a year ago

This post was answered 3 years ago. Please edit your answer to add more explanation as to why it might help the user or how its helps solves the OP's question in a better way.

GrumpyCrouton Over a year ago

Thank you for this code snippet, which may provide some immediate help. A proper explanation would greatly improve its educational value by showing why this is a good solution to the problem, and would make it more useful to future readers with similar, but not identical, questions. Please edit your answer to add explanation, and give an indication of what limitations and assumptions apply. Not to mention the age of the question and the low quality of your answer.

S M Khalilullah Over a year ago

Beware of using this code as there is no validation here. You should not store any information without validation.

Karthik · Accepted Answer · 2018-06-21 04:29:59Z

Using Eloquent Model

use App\Company;

public function saveDetailsCompany(Request $request)
{

$createcompany=Company::create(['nombre'=>$request->input('name'),'direccion'=>$request->input('address'),'telefono'=>$request->input('phone'),'email'=>$request->input('emaile'),'giro'=>$request->input('type')]);

// Last Inserted Row ID

echo $createcompany->id;

}

Using Query Builder

$createcompany=DB::table('company')->create(['nombre'=>$request->input('name'),'direccion'=>$request->input('address'),'telefono'=>$request->input('phone'),'email'=>$request->input('emaile'),'giro'=>$request->input('type')]);

echo $createcompany->id;

For more methods to get Last Inserted Row id in Laravel : http://phpnotebook.com/95-laravel/127-3-methods-to-get-last-inserted-row-id-in-laravel

Collectives™ on Stack Overflow

Get the Last Inserted Id Using Laravel Eloquent

32 Answers 32

6 Comments

5 Comments

2 Comments

3 Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

5 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

3 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

32 Answers 32

6 Comments

5 Comments

2 Comments

3 Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

5 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

3 Comments

Comments

Linked

Related