php 多维数组排序,根据某一列排序(array_multisort()和array_column()联用)
array_multisort()和array_column()联用效果直接叠满,1+1>100
先来看下两个函数的介绍和用法
array_column():
一般模式,不需要其中字段作为id,只需要提取val值
<?php
// 可能从数据库中返回数组
$a = [['id' => 5698, 'first_name' => 'Peter', 'last_name' => 'Griffin', ], [ 'id' => 4767, 'first_name' => 'Ben', 'last_name' => 'Smith', ], [ 'id' => 3809, 'first_name' => 'Joe', 'last_name' => 'Doe', ],];
$last_names = array_column($a, 'last_name');
print_r($last_names);//最简单模式
/*
Array( [0] => Griffin [1] => Smith [2] => Doe
)
*/
?>升级模式,需要其中字段作为id,另一字段作为val值
<?php
// 可能从数据库中返回数组
$a = [['id' => 5698, 'first_name' => 'Peter', 'last_name' => 'Griffin', ], [ 'id' => 4767, 'first_name' => 'Ben', 'last_name' => 'Smith', ], [ 'id' => 3809, 'first_name' => 'Joe', 'last_name' => 'Doe', ],];
$last_names = array_column($a, 'last_name' ,'id');
print_r($last_names);//id作为key,last_name作为val
/*
Array( [5698] => Griffin [4767] => Smith [3809] => Doe)
*/array_multisort():
返回一个升序排列的数组：
<?php
$a1=array("Dog","Cat");
$a2=array("Fido","Missy");
array_multisort($a1,$a2);
print_r($a1);
print_r($a2);
/*返回结果
Array ( [0] => Cat [1] => Dog ) Array ( [0] => Missy [1] => Fido )
*/
?>当两个值相同时如何排序：
<?php
$a1=array("Dog","Dog","Cat");
$a2=array("Pluto","Fido","Missy");
array_multisort($a1,$a2);
print_r($a1);
print_r($a2);
/*返回结果
Array (
[0] => Cat
[1] => Dog
[2] => Dog
)
Array (
[0] => Missy
[1] =>
Fido [2] => Pluto
)
*/
?>使用排序参数：
<?php
$a1=array("Dog","Dog","Cat");
$a2=array("Pluto","Fido","Missy");
array_multisort($a1,SORT_ASC,$a2,SORT_DESC);
print_r($a1);
print_r($a2);
/*返回结果
Array (
[0] => Cat
[1] => Dog
[2] => Dog
)
Array (
[0] => Missy
[1] => Pluto
[2] => Fido
)
*/
?>合并两个数组，并按数字降序排列：
<?php
$a1=array(1,30,15,7,25);
$a2=array(4,30,20,41,66);
$num=array_merge($a1,$a2);
array_multisort($num,SORT_DESC,SORT_NUMERIC);
print_r($num);
/*返回结果
Array (
[0] => 66
[1] => 41
[2] => 30
[3] => 30
[4] => 25
[5] => 20
[6] => 15
[7] => 7
[8] => 4
[9] => 1
)
*/
?>以上是对两个函数的介绍和使用方法举例
下面开始合体进化,直接直呼我滴个*:
首先扩展下array_multisort(),如果对多个数组进行排序，排序结果是所有的数组都按第一个数组的顺序进行排列
<?php
$a1 = ['c', 'b', 'a'];
$a2 = ['b', 'c', 'a'];
$a3 = ['b', 'a', 'c'];array_multisort($a1,$a2,$a3);
print_r($a1);print_r('<br>');
print_r($a2);print_r('<br>');
print_r($a3);print_r('<br>');
/*输出结果
Array ( [0] => a [1] => b [2] => c )
Array ( [0] => a [1] => c [2] => b )
Array ( [0] => c [1] => a [2] => b )
*/
?>然后开始合体:
1.将多维数组按照某一列的字段来进行排序
<?php
$data[] = array('volume' => 67, 'id' => 2);
$data[] = array('volume' => 86, 'id' => 1);
$data[] = array('volume' => 86, 'id' => 3);
$data[] = array('volume' => 85, 'id' => 6);
$data[] = array('volume' => 98, 'id' => 2);
$data[] = array('volume' => 86, 'id' => 6);
$data[] = array('volume' => 67, 'id' => 7);array_multisort(array_column($data, 'volume'), SORT_DESC,$data);//按volume倒序排/*输出结果
array(7) {
[0]=> array(2) {
["volume"]=> int(98) ["id"]=> int(2)
}
[1]=> array(2) {["volume"]=> int(86) ["id"]=> int(1)
}
[2]=> array(2) {
["volume"]=> int(86) ["id"]=> int(3)}
[3]=> array(2) {["volume"]=> int(86) ["id"]=> int(6)}
[4]=> array(2) {["volume"]=> int(85) ["id"]=> int(6)
}
[5]=> array(2) {["volume"]=> int(67) ["id"]=> int(2)}
[6]=> array(2) {
["volume"]=> int(67) ["id"]=> int(7)
}
}
*/
?>2.按volume倒序排，volume相同时，按id正序排
<?php
$data[] = array('volume' => 67, 'id' => 2);
$data[] = array('volume' => 86, 'id' => 1);
$data[] = array('volume' => 86, 'id' => 3);
$data[] = array('volume' => 85, 'id' => 6);
$data[] = array('volume' => 98, 'id' => 2);
$data[] = array('volume' => 86, 'id' => 6);
$data[] = array('volume' => 67, 'id' => 7);array_multisort(array_column($data,'volume'), SORT_DESC, array_column($data,'id'), SORT_ASC, $data);//按volume倒序排，volume相同时，按id正序排/*输出结果
array(7) {
[0]=> array(2)
{
["volume"]=> int(98) ["id"]=> int(2)
}
[1]=> array(2) {["volume"]=> int(86) ["id"]=> int(1)
}
[2]=> array(2) {
["volume"]=> int(86) ["id"]=> int(3)}
[3]=> array(2) {
["volume"]=> int(86) ["id"]=> int(6)
}
[4]=> array(2) {["volume"]=> int(85) ["id"]=> int(6)
}
[5]=> array(2) { ["volume"]=> int(67) ["id"]=> int(2)
}
[6]=> array(2) { ["volume"]=> int(67) ["id"]=> int(7)
}
}
*/
?>3.按照年龄从大到小的顺序排列，如果年龄相同就按照名字升序排序
<?php$array = [["age" => 20, "name" => "a"],["age" => 21, "name" => "d"],["age" => 22, "name" => "e"],["age" => 20, "name" => "b"],["age" => 25, "name" => "c"]];array_multisort(array_column($array,'age'),SORT_NUMERIC,SORT_DESC,array_column($array,'name'),SORT_STRING,SORT_ASC,$array);
print_r($array);
/*返回结果
Array
([0] => Array([age] => 25[name] => c)[1] => Array([age] => 22[name] => e)[2] => Array([age] => 21[name] => d)[3] => Array([age] => 20[name] => a)[4] => Array([age] => 20[name] => b)
)
*/
?>到此撒花.