5

I want to subtract 100 number from credit column in database that is having int data type. I am looking for the way to directly subtract it with some Laravel query. But right now I first get the column value from the table and then subtract and then need to write update query to update it like below:

$subtractCredit = 100;

// Get Total Credit
$totalCredit = User::select('credit')->where(['username'=>$username])-
>first(); 

// Subtract 100 from Total Credit
$totalCredit = $totalCredit->credit - $subtractCredit;

// Update Credit in Table
User::where(['username'=>$username])->update(['credit' => $totalCredit]);

In the above code, I first get total credit from query and then subtract 100 from total credit and then update credit again with update query.

Please let me know the better approach of doing it.

Amit Gupta
  • 2,771
  • 2
  • 17
  • 31

2 Answers2

9

There's a built-in function to decrement:

User::where('username', $username)->decrement('credit', 100);

Docs: https://laravel.com/docs/5.4/queries#increment-and-decrement

Note that it's sugar for the update statement, so you don't need to call save() or update() afterwards.

Joel Hinz
  • 24,719
  • 6
  • 62
  • 75
5

You can do it with raw query like,

User::where('username', $username)
->update(array(
    'credit' => DB::raw('credit - 100')
));

I hope you will understand.

Sagar Gautam
  • 9,049
  • 6
  • 53
  • 84
  • Your alternative is also correct but I found decrement built-in function of laravel better. – Amit Gupta Nov 22 '17 at 10:34
  • @AmitGupta Yes this is one solution but solution provided above is better and you can make variable amount of decrement/increment with above solution – Sagar Gautam Nov 22 '17 at 10:36