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 vote195 views2 answers
Upload a pdf file laravel
PHP Laravel
6 votes217 views5 answers
Laravel collection map
PHP Laravel
0 vote210 views1 answer
Doiffernce between text and string in laravel migration
PHP Laravel
-1 vote217 views2 answers
Laravel pagination keep query string
PHP Laravel
12 votes202 views1 answer
Laravel model without timestamps
PHP Laravel
0 vote196 views1 answer
Laravel collection median
PHP Laravel
0 vote209 views1 answer
Laravel access storage attachment
PHP Laravel
11 votes214 views2 answers
Laravel mass update relationship
PHP Laravel
10 votes204 views2 answers
Laravel 8 try catch
PHP Laravel
0 vote197 views1 answer
Laravel how to query belongsTo relationship
PHP Laravel