代码之家 › 专栏 › 技术社区 › ForgivenIT

需要通过多个键中的重复值组合php数组

mergesort arrays php

ForgivenIT · 技术社区 · 6 年前

我有一个值超过1000的数组。这个数组在一个PHP文件中,我将把结果返回到另一个数组,以便输出到Excel文件。非常感谢您的帮助

Array
(
[0] => Array
    (
        [isbn] => 97845684684
        [price] => 30.99
        [po] => PXB
        [low] => 24.99
    )
[1] => Array
    (
        [isbn] => 97845684684
        [price] => 30.99
        [po] => PXB
        [low] => 31.99
    )
[2] => Array
    (
        [isbn] => 97845684684
        [price] => 30.99
        [po] => PXB
        [low] => 38.99
    )
[3] => Array
    (
        [isbn] => 97845684684
        [price] => 30.99
        [po] => MXB
        [low] => 24.99
    )
[4] => Array
    (
        [isbn] => 97845684684
        [price] => 30.99
        [po] => MXB
        [low] => 31.99
    )
[5] => Array
    (
        [isbn] => 97845684684
        [price] => 30.99
        [po] => MXB
        [low] => 38.99
    )
[6] => Array
    (
        [isbn] => 97845684978
        [price] => 30.99
        [po] => PXB
        [low] => 18.99
    )
[7] => Array
    (
        [isbn] => 97845684978
        [price] => 30.99
        [po] => PXB
        [low] => 19.99
    )
[8] => Array
    (
        [isbn] => 97845684978
        [price] => 30.99
        [po] => PXB
        [low] => 23.99
    )
)

我需要能够对数组进行排序,并返回每个订单都有ISBN的输出,使该订单的最低值保持在低位。我需要按ISBN、PO和low进行排序。因此,我希望输出如下:

 Array
(
[0] => Array
    (
        [isbn] => 97845684684
        [price] => 30.99
        [po] => PXB
        [low] => 24.99
    )
[1] => Array
    (
        [isbn] => 97845684684
        [price] => 30.99
        [po] => MXB
        [low] => 31.99
    )
[2] => Array
    (
        [isbn] => 97845684978
        [price] => 30.99
        [po] => PXB
        [low] => 18.99
    )
[3] => Array
    (
        [isbn] => 97845684684
        [price] => 30.99
        [po] => MXB
        [low] => 15.99
    )

1 回复 | 直到 6 年前

Mawia HL 6 年前

usort

$array = //your array

function cmp($a, $b) {
    if ($a['po'] == $b['po'] && $a['isbn'] == $b['isbn']) {
       return ($a['low'] < $b['low']) ? -1 : 1;
    }else{
        return 0;
    }

}

usort($array, 'cmp');

$po = null;
$isbn = null;
$result = [];
foreach($array as $key =>$val){    
    if($val['po']==$po && $val['isbn']==$isbn){
    }else{
        $result[] = $val; 
    }
    $isbn = $val['isbn'];
    $po = $val['po'];
}
echo '<pre>';
print_r($result);
echo '</pre>';

推荐文章

Toniq · javascript为php保存多维数组

1 年前

Jannis · Java中数组的怪异行为

1 年前

callum · 如何识别数组中与给定序列不匹配的元素?

1 年前

Gamerboi677 _YT · 如果玩家触摸了某个部分,如何将玩家名称添加到数组中。-Roblox-Lua编码

1 年前

at. · 在一行中创建任意大小的JavaScript/TypeScript 2d数组

1 年前

Rakis Friski · Javascript Spread运算符混淆行为

1 年前

tenfour · 如何使用数组元素的索引初始化数组元素

2 年前

Guillaume · 使用操作从Python列表创建numpy数组

2 年前

maxMas · Swift 5:为什么会出现索引超出范围错误?

2 年前

Sarah Workman · 尝试比较用javascript编程添加的字符串的值

2 年前