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

0 vote150 views1 answer
Php get current url without filename
PHP
12 votes230 views6 answers
Php round down
PHP
0 vote231 views1 answer
Numberformater php format to k and m
PHP
1 vote169 views1 answer
Add 1 day php datetime
PHP
16 votes157 views1 answer
Php ?? operator
PHP
49 votes173 views6 answers
Laravel migrate seed
PHP
0 vote160 views1 answer
Magento 2 print php error
PHP
1 vote193 views1 answer
Problem 1 - phpspec/prophecy is locked to version 1.13.0 and an update of this package was not requested. - phpspec/prophecy 1.13.0 requires php ^7.2 || ~8.0, <8.1 -> your php version (8.1.2) does not satisfy that requirement.
PHP
0 vote165 views1 answer
Resubmit on refresh php
PHP
0 vote208 views1 answer
Php var_dump more readable
PHP