i want to calculate all numbers in one row from table?

Question

I want to calculate all numbers in one row from table and get the resulting in blade, how can ? i'm using Laravel 5.3? this my try:

{{ $posts = App\Post::where(['counts' => allOf()])->count() }}

and this:

{{ $posts = App\Post::orderBy('counts', '=', '*')->count() }}

but this not working

`first()` instead of `count()` maybe? And then do whatever calculations you need? Only thing I can assume from what is given. — Das, Sep 14 '17 at 22:10
i have a row in table, this row contains a matrix of numbers, i want to calculate this numbers and get the resulting in blade, the row is " counts " in " posts " table @RutvijKothari — Mohamed Hamdy, Sep 14 '17 at 22:38
It is unclear what you are trying to query, at least to me. Are you trying to get the count of ALL your rows of your `Post` table, or are you trying to count ALL the rows of the `Post` table that have the count attribute not null or bigger than 0? — idelara, Sep 14 '17 at 22:48
Do you want to have a sum of all `counts`? Is the `counts` column an integer like 12345? — shukshin.ivan, Sep 14 '17 at 22:50
Are you looking for something like this [enter link description here](https://stackoverflow.com/questions/2179207/sum-values-of-a-single-row) — Mahi, Sep 15 '17 at 05:59

aknosis · Answer 1 · 2017-09-14T22:55:32.127

2

It sounds like you want the SUM of the count?

If you are using the query builder directly you could use sum('count').

Since you appear to be using eloquent you should use App\Post::all()->sum('count')

This will gather all the posts into a collection and then sum the count field.

Edit...

Might also try App\Post::sum('count')

edited Sep 14 '17 at 22:55

answered Sep 14 '17 at 22:50

aknosis

If App\Post::sum('count') works, that is the most performant option. This will run a sum() query at the database level rather than all()->sum() which would have to query all rows and then sum the count in php. – aknosis Sep 15 '17 at 15:58

1 Answers1