laravel db sum code example
Example 1: 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'))
Example 2: laravel not in query
DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();
Example 3: laravel sum column values
Auth::user()->products->sum('price');
public function products(){
return Products::where('id_buyer', Auth::user()->id)->get();
}