PHP 按两个字段值对数组进行排序 [英] PHP sort array by two field values

问题描述

我有一个这样的数组

<前>大批 ([0] => Array( "目的地" => "悉尼","航空公司" => "airline_1","one_way_fare" => 100,"return_fare => 300),[2] => Array( "目的地" => "悉尼","航空公司" => "airline_2","one_way_fare" => 150,"return_fare => 350),[3] => Array( "目的地" => "悉尼","航空公司" => "airline_3","one_way_fare" => 180,"return_fare => 380))

如何按 return_fare asc 和 one_way_fare asc 对值进行排序?

我尝试了array_multisort()，但我最终弄错了数据..>

asort 仅适用于一维数组，我需要按两个或更多值排序，我如何才能像在 SQL 中那样实现这一点，按 field1 asc,field2 asc 排序?

解决方案

array_multisort() 是正确的函数，你一定搞砸了:

//获取列的列表foreach ($data as $key => $row) {$return_fare[$key] = $row['return_fare'];$one_way_fare[$key] = $row['one_way_fare'];}//数据量降序，版本升序array_multisort($return_fare, SORT_ASC, $one_way_fare, SORT_ASC, $data);

如果您查看 PHP 手册页中 array_multisort() 的注释，您会发现一个非常有用的 array_orderby() 函数，它允许您缩短以上就是这个:

$sorted = array_orderby($data, 'return_fare', SORT_ASC, 'one_way_fare', SORT_ASC);

为了避免循环使用 array_column()(从 PHP 5.5.0 开始):

array_multisort(array_column($data, 'return_fare'), SORT_ASC,array_column($data, 'one_way_fare'), SORT_ASC,$数据);

I've an array like this

Array (
 [0] => Array( "destination" => "Sydney",
               "airlines" => "airline_1",
               "one_way_fare" => 100,
               "return_fare => 300
       ),
 [2] => Array( "destination" => "Sydney",
               "airlines" => "airline_2",
               "one_way_fare" => 150,
               "return_fare => 350
       ),
 [3] => Array( "destination" => "Sydney",
               "airlines" => "airline_3",
               "one_way_fare" => 180,
               "return_fare => 380
       )
)

How can i sort the value by return_fare asc , one_way_fare asc ?

I tried array_multisort() but i ended up getting mixed up data..

asort only works for one dimensional array, i need to sort by two values or more, how can i achieve this like in SQL, order by field1 asc,field2 asc ?

解决方案

array_multisort() is the correct function, you must have messed up somehow:

// Obtain a list of columns
foreach ($data as $key => $row) {
    $return_fare[$key]  = $row['return_fare'];
    $one_way_fare[$key] = $row['one_way_fare'];
}

// Sort the data with volume descending, edition ascending
array_multisort($return_fare, SORT_ASC, $one_way_fare, SORT_ASC, $data);

If you take a look at the comments at PHP's manual page for array_multisort(), you can find a very helpful array_orderby() function which allows you to shorten the above to just this:

$sorted = array_orderby($data, 'return_fare', SORT_ASC, 'one_way_fare', SORT_ASC);

To avoid the looping use array_column() (as of PHP 5.5.0):

array_multisort(array_column($data, 'return_fare'),  SORT_ASC,
                array_column($data, 'one_way_fare'), SORT_ASC,
                $data);

这篇关于PHP 按两个字段值对数组进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！