Laravel - update data from array

Question

I want update an array of ids.

Eloquent Query

$my_ids = json_encode($request->post('my_ids'));
Lead::whereIn('id', $my_ids)->update(['op' => 2]);

but I need to pass a string with comma.

How can I solve it?

$my_ids is an array from strings. If you want update all of them you should use foreach: foreach($my_ids as $id){Lead::whereIn('id', $id)->update(['op' => 2]); } — akbar
– akbar, Commented Apr 17, 2022 at 10:02
In this way not runs a lot of query? I'd like to make a query only. — cloude
– cloude, Commented Apr 17, 2022 at 10:04
In your solution, convert $my_ids to int.like this:(int)$my_ids — akbar
– akbar, Commented Apr 17, 2022 at 10:11

Tra Lee · Accepted Answer · 2022-04-17 10:44:01Z

2

I believe the ids you receive from post request is object string so you need to decode that string in order to get an array.

$my_ids = json_decode($request->post('my_ids'), true);
Lead::whereIn('id', $my_ids)->update(['op' => 2]);

answered Apr 17, 2022 at 10:44

Tra Lee

1131 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1