从通过wordpress查询获取的多维对象数组中删除重复项

Question

I am trying to get POST data based on a query, but I get duplicate results. I tried sort regular but still it shows many duplicates. What should I do?

My code (as shown below) prints repeated object IDs in the foreach loop. Here, object_id = 2423 repeats. I want to keep one and delete the other other.

$vbn = $wpdb->get_results($query_cat_filter);
$bbc = array_unique($vbn, SORT_REGULAR);

foreach( $bbc as $cOM){
    print_r($bbc);
}   

Output:

Array
(
    [0] => stdClass Object
        (
            [object_id] => 2415
            [term_taxonomy_id] => 242
            [term_order] => 0
        )

    [1] => stdClass Object
        (
            [object_id] => 2423
            [term_taxonomy_id] => 242
            [term_order] => 0
        )

    [2] => stdClass Object
        (
            [object_id] => 2423
            [term_taxonomy_id] => 312
            [term_order] => 0
        )
)

How can I remove these duplicate values?

Answer 1

There maybe be a native function to do that, however, when I want to organize by key, I use a function like so. Note: I haven't tried it on an object, so you may have to first convert your objects to array by using (array):

<?php
    function organize($array = array(), $assockey = false,$forcerows = false)
        {
            if(!empty($array)) {
                    $i = 0;
                    foreach($array as $rows) {
                            if(is_array($rows)) {
                                    foreach($rows as $key => $value) {
                                            if(!empty($rows[$assockey])) {
                                                $_key   =   $rows[$assockey];
                                                $new[$_key][$i][$key]   =   $value;
                                            }
                                        }
                                }
                            $i++;
                        }
                }
            if(isset($new)) {
                    foreach($new as $key => $value) {
                            if(count($value) == 1) {
                                    $keyName    =   array_keys($value);
                                    $new[$key]  =   ($forcerows == true)? array_values($value):$value[$keyName[0]];
                                }
                            else {
                                    $new[$key]  =   array_values($value);
                                }
                        }
                }

            return (isset($new))? $new : $array;
        }

 // Starting input      
 $vals  =   array(
            '0' => array(
                    'object_id' => 2415,
                    'term_taxonomy_id' => 242,
                    'term_order' => 0,),
            '1' => array(
                    'object_id' => 2423,
                    'term_taxonomy_id' => 242,
                    'term_order' => 0,
                ),
            '2' => array(
                    'object_id' => 2423,
                    'term_taxonomy_id' => 312,
                    'term_order' => 0
                )
            );

    // Organize by key          
    $arr    =   organize($vals,'object_id',true);
    print_r($arr);
?>

Gives you an array like so:

Array
(
    [2415] => Array
        (
            [0] => Array
                (
                    [object_id] => 2415
                    [term_taxonomy_id] => 242
                    [term_order] => 0
                )

        )

    [2423] => Array
        (
            [0] => Array
                (
                    [object_id] => 2423
                    [term_taxonomy_id] => 242
                    [term_order] => 0
                )

            [1] => Array
                (
                    [object_id] => 2423
                    [term_taxonomy_id] => 312
                    [term_order] => 0
                )

        )

)

From here, you can just use key [0] of each array.