laraveleloquentfluentlaravel-3

How to set every row to the same value with Laravel's Eloquent/Fluent?


I need to update all of the rows in a database so that a particular field in all of them is equal to a single value. Here's an example.

Let's say my database table is like so:

id data confirmed
1 someData 0
2 someData 1
3 someData 0

I want to perform a query that sets the confirmed field of every row to 1.

I could do it this way:

$rows = MyModel::where('confirmed', '=', '0')->get();
foreach($rows as $row) {
    $row->confirmed = 0;
    $row->save();
}

But it seems like there would be a better way? A single query that would just say "set every row's 'confirmed' field to 1."

Does such a query exist in Laravel's Eloquent/Fluent?


Solution

  • Well, an easy answer: no, you can't with eloquent. A model represents 1 row in the database, it wouldn't make sense if they implemented this.

    However, there is a way to do this with fluent:

    $affected = DB::table('table')->update(array('confirmed' => 1));
    

    or even better

    $affected = DB::table('table')->where('confirmed', '=', 0)->update(array('confirmed' => 1));