PHP 数组对多列数据进行排序 - PHP Array Sort With Multiple Columns of Data

PHP Array Sort With Multiple Columns of Data

本文关键字：排序数据数组 PHP | 更新日期: 2023-09-27

我想制作一个数组排序方法，以便您可以通过价格/ID号等对一些信息进行排序。

我的数组是这样的：

[1] 1002234985, $123.00, ITEM DESCRIPTION #1
[2] 1034234985, $143.70, ITEM DESCRIPTION #2
[3] 1002467455, $133.06, ITEM DESCRIPTION #3
[4] 1564334985, $883.11, ITEM DESCRIPTION #4

我想按价格对数组进行排序，但描述和 ID 号匹配。我该怎么做？

谢谢！

编写compare函数（接收两个元素并返回哪个更大）并使用 usort 使用它

举个例子：

$arr = array(
              array(1002234985, '125.00', 'ITEM DESCRIPTION'), 
              array(1002234986, '124.00', 'ITEM DESCRIPTION'), 
              array(1002234987, '123.00', 'ITEM DESCRIPTION')
);
function mycomp($itm1, $itm2){
    if($itm1[1] > $itm2[1]){
        return 1;
    }
    else if($itm1[1] < $itm2[1]){
        return -1;
    }
    else{
        return 0;
    }
}
usort($arr, 'mycomp');
print_r($arr);

下面是一个使用 PHP 的 usort 对多维数组进行排序的示例。

// Change this to the index of the key you wish to sort by
$sortBy = 0;
$myArray = array(
  array(1002234985, '$123.00', 'ITEM DESCRIPTION #1'),
  array(1034234985, '$143.70', 'ITEM DESCRIPTION #2'),
  array(1002467455, '$133.06', 'ITEM DESCRIPTION #3'),
  array(1564334985, '$883.11', 'ITEM DESCRIPTION #4')
];
usort($myArray, 'cmp');
function cmp($a, $b){
  if ($a[$sortBy] == $b[$sortBy]) {
    return 0;
  }
  return ($a[$sortBy] < $b[$sortBy]) ? -1 : 1;
}

请使用以下函数：

function sortArrayByTwoKeys($data, $k1, $k2, $order='ASC'){
    if($order == 'DESC'){
        usort($data, function (array $a, array $b) {
            return [$b['score'], $b['name']] <=> [$a['score'], $a['name']];
        });
    } elseif($order == 'ASC_K2_DESC_K1'){
        usort($data, function (array $a, array $b) {
            return [$b['score'], $a['name']] <=> [$a['score'], $b['name']];
        });
    } elseif($order == 'ASC_K1_DESC_K2'){
        usort($data, function (array $a, array $b) {
            return [$a['score'], $b['name']] <=> [$b['score'], $a['name']];
        });
    } else {//ASC
        usort($data, function (array $a, array $b) {
            return [$a['score'], $a['name']] <=> [$b['score'], $b['name']];
        });
    }
    return $data;
}
//Example 1
$data = [
['id' => 111, 'score' => 5, 'name' => 'xyz'],
['id' => 222, 'score' => 3, 'name' => 'ddd'],
['id' => 333, 'score' => 2, 'name' => 'xyz'],
['id' => 444, 'score' => 3, 'name' => 'fff'],
['id' => 555, 'score' => 5, 'name' => 'acb'],
['id' => 666, 'score' => 6, 'name' => 'ttt'],
['id' => 777, 'score' => 6, 'name' => 'sss'],
['id' => 888, 'score' => 6, 'name' => 'aaa']
];
$data = sortArrayByTwoKeys($data, 'score', 'name', 'ASC_K2_DESC_K1');
echo '<pre>';print_r($data);echo '</pre>';

输出将是：数组([0] => 数组([id] => 888[得分] => 6[名称] => aaa)

[1] => Array
    (
        [id] => 777
        [score] => 6
        [name] => sss
    )
[2] => Array
    (
        [id] => 666
        [score] => 6
        [name] => ttt
    )
[3] => Array
    (
        [id] => 555
        [score] => 5
        [name] => acb
    )
[4] => Array
    (
        [id] => 111
        [score] => 5
        [name] => xyz
    )
[5] => Array
    (
        [id] => 222
        [score] => 3
        [name] => ddd
    )
[6] => Array
    (
        [id] => 444
        [score] => 3
        [name] => fff
    )
[7] => Array
    (
        [id] => 333
        [score] => 2
        [name] => xyz
    )

）