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

4 votes37 views1 answer
Disable register laravel
PHP Laravel
0 vote28 views1 answer
Laravel: Session message exist while click on browser back button
PHP Laravel
0 vote39 views1 answer
Laravel include files
PHP Laravel
9 votes26 views2 answers
How to Log Query in Laravel
PHP Laravel
0 vote38 views1 answer
Current time input field in laravel form
PHP Laravel
0 vote32 views1 answer
Laravel withValidator
PHP Laravel
0 vote36 views1 answer
Sort by number of views descending laravel
PHP Laravel
0 vote38 views1 answer
Laravel validating birthdate by 13 years old
PHP Laravel
1 vote87 views2 answers
Get ip in laravel
PHP Laravel
0 vote35 views1 answer
Laravel move file from local to s3
PHP Laravel