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

13 votes291 views2 answers
Rename file php
PHP
0 vote304 views2 answers
Laravel gmail send mail 2020
PHP Laravel
16 votes322 views6 answers
Laravel redirect back
PHP
22 votes309 views2 answers
Where status is null sql in laravel
PHP
16 votes358 views6 answers
Laravel run migration
PHP Laravel
0 vote305 views2 answers
Get post date and time in wordpress
PHP
1 vote315 views1 answer
SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
PHP
0 vote322 views1 answer
The uploaded file exceeds the upload_max_filesize in laravel
PHP Laravel
3 votes345 views2 answers
Laravel required if it meet some value from another field
PHP Laravel
22 votes345 views5 answers
Get logged user id laravel
PHP Laravel