/PHP/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

8 votes148 views6 answers
Codeigniter 4 get last query
PHP
1 vote96 views1 answer
Phpmyadmin delete all tables
PHP
0 vote125 views6 answers
Pass all data to all pages laravel
PHP Laravel
1 vote159 views1 answer
Datediff in hour query builder laravel
PHP
0 vote130 views2 answers
Laravel undefined index
PHP Laravel
1 vote94 views2 answers
Php echo number 2 decimal places "print_r"
PHP
13 votes113 views6 answers
How to create model in laravel
PHP
0 vote150 views1 answer
Laravel get previous route without domain
PHP Laravel
0 vote102 views1 answer
Foreach loop 1-100 php
PHP
3 votes107 views2 answers
Round to 2 decimal places php
PHP