How to get last inserted id through save() method in laravel

Question

I know to get the last id I can use insertGetId() but I want to know how can I get the last inserted id through save() method.

order = new Store_order;
    $order->invoice_id = $signed['invoice_id'];
    $invoice = $order->save()['so_id'];

I used this but it returns null value

I know how to do it with relations. I want to know with `save()` method! — Alen, Mar 15 '17 at 10:20
In all cases, when you save, it will not return an invoice object. Which id are you looking for? Order Id? — Mina Abadir, Mar 15 '17 at 10:21
`so_id` is the PRIMARY KEY and AUTO_INCREMENT in database structure. So I want to get that `so_id` — Alen, Mar 15 '17 at 10:24
This post may help you : http://stackoverflow.com/questions/21084833/laravel-get-last-insert-id-using-eloquent — Sweta Parmar, Mar 15 '17 at 10:26
Possible duplicate of [Laravel, get last insert id using Eloquent](http://stackoverflow.com/questions/21084833/laravel-get-last-insert-id-using-eloquent) — TIGER, Mar 15 '17 at 10:34

TIGER · Answer 1 · 2017-03-15T10:51:14.903

10

After $order->save(), $order->so_id should be the last id inserted. Your code should be as below.

$order = new Store_order;
$order->invoice_id = $signed['invoice_id'];
$order->save();
$invoice = $order->so_id;

edited Mar 15 '17 at 10:51

answered Mar 15 '17 at 10:20

TIGER

2,864
5
35
45

the `save()` function returns null – Mina Abadir Mar 15 '17 at 10:22
@MinaAbadir if the id is NOT autoincremented, this will always return 0. – TIGER Mar 15 '17 at 10:23
Please test your code first on tinker at least. The `save()` method does not return anything. There is nothing about auto-increment here. – Mina Abadir Mar 15 '17 at 10:24
Actually `save()` returns boolean value either true or false what I believe. If it has successfully inserted value then `save()` returns `1` if not then `0` – Alen Mar 15 '17 at 10:26
1

It worked in Lumen 8.0 version also. Thanks – Kamlesh Apr 30 '21 at 07:58

Muthu17 · Answer 2 · 2017-03-15T10:29:31.807

4

You can get it by like below :

$order = new Store_order;
$order->invoice_id = $signed['invoice_id'];
$invoice = $order->save();
echo $invoice->so_id;

in this case you no need to store in one variable and then access it, You can get the inserted records by calling the model object itself :

    $order = new Store_order;
    $order->invoice_id = $signed['invoice_id'];
    $order->save();
    // echo $order; => will return entire stored last record.
    echo $order->so_id;

Make sure so_id is autoincrement.

edited Mar 15 '17 at 10:29

answered Mar 15 '17 at 10:24

Muthu17

1,481
12
20

$order->id working – Nazmul Haque Jan 06 '22 at 04:12

Majbah Habib · Answer 3 · 2020-06-05T12:30:05.290

0

You can get the last inserted id by the following codes.

Using Laravel Eloquent

$order = new Store_order();
$order->invoice_id = $signed['invoice_id'];
$order->save();

$lastInsertedId = $order->so_id;     //now getting Last inserted id
echo $lastInsertedId;

Provided that $order->so_id means last inserted id of the given object where so_id is the primary key of the table.

edited Jun 05 '20 at 12:30

answered Oct 12 '17 at 07:29

Majbah Habib

8,058
3
36
38

score 0 · Answer 4 · answered Sep 10 '19 at 06:04

0

Try this once it worked for me where $mode->save(); was only returning true.

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

answered Sep 10 '19 at 06:04

Rashi Goyal

933
9
15

Intelixence · Answer 5 · 2020-05-11T12:49:57.853

0

In case of you did overwride the name of primary key in the model as in next case:

protected $primaryKey = 'your_table_id_name';

use:

$id = $your_variable_save->your_table_id_name

if not:

$id = $your_variable_save->id

edited May 11 '20 at 12:49

answered May 11 '20 at 12:43

Intelixence

1
2

score -1 · Answer 6 · answered Mar 15 '17 at 11:53

-1

$ObjTable->nane = $name;
$ObjTable->save();
echo $ObjTable->id;

this will be display last inserted id.

answered Mar 15 '17 at 11:53

Amit Mandaviya

49
4

How to get last inserted id through save() method in laravel

6 Answers6

Linked

Related