How to get count of each result

Question

How can I get the total number of records for each of the grouped column(some_id) results generated in this eloquent query? (Answers generated using DB query builder or vanilla PHP also welcome).

$results = \App\MyModel::groupBy('some_id') ->whereNotNull('some_id') // some query here to get sum of each grouped column records ->get();

The desired result would be such that when I'm looping through the results, I can also have a field called for example totalRecords for each grouped results. i.e.

foreach($results as $result) { echo $result->totalRecords; }

you can use method $result->count(), also in foreach loop based on your defined relation with other models, you can also do $result->relation_model->count — ankit patel
– ankit patel, Commented Jul 30, 2018 at 4:04
@ankitpatel not exactly what I'm looking form please see the edited question — Cepheus
– Cepheus, Commented Jul 30, 2018 at 4:12

mighty_dev · Accepted Answer · 2018-07-30 04:16:10Z

$results = DB::table('your_table') ->select('some_column_name', DB::raw('count(some_id) as totalRecords')) ->whereRaw('some_id IS NOT NULL') ->groupBy('some_id') ->get();

Jagjeet Singh · Accepted Answer · 2018-07-30 04:19:48Z

2

You can do like this :-

$results = \App\MyModel::select('*', DB::raw('count(some_id) as totalRecords')) ->groupBy('some_id') ->whereNotNull('some_id') ->get(); foreach ($results as $result) { echo $result->totalRecords; }

edited Jul 30, 2018 at 4:19

answered Jul 30, 2018 at 4:08

Jagjeet Singh

1,5721 gold badge12 silver badges23 bronze badges

2 Comments

Cepheus Over a year ago

Not exactly what I'm looking form please see the edited question

Jagjeet Singh Over a year ago

Updated answer!

Gautam Patadiya · Accepted Answer · 2018-07-30 04:26:17Z

Collection Provide itself count() method. But sometime once you fetch whole collection using get(). You can use count method on collection something like this:

$results = \App\MyModel::groupBy('some_id') ->whereNotNull('some_id') // some query here to get sum of each grouped column records ->get(); dd($results->count());

Also, If your data is not collection then Php array's provide you count method you can use that too:

dd(count($results));

I used dd method just for debuging purpose.That will show you result before actual output.

count() method of array will help you to count collection as well as sub collection or array of sub array.

Good luck !!!

Well Laravel providing Eloquant system and also providing count method then why we need to use DB query. I more prefer count method instead of raw query. But that's my personal thought.
Read on a concept called subqueries, that's what was needed here.

Collectives™ on Stack Overflow

How to get count of each result

3 Answers 3

Comments

2 Comments

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

3 Comments

Related