2021-06-28

问题：两个数组有相同的字段，将两个数组合并，然后根据共有的字段，对数组排序。

演示代码是在php5.6中运行的结果

示例数组

例子：数组$a和$b都有id，将两个数组合并后，根据id来排序

// 二维数组1
$a = [
    ['id'=>1, 'name'=>'LiLei', 'country'=>'china', 'sort'=>1],
    ['id'=>2, 'name'=>'Lucy', 'country'=>'english', 'sort'=>1],
    ['id'=>3, 'name'=>'Julie', 'country'=>'france', 'sort'=>1],
    ['id'=>4, 'name'=>'Агата', 'country'=>'russia', 'sort'=>1],
    ['id'=>5, 'name'=>'Alessandro', 'country'=>'italy', 'sort'=>1]
];

//二维数组2
$b = [
    ['id'=>5,'age'=>18,'sort'=>2],
    ['id'=>3,'age'=>114,'sort'=>2],
    ['id'=>1,'age'=>17,'sort'=>2],
];

合并数组

如果数组子元素完全相同，需要注意覆盖问题

//把一个或多个数组合并为一个数组
$c = array_merge($a,$b);
//注释：如果两个或更多个数组元素有相同的键名，则最后的元素会覆盖其他元素。

数组排序

// 对多个数组或多维数组进行排序
array_multisort(
    array &$array1,
    mixed $array1_sort_order = SORT_ASC,
    mixed $array1_sort_flags = SORT_REGULAR,
    mixed $... = ?
): bool

参数：$array1_sort_order的值，SORT_ASC 按照上升顺序排序， SORT_DESC 按照下降顺序排序

根据id的 正序 来排序

//获取所有id的数组
$ids = array_column($c,'id');
//排序$c
array_multisort($ids,SORT_ASC, $c);
print_r($c)

排序结果

Array (
    [0] => Array (
            [id] => 1
            [age] => 17
            [sort] => 2
        )
    [1] => Array (
            [id] => 1
            [name] => LiLei
            [country] => china
            [sort] => 1
        )
    [2] => Array (
            [id] => 2
            [name] => Lucy
            [country] => english
            [sort] => 1
        )
    [3] => Array (
            [id] => 3
            [age] => 114
            [sort] => 2
        )
    [4] => Array (
            [id] => 3
            [name] => Julie
            [country] => france
            [sort] => 1
        )
    [5] => Array (
            [id] => 4
            [name] => Агата
            [country] => russia
            [sort] => 1
        )
    [6] => Array (
            [id] => 5
            [age] => 18
            [sort] => 2
        )
    [7] => Array (
            [id] => 5
            [name] => Alessandro
            [country] => italy
            [sort] => 1
        )
)

根据id的 倒序 和sort的 正序 来排列

//如果需要根据id和sort来排序
foreach($c as $k=>$v){
	$ids[$k] = $v['id'];
	$sort[$k] = $v['sort'];
}
//排序$c，优先按id排序，然后按sort排序
array_multisort($ids,SORT_DESC,$sort, SORT_ASC, $c);
print_r($c);

排序结果

Array (
    [0] => Array (
            [id] => 5
            [name] => Alessandro
            [country] => italy
            [sort] => 1
        )
    [1] => Array (
            [id] => 5
            [age] => 18
            [sort] => 2
        )
    [2] => Array (
            [id] => 4
            [name] => Агата
            [country] => russia
            [sort] => 1
        )
    [3] => Array (
            [id] => 3
            [name] => Julie
            [country] => france
            [sort] => 1
        )
    [4] => Array (
            [id] => 3
            [age] => 114
            [sort] => 2
        )
    [5] => Array (
            [id] => 2
            [name] => Lucy
            [country] => english
            [sort] => 1
        )
    [6] => Array (
            [id] => 1
            [name] => LiLei
            [country] => china
            [sort] => 1
        )
    [7] => Array (
            [id] => 1
            [age] => 17
            [sort] => 2
        )
)