PHP 按两个字段值对数组进行排序

PHP sort array by two field values

提问by flyclassic

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 ?

如何按 return_fare asc 、 one_way_fare asc 对值进行排序？

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

我试过array_multisort()但我最终弄混了数据..

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 ?

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

回答by Tatu Ulmanen

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

array_multisort()是正确的功能，你一定搞砸了：

// 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:

如果您查看 PHP 手册页上的注释array_multisort()，您会发现一个非常有用的array_orderby()函数，它允许您将上述内容缩短为：

$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_column()（从 PHP 5.5.0 开始）：

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

回答by etarion

In addition to array_multisort(), which requires you to build column-arrays first, there is also usort()which doesn't require such a thing.

除了array_multisort()需要您首先构建列数组的 ，还有usort()不需要这样的东西。

usort($data, function($a, $b) { 
    $rdiff = $a['return_fare'] - $b['return_fare'];
    if ($rdiff) return $rdiff; 
    return $a['one_way_fare'] - $b['one_way_fare']; 
}); // anonymous function requires PHP 5.3 - use "normal" function earlier

回答by Narendrasingh Sisodia

Or you can use uasortas follows

或者你可以使用uasort如下

uasort($arr, function($a,$b){
    $c = $a['return_fare'] - $b['return_fare'];
    $c .= $a['one_way_fare'] - $b['one_way_fare'];
    return $c;
});

Fiddle

Fiddle

回答by user634545

Another example using the spaceship operator.

另一个使用飞船操作员的例子。

usort($data, function($a, $b) { 
    return $a['return_fare'] <=> $b['return_fare'] ?: $a['one_way_fare'] <=> $b['one_way_fare'];
});

回答by Westy92

I'll answer this in a way that can be generalized, no matter how many items you wish to sort on!

无论您希望对多少项目进行排序，我都会以一种可以概括的方式来回答这个问题！

Sorting on return_farethen one_way_fare:

return_fare然后排序one_way_fare：

usort($data, function($a, $b) {
   if ($a['return_fare'] != $b['return_fare']) {
      return $a['return_fare'] <=> $b['return_fare'];
   }

   return $a['one_way_fare'] <=> $b['one_way_fare'];
});

Sorting on return_fare, then one_way_fare, then destination:

对return_fare, then one_way_fare, then 进行排序destination：

usort($data, function($a, $b) {
   if ($a['return_fare'] != $b['return_fare']) {
      return $a['return_fare'] <=> $b['return_fare'];
   }

   if ($a['one_way_fare'] != $b['one_way_fare']) {
      return $a['one_way_fare'] <=> $b['one_way_fare'];
   }

   return strnatcasecmp($a['destination'], $b['destination']);
});

Sorting on just return_fare:

仅排序return_fare：

usort($data, function($a, $b) {
   return $a['return_fare'] <=> $b['return_fare'];
});

Note:you don't have to use an anonymous function with usort!

注意：您不必使用匿名函数usort！

function cmp($a, $b) {
   return $a['return_fare'] <=> $b['return_fare'];
}

usort($data, 'cmp');


// Use a function inside a class:
class MyClass {
   public static function compare($a, $b) {
      return $a['return_fare'] <=> $b['return_fare'];
   }
}

usort($data, ['MyClass', 'compare']);

You can also chain these using the Elvis Operator (?:):

您还可以使用 Elvis 运算符 ( ?:) 将这些链接起来：

usort($data, function($a, $b) {
      return $a['return_fare'] <=> $b['return_fare'] ?:
             $a['one_way_fare'] <=> $b['one_way_fare'] ?:
             strnatcasecmp($a['destination'], $b['destination']);
});

This last example used the Spaceship Operator (<=>) and the Elvis Operator (?:). Isn't programming great?

最后一个示例使用了 Spaceship Operator ( <=>) 和 Elvis Operator ( ?:)。编程不是很好吗？

回答by Amaynut

The shortest version for me is (works with PHP 7+ only)

对我来说最短的版本是（仅适用于 PHP 7+）

usort($data, function ($a, $b) {
        return $a['return_fares'] <=> $b['return_fares'] ?: $a['one_way_fares'] <=> $b['one_way_fares'];
    });

回答by flyclassic

Ohh, i managed to solve my own question again....

哦，我设法再次解决了我自己的问题......

function array_multi_sort($array, $on1,$on2, $order=SORT_ASC) 
{

    foreach($array as $key=>$value){
        $one_way_fares[$key] = $value[$on2];
        $return_fares[$key] = $value[$on1];
    }

    array_multisort($return_fares,$order,$one_way_fares,$order,$array);
}

The thing is i missed out the last parameter $array on array_multisort($return_fares,$order,$one_way_fares,$order,$array);

问题是我错过了最后一个参数 $array array_multisort($return_fares,$order,$one_way_fares,$order,$array);

earlier!

早点！