php二维数组多字段,php二维数组多字段排序实现mysql order功能

php二维数组多字段排序实现mysql order功能：即按照某个字段排序时如果字段相同，再按照第二个字段排序

使用php原生的array_multisort()函数，执行速度会快些且降低自定义函数的依赖，关于array_multisort详细使用 参考：http://blog..net/nuli888/article/details/52145187

function sortByCols($list,$field){

$sort_arr=array();

$sort_rule='';

foreach($field as $sort_field=>$sort_way){

foreach($list as $key=>$val){

$sort_arr[$sort_field][$key]=$val[$sort_field];

}

$sort_rule .= '$sort_arr["' . $sort_field . '"],'.$sort_way.',';

}

if(empty($sort_arr)||empty($sort_rule)){ return $list; }

eval('array_multisort('.$sort_rule.' $list);');//array_multisort($sort_arr['parent'], 4, $sort_arr['value'], 3, $list);

return $list;

}

$list = array(

array('id' => 1, 'value' => '1-1', 'parent' => 1),

array('id' => 2, 'value' => '2-1', 'parent' => 1),

array('id' => 3, 'value' => '3-1', 'parent' => 1),

array('id' => 4, 'value' => '4-1', 'parent' => 2),

array('id' => 5, 'value' => '5-1', 'parent' => 2),

array('id' => 6, 'value' => '6-1', 'parent' => 3),

);

$list = sortByCols($list, array(

'parent' => SORT_ASC,

'value' => SORT_DESC,

));

print_r($list);exit;

Array

(

[0] => Array

(

[id] => 3

[value] => 3-1

[parent] => 1

)

[1] => Array

(

[id] => 2

[value] => 2-1

[parent] => 1

)

[2] => Array

(

[id] => 1

[value] => 1-1

[parent] => 1

)

[3] => Array

(

[id] => 5

[value] => 5-1

[parent] => 2

)

[4] => Array

(

[id] => 4

[value] => 4-1

[parent] => 2

)

[5] => Array

(

[id] => 6

[value] => 6-1

[parent] => 3

)

)