how to bulk update in laravel 4

Question

Hi I was wondering how I can do a bulk update in laravel 4 rather then looping and updating in chunks?

I know bulk insert is like this:

$invoiceitem->insert($items_array);

You may see this one: http://stackoverflow.com/a/27539935/1318946 — Pratik Butani, Dec 18 '14 at 05:50

score 13 · Accepted Answer · answered May 27 '14 at 03:41

13

You could use eloquent.

Model::whereIn($items_array)->update(array('Foo' => 'Bar'));

answered May 27 '14 at 03:41

Wistar

5

Missing an arg: `Model::whereIn("id", $items_array)->update(array('Foo' => 'Bar'))`; – Jazzy Nov 09 '14 at 00:04

score 0 · Answer 2 · answered Mar 06 '21 at 16:24

0

Bulk update is easy by installing a simple package

Update multiple column in a table by a specific conditions also insert multiple row at a time

answered Mar 06 '21 at 16:24

Raj Mn

Given this question was asked nearly 7 years ago I double it needs an answer now :) – Holo Mar 06 '21 at 23:54

2 Answers2