Eloquent / Laravel: How to get last insert/update ID/instance of updateOrCreate()?

Question

The title is mostly self-explanatory. Eloquent has a method called

updateOrCreate()

In some cases this is really useful. However after doing updateOrCreate() I need either the updated/created object or its primary key or its id.

Of course I could do MyModel::where(...)->first() and give all those data again but this is clumsy and may be some expensive request.

However updateOrCreate() only returns true or false.

Any ideas?

Possible duplicate of [Laravel, get last insert id using Eloquent](https://stackoverflow.com/questions/21084833/laravel-get-last-insert-id-using-eloquent) — chiliNUT, Oct 25 '17 at 15:33

score 22 · Accepted Answer · answered Oct 25 '17 at 15:34

22

The method will return ID of created or updated object, so just do this:

$object = Model::updateOrCreate(['name' => 'John'], ['age' => 25]);

$id = $object->id;

answered Oct 25 '17 at 15:34

Alexey Mezenin

2

Actually you are right seems like I had a custom function in mind which didnt thanks. – Blackbam Oct 25 '17 at 15:51
The method seems to always return the object? – Adam Nov 24 '17 at 09:42

score -3 · Answer 2 · answered Oct 25 '17 at 15:32

-3

Query for the last one

$lastRecord = MyModel::last();

Or

$lastRecord = MyModel::orderBy('id', 'DESC')->first();

answered Oct 25 '17 at 15:32

Lloople

3

This wouldn't always get you the right record, say you had a table of 40 rows, the updateOrCreate method updates id 20, neither of the above would return the one updated. The above would only work if it created a new record. – JLeggatt Oct 25 '17 at 15:40
Yes, you're right, you'll have to use `updated_at` if you're using timestamps. Otherwise there's no other way (unless you save the id like Alexey said. I thought the question was about different requests. – Lloople Feb 02 '18 at 08:17

2 Answers2