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

0 vote165 views1 answer
If condition view page of laravel
PHP Laravel
2 votes163 views1 answer
Laravel get only the Ids of an eloquent arrays
PHP Laravel
9 votes159 views5 answers
Return view with variable laravel
PHP Laravel
1 vote178 views1 answer
StorePublicly laravel with name
PHP Laravel
8 votes153 views2 answers
Laravel passport
PHP Laravel
1 vote163 views1 answer
Laravel Validation check array size min and max
PHP Laravel
12 votes148 views3 answers
How to log object laravel logger
PHP Laravel
0 vote142 views1 answer
Laravel number input positive only
PHP Laravel
0 vote169 views1 answer
Laravel DB facade relations
PHP Laravel
20 votes170 views6 answers
Laravel 8 make:auth
PHP Laravel