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

13 votes344 views6 answers
Route group in laravel
PHP Laravel
13 votes356 views5 answers
Php get extension from string
PHP
29 votes325 views3 answers
Laravel clear page cache
PHP
1 vote378 views1 answer
Unless blade laravel
PHP
0 vote447 views1 answer
Wordpress loop over posts but exclude current post
PHP Wordpress
1 vote371 views1 answer
How to use bootstrap in laravel 8 remove tailwind
PHP Laravel
1 vote337 views2 answers
Db name laravel
PHP
0 vote364 views1 answer
Laravel get all users except role spatie
PHP Laravel
0 vote403 views1 answer
Php value to javascript variable laravel blade
PHP Laravel
0 vote339 views1 answer
Discord.py Levels
PHP