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 vote197 views1 answer
Laravel update method resource
PHP Laravel
7 votes237 views3 answers
Laravel 8 – Remove Public from URL
PHP Laravel
13 votes213 views5 answers
Laravel validation custom message example
PHP Laravel
-1 vote226 views1 answer
Laravel merge two arrays helper
PHP Laravel
0 vote215 views1 answer
Laravel create coma separated string from query
PHP Laravel
0 vote298 views1 answer
Relationship on the base of condition in laravel
PHP Laravel
0 vote213 views1 answer
Laravel eloquent order by alphabetical order
PHP Laravel
5 votes196 views4 answers
Laravel model wherein
PHP Laravel
0 vote245 views2 answers
Laravel call controller method from view
PHP Laravel
5 votes198 views2 answers
Laravel migration change column length
PHP Laravel