Group array or laravel collection with similar objects and add count

Question

How can I get the count of occurrence of array items while keeping the values as well. e.g.

$items = [{code: "2132", tile:"Mechanical Engineers"}, 
          {code: "2134" title: "Chemical engineers"},
          {code: :2132, title: "Mechanical Engineers}]

What I would like to achive is something like as follows:

$sortedItems = [{code: "2134" title: "Chemical engineers", count:1},
                {code: "2132" title: "Chemical engineers", count:2}]

I'm using Larave and would like to get this either by using PHP array or even Laravel collection. Whichever works better.

Appreciate your help, as I am really stuck here and not sure how to proceed.

TsaiKoga · Accepted Answer · 2020-02-01 05:00:03Z

2

Use collection groupBy and map:

$items = '[{"code": "2132", "title":"Mechanical Engineers"},
             {"code": "2134", "title":"Chemical engineers"},
             {"code":"2132", "title":"Mechanical Engineers"}]';
$array = json_decode($items, true);

// try this:
$arr = collect($array)->groupBy('code')->map(function($item) {
    return array_merge($item->first(), array("count" => $item->count()));
})->all();

array_values($arr);

answered Feb 1, 2020 at 5:00

TsaiKoga

13.4k2 gold badges23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Group array or laravel collection with similar objects and add count

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related