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 vote142 views1 answer
How to catch query exception in laravel 8
PHP Laravel
0 vote152 views2 answers
Laravel log could not be opened fix
PHP Laravel
46 votes178 views6 answers
Laravel make controller with model
PHP Laravel
0 vote149 views1 answer
Laravel max length format
PHP Laravel
2 votes140 views1 answer
Laravel catch exception ex log save
PHP Laravel
18 votes142 views6 answers
Install laravel auth
PHP Laravel
49 votes183 views6 answers
Laravel add column to existing table
PHP Laravel
6 votes161 views2 answers
Findorfail laravel
PHP Laravel
1 vote146 views2 answers
Laravel update email unique
PHP Laravel
0 vote160 views1 answer
Laravel checkbox checked
PHP Laravel