Increment value of multiple columns at once in Laravel
Laravel comes with handy little utilities when you want to increment or decrement the value of a column in a database table.
For instance, you can use the increment method to increment the value of a column by a given amount.
$user = DB::table('users')->find(1);
// increment the value of the `posts_count` column by 1
$user->increment('posts_count');
// increment the value of the `posts_count` column by 5
$user->increment('posts_count', 5);
Similarly, you can use the decrement method to decrement the value of a column by a given amount.
// decrement the value of the `available_credits` column by 100
$user->decrement('available_credits', 100);
Laravel 9.x comes with two new methods in the Illuminate\Database\Query\Builder class that can help you increment or decrement the value of multiple columns in a single query.
The incrementEach method
The incrementEach method allows you to increment the value of multiple columns in a single query.
DB::table('users')
->where('id', 1)
->incrementEach([
'posts_count' => 1,
'comments_count' => 1
], ['updated_at' => now()]);
As you can see, you can pass an array of columns and their values to the incrementEach method. The first argument is an array of columns and their values and the second argument is an array of columns and their values that you want to update.
The decrementEach method
Similarly, the decrementEach method allows you to decrement the value of multiple columns in a single query.
DB::table('users')
->where('id', 1)
->decrementEach([
'available_credit' => 100,
'reward_points' => 5
], ['updated_at' => now()]);
👋 Hi there! I'm Amit. I write articles about all things web development. If you like what I write and want me to continue doing the same, I would like you buy me some coffees. I'd highly appreciate that. Cheers!
