Add the number gotten from a db

Question

I collected data from a database and the data is based upon user id, ie I select data from database table based on a user id. Now the selected result has some value (numbers); how do I check if that total sum of the number is equal to a certain amount?

Using Laravel 5.4, I query my db as follows:

 $money = $DBTable::where('id', Auth::user()->id)->get();

Now I have a column called cash how do I get the total sum of the cash column? What is the code for that since the result is an object I do a foreach loop

 foreach ($money as $key => $value) {
     count($money->cash);
 }

this will return the number count of the value:

 foreach ($money as $key => $value) {
     echo $earn->earned_amount + $earn->earned_amount;  
 }

This will add up individual values to themselves, so please can anyone tell me how this is done?

Fred please read what i wrote carefully dont be quick to reply. I want to count the value gotten from my column — dagogodboss, Mar 31 '17 at 14:57
Say user have 10k from row 1 20k from two etc how do i add this column from row one, two .. — dagogodboss, Mar 31 '17 at 14:59
Why did you do that. you dont have the answer why would you answer. — dagogodboss, Mar 31 '17 at 15:00
Possibly this would help? http://stackoverflow.com/questions/4586040/mysql-sum-elements-of-a-column SUM mysql keyword — John Cogan, Mar 31 '17 at 15:01
Laravel, not sure never used it. the SUM statement is part of the SQL langauge so should be independant of your PHP framework. Just try it. Experiment — John Cogan, Mar 31 '17 at 15:06
DB::table('table name') ->where('id', Auth::user()->id) ->sum('cash'); — Indra, Mar 31 '17 at 15:13

Indra · Accepted Answer · 2017-03-31T15:27:17.320

There are two ways to do this:

The Query builder way (https://laravel.com/docs/5.4/queries#aggregates)

DB::table('table name')->where('user_id', Auth::user()->id) ->sum('cash');
The eloquent way (https://laravel.com/docs/5.4/collections#method-sum)

Auth::user()->cashTransactions->pluck('cash')->sum('price');

I assumed you table $DBTable has a model attached to it and that you have a relationship defined between the table's model and the user model

To define relationship you do:

in User model:

public function cashTransactions()
{
     return $this->hasMany('App\CashTransactions');
}

in CashTransactions model:

public function user()
    {
         return $this->belongsTo('App\User');
    }

Edit: you can also define relationships in a model with the same model (self relationship)

Add the number gotten from a db

1 Answers1