Laravel query builder sum

Select sum in laravel

Sometime for such queries you need to disable the strict check
 So inside config/database.php and inside mysql, 
 Set 'strict' => false,

->select('user_id', DB::raw('SUM(points) as total_points'))

Laravel query builder sum

$purchases = DB::table('transactions')
    ->join('categories', 'transactions.category_id', '=', 'categories.id')
    ->where('categories.kind', '=', 1)
    ->sum('transactions.amount');

Source: stackoverflow.com

Similar codes

1 vote225 views1 answer
Laravel date diff
PHP Laravel
1 vote184 views1 answer
Add a year php
PHP
15 votes187 views3 answers
Laravel make model with migration 5.8
PHP
1 vote241 views1 answer
Laravel make:listner
PHP Laravel
29 votes194 views6 answers
Hash php
PHP
1 vote292 views3 answers
Laravel invoice toturial
PHP Laravel
3 votes190 views1 answer
Check if post request php
PHP
0 vote210 views1 answer
How to create module in laravel
PHP
-1 vote172 views2 answers
Laravel latest
PHP
1 vote197 views2 answers
Regular expression for strong password in php
PHP