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 vote294 views1 answer
Wordpress hook add javascript
PHP
2 votes323 views2 answers
Form submit self php isset
PHP
10 votes325 views4 answers
Error logs wp
PHP
0 vote351 views1 answer
Dd function not laravel
PHP Laravel
2 votes315 views2 answers
Utf8 encode php
PHP
18 votes311 views5 answers
Wp debug
PHP
1 vote314 views1 answer
Inrandomorder laravel
PHP
12 votes303 views6 answers
Php remove new line character from string
PHP
0 vote316 views1 answer
Override CouponPost.php
PHP
0 vote284 views1 answer
Laravel touches
PHP