How to set every row to the same value with Laravel's Eloquent/Fluent?
Example:
id | data | confirmed
1 | someData | 0
2 | someData | 1
3 | someData | 0
id | data | confirmed
1 | someData | 0
2 | someData | 1
3 | someData | 0
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));
$affected = DB::table('table')->update(array('confirmed' => 1));
or even better
$affected = DB::table('table')->where('confirmed', '=', 0)->update(array('confirmed' => 1));
Update multiple records using Eloquent:
How can I update multiple rows with a single query like:
$update = mysql_query("update item_table set colour = 'black' where item_type_id = 1");
$update = mysql_query("update item_table set colour = 'black' where item_type_id = 1");
Solution:
ItemTable::where('item_type_id', '=', 1) ->update(['colour' => 'black']);
ItemTable::where('item_type_id', '=', 1) ->update(['colour' => 'black']);
id | data | confirmed
1 | someData | 0
2 | someData | 1
3 | someData | 0
id | data | confirmed
1 | someData | 0
2 | someData | 1
3 | someData | 0
EmoticonEmoticon