CODEWITHSUNDEEP
phpmysqllaravellaravel-5.4laravel-query-builder
Amit Gupta
Amit Gupta

Reputation: 2806

Laravel 5.4: Directly Subtract number from column in database

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.

Upvotes: 5

Views: 17274

Answers (2)

Joel Hinz
Joel Hinz

Reputation: 25384

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.

Upvotes: 9

Sagar Gautam
Sagar Gautam

Reputation: 9369

You can do it with raw query like,

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

I hope you will understand.

Upvotes: 5

Related Questions