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 vote293 views1 answer
Set charset of response php
PHP
1 vote287 views2 answers
Doument root phpp
PHP
1 vote313 views1 answer
Error: Cannot redeclare composerRequire1d8e02dff94f518b7a14ddcb6710f10d() (previously declared in /Applications/XAMPP/xamppfiles/htdocs/all4learn2/Vendor/composer/autoload_real.php:66)
PHP
0 vote338 views1 answer
Diffforhumans laravel
PHP Laravel
1 vote326 views2 answers
Laravel form
PHP Laravel
2 votes349 views2 answers
Laravel validation unique email except self
PHP Laravel
3 votes280 views1 answer
Cannot use object of type App\ViewModels\Admin\Category\Category ViewModels as array (View: C:\OSPanel\domains\megaimkon.loc\resources\views\admin\category\index.blade.php)
PHP
0 vote284 views1 answer
Woocommerce change place order button text
PHP
0 vote246 views1 answer
How to open large csv files
PHP
2 votes313 views2 answers
Checking php version
PHP