How do I count the number of Items in a grouped collection in Laravel?

Question

Please I want to count the number of Items in each grouped collection. assuming the collection returns three group Items, I want to count the collection in each group

I did this but it isn't working out for me

$collection = Vendor::all();
$grouped = $collection->groupBy('vendor_discount');
$counted = $grouped->countBy();
return $counted->all();

this is the error am getting back

array_key_exists(): The first argument should be either a string or an integer

by doing this

$user_info = DB::table('vendors')
                 ->select('vendor_discount', DB::raw('count(*) as total'))
                 ->groupBy('vendor_discount')
                 ->get();

this is the results

0: {vendor_discount: null, total: 1}
total: 1
vendor_discount: null
1: {vendor_discount: "10%", total: 2}
total: 2
vendor_discount: "10%"
2: {vendor_discount: "20%", total: 2}
total: 2
vendor_discount: "20%"

how do I correctly display in a view template?

https://stackoverflow.com/questions/18533080/laravel-eloquent-groupby-and-also-return-count-of-each-group — Vivek Choudhary, Oct 15 '20 at 17:05
Hey, It works but am find it difficult to display in a view template — Prince Asamoah, Oct 15 '20 at 17:12
```0: {vendor_discount: null, total: 1} total: 1 vendor_discount: null 1: {vendor_discount: "10%", total: 2} total: 2 vendor_discount: "10%" 2: {vendor_discount: "20%", total: 2} total: 2 vendor_discount: "20%"``` — Prince Asamoah, Oct 15 '20 at 17:17
I have updated the question. Kindly check for the correction representation of the collection — Prince Asamoah, Oct 15 '20 at 17:23
at the end of your query use ->get()->toArray(); which will give you your result in an array. Just read the array. — Vivek Choudhary, Oct 15 '20 at 17:25

score 0 · Accepted Answer · answered Oct 15 '20 at 17:41

0

Your Query

$user_info = DB::table('vendors')
                 ->select('vendor_discount', DB::raw('count(*) as total'))
                 ->groupBy('vendor_discount')
                 ->get()->toArray();

return $user_info;

then in the view file

//Loop through the values
foreach($user_info as $user){
    echo $user->vendor_discount." - ".$user->total;
}

answered Oct 15 '20 at 17:41

Vivek Choudhary

634
8
14

It works..Was able to display in Vue template too..Thanks alot – Prince Asamoah Oct 15 '20 at 17:43

How do I count the number of Items in a grouped collection in Laravel?

1 Answers1