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 vote262 views1 answer
Command "make:controller" is not defined.
PHP
0 vote263 views1 answer
Laravel 8 blade get days and hours ago
PHP
0 vote271 views1 answer
Php check if number between range
PHP
0 vote256 views1 answer
How to make a loop that adds numbers to a variable in php
PHP
0 vote282 views2 answers
Declare variable in view for loop laravel
PHP
3 votes280 views1 answer
Laravel cannot create an instance of class viewmodel
PHP
102 votes329 views6 answers
Php array push
PHP
0 vote279 views1 answer
Wcfm filter vendor dashboard widgets
PHP
0 vote259 views1 answer
Doctrine orm get all
PHP
0 vote254 views1 answer
The last ship -inurl:(htm/html/php/pls/txt) intitle:index.of "last modified" (mp4/wma/aac/avi)
PHP