如何合并包含子元素的数组

Question

我有一个具有相同customerid的数组。我想把所有相同的customerid数组合并成一个对数组几乎没有修正的数组。

Array
(
    [0] => Array
        (
            [customerid] => 13
            [customer_fullname] => Chris
            [profession_id] => 8
            [profession_name] => Producer
         )

    [1] => Array
        (
            [customerid] => 1
            [customer_fullname] => John
            [profession_id] => 8
            [profession_name] => Producer

        )

    [2] => Array
        (
            [customerid] => 13
            [customer_fullname] => Chris
            [profession_id] => 7
            [profession_name] => Camera

        )

)

所以现在我希望创建一个新的数组，如下所示：

Array(
    [customerid] => 13
    [customer_fullname] => Chris
    [new_array] => array(
        [0]=>[profession_id] => 8, [profession_name] => Producer, 
        [1]=>[profession_id] => 7, [profession_name] => Camera
    )
)

我花了一些时间在上面，但没能把它做好

Answer 1

如果你要合并很多记录，有更好的方法，但是如果你想要一种只合并两个记录的方法，我会这样做：

$array1 = array(
      'customerid' => 13
      'customer_fullname' => 'John',
      'profession_id' => 8,
      'profession_name' => 'Producer'
);
$array2 = array(
      'customerid' => 13
      'customer_fullname' => 'John',
      'profession_id' => 7,
      'profession_name' => 'Director'
);

function merge_customers($customerA, $customerB)
{
    $newCustomer = array();
    if ($customerA['customerid'] == $customerB['customerid'])
    {
        $newCustomer['customerid'] = $customerA['customerid'];
        $newCustomer['customer_fullname'] = $customerA['customer_fullname'];

        $newCustomer['new_array'] = array(
            array(
                'profession_id' => $customerA['profession_id'],
                'profession_name' => $customerA['profession_name']
            ),
            array(
                'profession_id' => $customerB['profession_id'],
                'profession_name' => $customerB['profession_name']
            )
        );

        return $newCustomer;
    }

    /* We can't merge these if they're different customers. */
    return NULL;
}

Answer 2

扩展的解决方案也非常适合于查找和“合并”具有相同customerid的多组条目。使用的函数：array_filter、array_count_values、array_keys、array_walk、array_chunk和array_values

// supposing $arr is your initial array

// finds which 'customerid' has multiple entries
$dupIds = array_filter(array_count_values(array_column($arr, "customerid")), function($v) {
    return $v > 1;
});

$dupIds = array_keys($dupIds);
$result = [];

array_walk($arr, function($v) use(&$result, $dupIds) {
    if (in_array($v['customerid'], $dupIds)) {
        $parts = array_chunk($v, 2, true);
        if (!isset($result[$v['customerid']])) {
            $result[$v['customerid']] = $parts[0] + ['new_array' => [$parts[1]]];
        } else {
            $result[$v['customerid']]['new_array'][] = $parts[1];
        }
    }
});

print_r(array_values($result));

输出：

Array
(
    [0] => Array
        (
            [customerid] => 13
            [customer_fullname] => Chris
            [new_array] => Array
                (
                    [0] => Array
                        (
                            [profession_id] => 8
                            [profession_name] => Producer
                        )

                    [1] => Array
                        (
                            [profession_id] => 7
                            [profession_name] => Camera
                        )
                )
        )
)

Answer 3

简而言之，也许有一个更好的解决方案。注意:第二个"for each“循环仅在两个数组有可能不具有相同字段时才需要。

function merge($array1, $array2){
     $result = array();
     foreach($array1 as $key => $value){
         if(isset($array2[$key]) && $array2[$key]!=$array1[$key]){
              $result[$key][]=$value;
              $result[$key][]=$array2[$key];
         }else{
              $result[$key]=$value;
         }
     }
     foreach($array2 as $key => $value){
        if(!isset($result[$key])){
             $result[$key] = $value;
        }
     }
     return $result;
}

print_r(merge($array1, $array2));