Level 102
I don't believe this to be possible (or rather it might be, but your query would have to be filled with a load of CASE statements)
Oct 8, 2019
5
Level 2
how to update all rows using one query?
Hello. please consider following data: $data=[ ['id'=>'1','stock'=>'12'], ['id'=>'2','stock'=>'13'] ]; how can I update all stocks using IDs using one query?
Level 13
Without Code ...... Just check like below,
public function update(Request $request)
{
$data = $request->all();
update($data);
}
Level 1
Stock::where('id',1)->get()->each( function($stock){
$stock-stock = 12;
});
change everything according to your model this way you can update with eloquent query
Level 2
this is okay but I think we are writing more than once, right?
Level 102
Yes. It will run for an update query for each item :)
Please or to participate in this conversation.