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

Question

我从数据库查询响应中得到一个数组。

现在，我想计算相同的类别，并在option_name数组中打印。我尝试过用不同的数组函数，但希望得到渴望输出。

我有一个想法，采取新的数组，并推动它与foreach循环，但没有太多的想法，我如何能够实现使用代码。请帮我解决这个问题。

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
                )

        )
)

愿望输出：

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

提前感谢！

Answer 1

只需使用foreach循环数组，如

$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);

Answer 2

可以通过在键为option_name的关联数组中递增计数器来计数option_name值。

$counts = [];

foreach($array as $v) {
    if(!isset($counts[$v['GVO']['option_name']])) {
        $counts[$v['GVO']['option_name']] = 0;
    }

    $counts[$v['GVO']['option_name']]++;
}

print_r($counts);

Answer 3

尝试如下：

$new_arr = array();
foreach(array_column($your_arr, 'option_name') as $value){
    if(in_array($value, $new_array)){
        $new_array[$value] = $new_array[$value]+1;
    }else{
        $new_array[$value] = 1;
    }
}

输出

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