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 vote267 views1 answer
Laravel routes return view in web.php
PHP Laravel
0 vote293 views1 answer
How to stop message of laravel mix
PHP Laravel
0 vote302 views1 answer
Laravel httaccess for apache
PHP Laravel
0 vote294 views1 answer
Laravel - Query Builder Raw Query selectRaw
PHP Laravel
4 votes281 views1 answer
Laravel deployment
PHP Laravel
0 vote303 views1 answer
Laravel 8 Auth Scaffolding using Inertia Jetstream
PHP Laravel
1 vote251 views3 answers
Required_if laravel
PHP Laravel
0 vote298 views1 answer
How to separate admin and user login in laravel
PHP Laravel
0 vote308 views1 answer
<warning>PHP Warning: preg_grep() expects parameter 2 to be array, string given in G:\Office Projects\Luggage Backend\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Concerns \Guards Attributes.php on line 207</warning>
PHP Laravel
16 votes243 views2 answers
How to save information on pdf file in laravel project
PHP Laravel