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' => 'john@example.com', 'votes' => 0) ); — Nahid, Aug 29 '21 at 09:07

score 557 · Accepted Answer · edited May 16 '20 at 10:19

557

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 '20 at 10:19

vimuth

5,064
33
79
116

answered Jan 13 '14 at 06:06

xdazz

158,678
38
247
274

2

An object always returns an object, ofc. This is the only way to go. – Cas Bloem Nov 26 '14 at 14:11
55

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. – Luís Cruz Apr 20 '15 at 17:18
3

@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! – SaidbakR Apr 08 '17 at 13:29
@SaidbakR while true, please can you indicate the section of the Laravel doc where you got this very important information? – Damilola Olowookere May 13 '19 at 22:51
@DamilolaOlowookere This is what I had found in my application which uses Laravel 5.4. – SaidbakR May 14 '19 at 22:44
By using `$user->getKey()` you make sure, the primary key can be something else than `id`. – shaedrich Mar 30 '23 at 07:12

score 178 · Answer 2 · edited May 23 '17 at 12:18

178

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 '17 at 12:18

Community

1
1

answered Apr 23 '14 at 10:33

Benubird

18,551
27
90
141

61

Actually you can do it right in the insert `$id = DB::table('someTable')->insertGetId( ['field' => Input['data']);` – Casey May 15 '14 at 15:05
1

@Casey doing it this way will not update timestamps in the DB – Rafael Dec 07 '14 at 04:30
@Rafael, if you want to update `timestamps` using `insertGetId`, kindly check [here](http://stackoverflow.com/a/33452275) – Frank Myat Thu May 03 '16 at 07:54
Exactly what I was looking for the other day! Also, `insertGetId` only works if the id columns is actually called "id". – Captain Hypertext Dec 17 '16 at 01:42
And if you use a specific database connection DB::connection("conn_name")->getPdo()->lastInsertId() – Stefan Pintilie Sep 26 '20 at 12:35

score 81 · Answer 3 · edited Aug 17 '18 at 17:45

81

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' => 'john@example.com',
    'votes' => 0
]);

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

edited Aug 17 '18 at 17:45

Barry

3,303
7
23
42

answered Jun 22 '16 at 09:34

Aamir

2,173
1
29
58

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: https://stackoverflow.com/a/21084888/436443 – Jeffz Jul 10 '18 at 22:02
And of course, as mentioned in other comments, don't forget that using `insert` will ignore events and `$fillable`, so take that into consideration! – Charles Wood Oct 16 '20 at 19:04

score 73 · Answer 4 · answered Jul 05 '15 at 10:20

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);
}

This example didn't work for me in 5.1, but this did: `$new = Company::create($input);` `return redirect('company/'.$new->id);` — timgavin, Sep 19 '15 at 18:15
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).. — mosid, Nov 30 '17 at 04:47
By using `$user->getKey()` you make sure, the primary key can be something else than `id`. — shaedrich, Mar 30 '23 at 07:11

Majbah Habib · Answer 5 · 2016-07-25T06:16:43.790

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 '16 at 06:16

answered May 28 '16 at 09:15

Majbah Habib

8,058
3
36
38

By using `$user->getKey()` you make sure, the primary key can be something else than `id`. – shaedrich Mar 30 '23 at 07:11

Abdulhakim Zeinu · Answer 6 · 2020-12-14T19:30:16.143

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/

score 20 · Answer 7 · edited Aug 17 '18 at 17:48

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 '18 at 17:48

Barry

3,303
7
23
42

answered Feb 26 '15 at 17:34

user28864

3,375
1
25
19

score 19 · Answer 8 · answered Feb 21 '15 at 07:48

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;
    }
}

score 17 · Answer 9 · edited Aug 17 '18 at 17:47

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 '18 at 17:47

Barry

3,303
7
23
42

answered Apr 16 '14 at 10:42

jsdev

672
6
14

score 15 · Answer 10 · answered Sep 29 '17 at 06:32

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"=>"myemail@gmail.com"]);

By DB

$id = DB::table('users')->insertGetId(["name"=>"Niklesh","email"=>"myemail@gmail.com"]);

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

score 14 · Answer 11 · answered Jul 16 '19 at 17:51

14

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 '19 at 17:51

dustypaws

191
1
8

1

Thanks! This I could use in my pipeline. So no worries about race conditions and beautiful code. – Daantje Mar 01 '20 at 19:00

score 13 · Answer 12 · edited Dec 31 '19 at 11:34

13

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 '19 at 11:34

JON

965
2
10
28

answered Dec 01 '18 at 11:14

Faridul Khan

1,741
1
16
27

score 12 · Answer 13 · answered Apr 30 '14 at 07:45

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.');
    }

score 8 · Answer 14 · edited Aug 17 '18 at 17:49

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 '18 at 17:49

Barry

3,303
7
23
42

answered Nov 03 '15 at 09:25

Amir

8,821
7
44
48

Priyanka Patel · Answer 15 · 2020-05-08T04:47:04.000

7

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 08 '20 at 04:47

answered Feb 22 '20 at 05:31

Priyanka Patel

323
4
15

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. – Alex May 05 '20 at 17:18
@Alex kindly check, this is working and the best solution to get last inserted id from records. – Priyanka Patel May 08 '20 at 04:48
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. – Alex May 08 '20 at 19:10
2

This is exactly the answer I wanted on Eloquent – Eben Watts Aug 15 '22 at 10:18
By using `$user->getKey()` you make sure, the primary key can be something else than `id`. – shaedrich Mar 30 '23 at 07:10

score 4 · Answer 16 · answered Mar 31 '17 at 06:48

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 '17 at 06:48

Abhishek Goel

18,785
11
87
65

score 4 · Answer 17 · edited Aug 17 '17 at 11:27

4

You can do this:

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

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

edited Aug 17 '17 at 11:27

moodymudskipper

46,417
11
121
167

answered Aug 17 '17 at 10:30

Dnyaneshwar Harer

792
7
13

score 3 · Answer 18 · answered Nov 03 '15 at 10:30

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 03 '15 at 10:30

Tayyab Hussain

1,658
1
18
21

score 3 · Answer 19 · answered May 08 '16 at 11:30

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 08 '16 at 11:30

bobbybackblech

1,868
5
20
22

score 3 · Answer 20 · edited Mar 21 '17 at 18:47

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 '17 at 18:47

Sᴀᴍ Onᴇᴌᴀ

8,218
8
36
58

answered Mar 15 '17 at 09:06

HItesh Tank

636
1
6
13

score 2 · Answer 21 · edited Aug 17 '18 at 17:50

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 '18 at 17:50

Barry

3,303
7
23
42

answered Jun 20 '18 at 12:36

Kamal Maisuriya

39
4

score 1 · Answer 22 · answered Feb 26 '18 at 10:09

1

For get last inserted id in database You can use

$data = new YourModelName;
$data->name = 'Some Value';
$data->email = 'abc@mail.com';
$data->save();
$lastInsertedId = $data->id;

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

answered Feb 26 '18 at 10:09

PPL

6,357
1
11
30

score 1 · Answer 23 · answered Dec 03 '18 at 14:49

1

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 03 '18 at 14:49

automatix

14,018
26
105
230

score 1 · Answer 24 · edited Dec 31 '19 at 21:30

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 '19 at 21:30

ventaquil

2,780
3
23
48

answered Dec 31 '19 at 17:55

Md Rasheduzzaman

525
5
8

surajav · Answer 25 · 2020-06-27T12:57:36.900

Here it 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;

score 0 · Answer 26 · edited Aug 17 '18 at 17:51

0

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 '18 at 17:51

Barry

3,303
7
23
42

answered Apr 09 '17 at 08:51

sabuz

829
8
10

score 0 · Answer 27 · answered Oct 21 '17 at 19:21

0

Using Eloquent Model

$user = new Report();        
$user->email= 'johndoe@example.com';  
$user->save();
$lastId = $user->id;

Using Query Builder

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

answered Oct 21 '17 at 19:21

Md. Saidur Rahman Milon

2,761
23
29

score 0 · Answer 28 · answered Aug 23 '19 at 11:32

0

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 '19 at 11:32

infomasud

2,263
1
18
12

score -1 · Answer 29 · edited Sep 08 '17 at 11:36

-1

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

edited Sep 08 '17 at 11:36

Shadow

33,525
10
51
64

answered Sep 08 '17 at 11:30

temporary account

7
1

2

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. – Syfer Sep 08 '17 at 11:42
1

Thank you for this code snippet, which may provide some immediate help. A proper explanation [would greatly improve](https://meta.stackexchange.com/q/114762) 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. – GrumpyCrouton Sep 08 '17 at 15:53
Beware of using this code as there is no validation here. You should not store any information without validation. – Khalilullah Nov 19 '20 at 12:00

score -1 · Answer 30 · answered Jun 21 '18 at 04:29

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

score -1 · Answer 31 · answered Nov 15 '19 at 07:04

You can use $this constructor variable to achieve "Last Inserted Id Using Laravel Eloquent" (without adding any extra column) in current function or controller.

public function store(Request $request){
    $request->validate([
        'title' => 'required|max:255',
        'desc' => 'required|max:5000'
    ]);

    $this->project = Project::create([
        'name' => $request->title,
        'description' => $request->desc,
    ]);

    dd($this->project->id);  //This is your current/latest project id
    $request->session()->flash('project_added','Project added successfully.');
    return redirect()->back();

}

score -2 · Answer 32 · answered Aug 10 '19 at 01:21

-2

Optional method will be:

$lastID = DB::table('EXAMPLE-TABLE')
                ->orderBy('id', 'desc')
                ->first();

$lastId = $lastProduct->id;

Source from Laravel 5.8 version

answered Aug 10 '19 at 01:21

Gustavo Morillo Marin

1

Get the Last Inserted Id Using Laravel Eloquent

32 Answers32

Linked

Related