在php中删除数组中的重复项

2cmtqfgy 于 2021-07-24 发布在 Java

关注(0)|答案(2)|浏览(408)

我的阵列：

Array ( 
[0] => Array ( [month] => November [Average Purchase Price] => 2.52 [Total Purchase Gallons] => 84000 ) 
[1] => Array ( [month] => October [Average Purchase Price] => 2.615 [Total Purchase Gallons] => 63000 ) 
[2] => Array ( [month] => November [Average Customer Price] => 2.79 [Total Customer Gallons] => 25000 ) 
[3] => Array ( [month] => October [Average Customer Price] => 2.9050000000000002 [Total Customer Gallons] => 5500 ) )

我希望能够回显[month]并且不复制它，但是仍然将其他值与正确的月份相关联。为了达到这一点，我做了一个数组合并，把它们像你看到的那样放在一起。
它们分别如下所示：

1

Array ( 
[0] => Array ( [month] => November [Average Purchase Price] => 2.52 [Total Purchase Gallons] => 84000 ) 
[1] => Array ( [month] => October [Average Purchase Price] => 2.615 [Total Purchase Gallons] => 63000 ) )

2

Array ( 
[0] => Array ( [month] => November [Average Customer Price] => 2.79 [Total Customer Gallons] => 25000 ) 
[1] => Array ( [month] => October [Average Customer Price] => 2.9050000000000002 [Total Customer Gallons] => 5500 ) )

我试过你的独特，这是行不通的。我使用foreach语句来呼应这些值。
谢谢您！
sql查询：

$sql = "SELECT month, AVG(price) AS 'Average Purchase Price', SUM(gallons) as 'Total Purchase Gallons' from purchase_contracts
group BY month";
$purch = mysqli_query($con, $sql) or die(mysqli_error($con));
while ($rows = mysqli_fetch_assoc($purch))
{ 
    $purch_items[] = $rows;
}

$sql1 = "SELECT month, AVG(price) AS 'Average Customer Price', SUM(gallons) as 'Total Customer Gallons' from customer_contracts
 group BY month";
 $cust = mysqli_query($con, $sql1) or die(mysqli_error($con));
 while ($rows1 = mysqli_fetch_assoc($cust))
 { 
   $cust_items[] = $rows1;
 }

sql Arrays php

来源：https://stackoverflow.com/questions/63236090/remove-duplicates-in-an-array-in-php

2条答案

按热度按时间

yc0p9oo01#

这很简单：

<?php

$oldArr = [
    ['month' => 'November', 'Average Purchase Price' => 2.52, 'Total Purchase Gallons' => 84000],
    ['month' => 'October', 'Average Purchase Price' => 2.615, 'Total Purchase Gallons' => 63000],
    ['month' => 'November', 'Average Customer Price' => 2.79, 'Total Customer Gallons' => 25000],
    ['month' => 'October', 'Average Customer Price' => 2.9050000000000002, 'Total Customer Gallons' => 5500]
];

$newArr = [];
foreach ($oldArr as $item) {
    $month = $item['month'];
    if (!array_key_exists($month, $newArr)) {
        $newArr[$month] = $item;
    }
}

echo '<pre>';
print_r($newArr);

赞(0）回复(0）举报 2021-07-24

izj3ouym2#

从原来的两个数组中，只需重新索引 month 并递归合并它们：

$result = array_merge_recursive(array_column($array1, null, 'month'),
                                array_column($array2, null, 'month'));

由此产生：

Array
(
    [November] => Array
        (
            [month] => Array
                (
                    [0] => November
                    [1] => November
                )
            [Average Purchase Price] => 2.52
            [Total Purchase Gallons] => 84000
            [Average Customer Price] => 2.79
            [Total Customer Gallons] => 25000
        )
    [October] => Array
        (
            [month] => Array
                (
                    [0] => October
                    [1] => October
                )
            [Average Purchase Price] => 2.615
            [Total Purchase Gallons] => 63000
            [Average Customer Price] => 2.905
            [Total Customer Gallons] => 5500
        )
)

使您可以轻松地访问一个月内的任何密钥：

echo $result['October']['Average Purchase Price'];
echo $result['October']['Average Customer Price'];
// etc...

或循环：

foreach($result as $month => $values) {
    echo $month;
    echo $values['Average Purchase Price'];
    echo $values['Average Customer Price'];
    // etc...
}

但是，您在两个可以组合的查询中进行了编辑。这可能有用，也可能会问另一个问题，毫无疑问，有人会问你一个问题：

SELECT month, AVG(price) AS 'Average Purchase Price', SUM(gallons) AS 'Total Purchase Gallons'
    FROM purchase_contracts GROUP BY month

UNION ALL

SELECT month, AVG(price) AS 'Average Customer Price', SUM(gallons) AS 'Total Customer Gallons'
    FROM customer_contracts GROUP BY month

赞(0）回复(0）举报 2021-07-24

我来回答

在php中删除数组中的重复项

1

2

2条答案

相关问题

热门标签

最新问答