How to count occurrence of values in multidimensional array in php

Question

First pardon me for the title as I couldn't find a proper title for it. Please have a look at the array

Array
(
[0] => Array
    (
        [0] => 2017
        [1] => Array
            (
                [0] => December
            )

    )

[1] => Array
    (
        [0] => 2017
        [1] => Array
            (
                [0] => December
            )

    )

[2] => Array
    (
        [0] => 2017
        [1] => Array
            (
                [0] => October
            )

    )

[3] => Array
    (
        [0] => 2016
        [1] => Array
            (
                [0] => December
            )

    )

 )

You can see 2017 is duplicated three times and inside 2017 December is duplicated two times. Now I want to get a multi dimensional array from this array that will show the occurrence of 2017 and it's month.

Something like

Array
(
  [2017] => 3
  [December]=> 2 // should be a nested array of 2017
  [October]=> 1 // should be a nested array of 2017
  [2016] => 1
  [December]=> 1 // should be a nested array of 2016
)

I tried array_count_values and some more custom code but all I managed to get

Array
(
[2017] => 3
[2016] => 1
)

Edit: The months count doesn't has be keyed like this. All I need to know year occurrence and month occurrence under the year

Any help is highly appreciated. Thanks.

Your expected results is not valid syntax. If you want the months as an nested array under the year, the count also needs to have a key. — Sean
– Sean, Commented Dec 22, 2017 at 2:31
Hi @Erwin it doesn't has to be keyed like this, all I need the month occurrence under the year. — Hkm Sadek
– Hkm Sadek, Commented Dec 22, 2017 at 2:38
Hi @Sean I didn't get this "the count also needs to have a key" — Hkm Sadek
– Hkm Sadek, Commented Dec 22, 2017 at 2:38

Goma · Accepted Answer · 2017-12-22 02:44:27Z

3

You can try to loop then check if year key and month key already exist

$group = [];
foreach ($array as $value) {
    $month = $value[1][0];
    if (!isset($group[$value[0]])) {
        $group[$value[0]] = array('count' => 0);
    }
    if (!isset($group[$value[0]][$month])) {
        $group[$value[0]][$month] = 0;
    }
    $group[$value[0]][$month] += 1;
    $group[$value[0]]['count'] += 1;
}

print_r($group);

If you don't necessarily need the count, you can change the first if condition's execution to $group[$value[0]] = array(); and the line $group[$value[0]]['count'] += 1;

foreach ($array as $value) {
    $month = $value[1][0];
    if (!isset($group[$value[0]])) {
        $group[$value[0]] = array();
    }
    if (!isset($group[$value[0]][$month])) {
        $group[$value[0]][$month] = 0;
    }
    $group[$value[0]][$month] += 1;
}

print_r($group);

answered Dec 22, 2017 at 2:44

Goma

1,9811 gold badge13 silver badges19 bronze badges

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

1 Comment

Hkm Sadek Over a year ago

Just like a boss! :) Thank you boss for such a nice solution!

Collectives™ on Stack Overflow

How to count occurrence of values in multidimensional array in php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related