Update existing foreign key values using eloquent

Question

I am trying to update multiple rows of data with existing foreign key values where basket should only link to the foreign ID of 100.

Example:

id	title	basket_id (foreign key to another table)
1	apple	100
2	banana	200
2	kiwi	300

What I have tried:

$fruits = Fruit::whereIn('basket', [200, 300])->get();

foreach ($fruits as $fruit) {
  $fruit->update([
    "basket_id" => 100
  ])
}

This works fine, however, when I print $fruit, I am still getting the old basket_id in the relations attribute in eloquent.

Am I missing a step?

Thanks

Wahyu Kristianto · Accepted Answer · 2023-03-03T19:32:38.397

1

To fetch it, you can use the fresh() or refresh() on $fruit object, like this:

$fruits = Fruit::whereIn('basket', [200, 300])->get();

foreach ($fruits as $fruit) {
  $fruit->update([
    "basket_id" => 100
  ]);
  $fruit->refresh(); // Fetch updated object
}

https://laravel.com/docs/10.x/eloquent#refreshing-models

The fresh method will re-retrieve the model from the database. The existing model instance will not be affected:
$flight = Flight::where('number', 'FR 900')->first();
$freshFlight = $flight->fresh();
The refresh method will re-hydrate the existing model using fresh data from the database. In addition, all of its loaded relationships will be refreshed as well:
$flight = Flight::where('number', 'FR 900')->first();
$flight->number = 'FR 456';
$flight->refresh();
$flight->number; // "FR 900"

edited Mar 03 '23 at 19:32

answered Mar 03 '23 at 19:19

Wahyu Kristianto

8,719
6
43
68

Thank you, do I need to a save() after? – cafe123 Mar 03 '23 at 19:21
No. `update()` method already performs a save operation – Wahyu Kristianto Mar 03 '23 at 19:23
I see, what does `refresh()` do? does it do any updates to the DB? – cafe123 Mar 03 '23 at 19:24
`refresh()` method is used to reload the entire model instance and its relationships from the database, discarding any changes made to the model instance. – Wahyu Kristianto Mar 03 '23 at 19:26
When you call `$fruit->refresh()`, eloquent will reload the entire `$fruit` object from the database, along with its related object. @cafe123 – Wahyu Kristianto Mar 03 '23 at 19:27

Update existing foreign key values using eloquent

1 Answers1