It turns out that in (Laravel Eloquent) there is an increment
and decrement
methods built in that you can use to increment or decrement a column value by a given amount.
For example, if you have a balance
column in your users
table, you can do something like this: $user->increment('balance', 100);
to add 100 to the user's balance. You can also do $user->decrement('balance', 100);
to subtract 100 from the user's balance.
But make sure that you are not using SIGNED INT for the column, otherwise you will have negative values. You can use UNSIGNED INT instead.
Resources:
- Laravel Eloquent increment()
Top comments (0)