/PHP/Laravel/Sum row data and get all data eloquent laravel

Sum row data and get all data eloquent laravel

Laravel eloquent sum column

Product::where('id',$id)->sum('quantity');

Laravel sum column values

Auth::user()->products->sum('price');
// And on your App/User.php you need someting like this:
public function products(){
  return Products::where('id_buyer', Auth::user()->id)->get();
}

Sum row data and get all data eloquent laravel

$balance = DB::table('data')->where('user_id' '=' $id)->sum('balance');

-1

Similar codes

7 votes119 views5 answers
Laravel if else condition in blade file
PHP Laravel
1 vote112 views1 answer
How to add dummy records using factory in laravel 8
PHP Laravel
0 vote142 views1 answer
Laravel mixed content error
PHP Laravel
1 vote127 views1 answer
Laravel end date greater than start date validation
PHP Laravel
2 votes152 views1 answer
Laravel how to test email testing
PHP Laravel
1 vote122 views3 answers
Delete a migration laravel
PHP Laravel
8 votes125 views2 answers
Store file into specific directory laravel using storage facade
PHP Laravel
0 vote114 views1 answer
Laravel model uploaded file name
PHP Laravel
0 vote112 views1 answer
Multe data on database laravel
PHP Laravel
3 votes119 views1 answer
Phone number validation, laravel
PHP Laravel