How to Update Rows (with different data) in one DB Query Laravel

Question

I'm making a gallery with sortable photos with Laravel and jQuery UI Sortable.

My function in the controller gets a nice array:

$items = [0 => 22, 1 => 25, 2 => 45];

But there will be approx 150 - 200 photos in one gallery. Is there any chance to set one DB Query instead 150 - 200? Because my controller makes this at the moment...

<?php

foreach($photos['item'] as $position => $id){
    Photo::where('id', $id)->update(['position' => $position]);
}

But it creates approx 150 - 200 DB queries, which is awful.

Edit #1

Basically I need something like this (two corresponding arrays with ids and positions):

$ids =       [22, 24, 25, 34];
$positions = [0, 1, 2, 3];

Photos::where('id', $ids)->update(['position'] => $positions);

But I can't find anything about this approach.

is "mass update" there - https://laravel.com/docs/5.3/eloquent#updates not that you want ? — splash58, May 02 '17 at 18:57
Not so much. I need find many rows with different condition and put new data into them. — Michał Graczyk, May 02 '17 at 19:32
In you example, are you saying ID 22 will update with position 0, ID 24 will update with position 1, etc? — Samsquanch, May 02 '17 at 20:09
In that case, you'll end up having to make as many update queries as you need to make updates, unless you opt for something like [this](http://stackoverflow.com/questions/35915664/laravel-update-multiple-records-with-different-values). — Samsquanch, May 02 '17 at 22:21

score -2 · Answer 1 · edited May 23 '17 at 11:47

-2

Take a look here: Eloquent model mass update.

Basically, you are looking for a mass or bulk update.

edited May 23 '17 at 11:47

Community

1
1

answered May 02 '17 at 19:33

Jakub Kratina

644
6
14

How to Update Rows (with different data) in one DB Query Laravel

1 Answers1