从数组中计算相同的类别，并使用其计数和类别名称存储在新数组中

Question

I have one array which I am getting from database query response.

Now I want to count same categories and print in option_name array. I have tried it with different array functions but want get desire output.

I have one idea to take new array and push it with foreach loop but not much idea of how can i achieve using code. Please help me to solve it.

Array
(
    [0] => Array
        (
            [CNC] => Array
                (
                    [id] => 5
                    [category_id] => 68
                )

            [GVO] => Array
                (
                    [option_name] => Actors
                )

        )

    [1] => Array
        (
            [CNC] => Array
                (
                    [id] => 11
                    [category_id] => 72
                )

            [GVO] => Array
                (
                    [option_name] => Cricketers
                )

        )

    [2] => Array
        (
            [CNC] => Array
                (
                    [id] => 3
                    [category_id] => 72
                )

            [GVO] => Array
                (
                    [option_name] => Cricketers
                )

        )

    [3] => Array
        (
            [CNC] => Array
                (
                    [id] => 4
                    [category_id] => 74
                )

            [GVO] => Array
                (
                    [option_name] => Musician 
                )

        )

    [4] => Array
        (
            [CNC] => Array
                (
                    [id] => 7
                    [category_id] => 76
                )

            [GVO] => Array
                (
                    [option_name] => Directors
                )

        )

    [5] => Array
        (
            [CNC] => Array
                (
                    [id] => 6
                    [category_id] => 76
                )

            [GVO] => Array
                (
                    [option_name] => Directors
                )

        )
)

Desire Output:

Array
(
    [Actors] => 1
    [Cricketers] => 2
    [Musician] => 1
    [Directors] => 2
)

Thanks in advance!

Answer 1

You simply need to loop through the array using foreach like as

$result = [];
foreach($arr as $k => $v){
    if(isset($result[$v['GVO']['option_name']])){
        $result[$v['GVO']['option_name']] += 1;
    }else{
        $result[$v['GVO']['option_name']] = 1;
    }
}

print_R($result);