How to get last id inserted on a database in Laravel?

Question

I am trying to get the last id of my table, I want this to know what is the next number of my counter and to show it to the user, I've tried with the last() method but I got this:

>>> $trans = Transferencia::last()
BadMethodCallException with message 'Call to undefined method Illuminate\Database\Query\Builder::last()'

Is there other way to know this?

If `ID` is AUTO_INCREMENT, there is no reliable way to know what will be the next one. — Paul Spiegel, Mar 10 '18 at 18:20
Possible duplicate of [Get current AUTO\_INCREMENT value for any table](https://stackoverflow.com/questions/15821532/get-current-auto-increment-value-for-any-table) — sorak, Mar 11 '18 at 07:33
AUTO_INCREMENT **is not a counter** and there is **no way** to know the next value before insert. You just **shouldn't** show to the user anything like this. — Your Common Sense, Sep 15 '22 at 08:08

Mahdi Younesi · Accepted Answer · 2023-06-06T15:13:24.363

15

4 Ways to Get Last Inserted Id in Laravel :

Using insertGetId() method:

$id = DB::table('users')->insertGetId([
 'name' => 'first' 
]);

Using lastInsertId() method:

DB::table('users')->insert([
  'name' => 'TestName'
]);
$id = DB::getPdo()->lastInsertId();

Using create() method:

$data = User::create(['name'=>'first']);
$data->id; // Get data id

Using save() method:

$data = new User;
$data->name = 'Test';
$data->save();

edited Jun 06 '23 at 15:13

answered Mar 10 '18 at 18:15

Mahdi Younesi

6,889
2
20
51

Yeah it works when I've inserted an item, but in my case i havent, so i just want to know what is the next id availible – Christian Mar 10 '18 at 18:17
@Christian on the third approach you have the last `id` then `$id+1` is available – Mahdi Younesi Mar 10 '18 at 18:21
This is very smart especially the third approach – kelrob-dev Nov 29 '19 at 21:16

score -1 · Answer 2 · answered Mar 10 '18 at 18:14

-1

>>> $data = DB::select('SELECT id FROM transferencia ORDER BY id DESC LIMIT 1');

NVM

answered Mar 10 '18 at 18:14

Christian

481
1
7
24

This approach should never be used because in the concurrent environment it will obviously return incorrect results – Your Common Sense Sep 15 '22 at 08:00

score -1 · Answer 3 · answered Mar 10 '18 at 18:16

-1

You can use LAST_INSERT_ID() function. Try this:

SELECT LAST_INSERT_ID() INTO yourTableName;

answered Mar 10 '18 at 18:16

Rashed

2,349
11
26

score -1 · Answer 4 · answered Mar 10 '18 at 21:02

-1

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

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

answered Mar 10 '18 at 21:02

Kashif Saleem

132
2
12

score -1 · Answer 5 · answered Oct 19 '20 at 11:09

-1

You can use the following code:

$data['password']= md5($request->password);
    
   $customer_id= DB::table('customer')
            ->insertGetId($data);
    echo $customer_id;

answered Oct 19 '20 at 11:09

Nazmul Haque

720
8
13

score -2 · Answer 6 · answered Mar 10 '18 at 18:30

-2

As I get you right, you want to know which id will be on next insert. If there is AUTO_INCREMENT primary key in table, you can get next value of that key using query:

SELECT AUTO_INCREMENT
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = DATABASE()
AND TABLE_NAME = "TABLE_NAME"

But it's not recommended to show user his ID before inserting, because it can be changed from other user's session.

answered Mar 10 '18 at 18:30

Taron Saribekyan

1,360
7
13

This approach should never be used because in the concurrent environment it will obviously return incorrect results – Your Common Sense Sep 15 '22 at 08:00

score -2 · Answer 7 · answered Jun 19 '19 at 18:51

-2

This can be the best answer:

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

And use $trans->id.

answered Jun 19 '19 at 18:51

horse

707
4
11
30

This approach should never be used because in the concurrent environment it will obviously return incorrect results – Your Common Sense Sep 15 '22 at 08:00

How to get last id inserted on a database in Laravel?

7 Answers7