萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> PHP 程式設計

PHP 二維陣列合併與重組實戰技巧

場景一:交錯鍵值重組為記錄

資料庫查詢回傳交錯結構:

$showinfo = [
    ['A' => 'store_name', 'B' => '商店一'],
    ['A' => 'store_owner', 'B' => '小風'],
    ['A' => 'store_name', 'B' => '商店二'],
    ['A' => 'store_owner', 'B' => '小磊'],
];

目標重組為:

// 期望結果
[
    ['name' => '商店一', 'owner' => '小風'],
    ['name' => '商店二', 'owner' => '小磊'],
]

解法:for 迴圈步進 2

$stores = [];
$count = count($showinfo);
for ($i = 0; $i < $count; $i++) {
    $j = $i + 1;
    $stores[] = [
        'name'  => $showinfo[$i]['B'],
        'owner' => $showinfo[$j]['B'],
    ];
    $i = $j; // 跳過下一筆
}

場景二:多組鍵值聚合去重

原始資料:

$arr = [
    0 => ['1@01,02', '2@01,02', '4@ALL', '3@01', '5@01,02,04'],
    1 => ['1@01,02,03', '2@01,02,04', '3@ALL', '4@01,02', '111@01,05', '5@03'],
    2 => ['1@01,02,03', '2@02,03,05', '3@ALL', '4@01,02,03', '111@01,05', '5@03'],
];

目標:依鍵名(@ 前)聚合值,去重,ALL 覆蓋所有值:

$result = [];
foreach ($arr as $items) {
    foreach ($items as $item) {
        [$key, $val] = explode('@', $item);
        $result[$key] .= $val . ',';
    }
}

function reJoin(&$item, $key, $sep) {
    $list = array_unique(explode($sep, $item));
    $item = in_array('ALL', $list) 
        ? "$key@ALL" 
        : "$key@" . implode($sep, $list);
}
array_walk($result, 'reJoin', ',');
sort($result);

結果:

[
    '111@01,05',
    '1@01,02,03',
    '2@01,02,03,04,05',
    '3@ALL',
    '4@ALL',
    '5@01,02,03,04',
]

通用合併函數:array_merge_recursive

$a = ['color' => ['red'], 'size' => 'M'];
$b = ['color' => ['blue'], 'size' => 'L'];
print_r(array_merge_recursive($a, $b));
// color => [red, blue], size => [M, L] (數值鍵會重新索引)

注意:字串鍵合併為陣列,數值鍵重新索引附加。

copyright © 萬盛學電腦網 all rights reserved