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 vote183 views2 answers
How to rollback if one table in laravel didn't save data successfully
PHP
0 vote171 views1 answer
Set owner symfony
PHP
0 vote204 views1 answer
Set owner symfony
PHP Symfony
0 vote202 views1 answer
Codeigniter update or create
PHP CodeIgniter
2 votes184 views2 answers
Target class [AppHttpControllersRegisterController] does not exist. laravel 8
PHP Laravel
1 vote174 views1 answer
Laravel get first letter of each word
PHP
2 votes186 views1 answer
You can also run `php --ini` in a terminal to see which files are used by PHP in CLI mode. Alternatively, you can run Composer with `--ignore-platform-req=ext-mb
PHP
0 vote220 views1 answer
Woocommerce coupon notifie a spefic email
PHP
0 vote185 views1 answer
How to put multiple string in one echo in php
PHP
1 vote197 views2 answers
Laravel api too many requests
PHP Laravel