从多维数组中删除重复值并对它们进行求和。

Question

假设我有这样一个数组：

   Array
    (
        [0] => Array
        (
            [0] => A
            [1] => 20
        )

        [1] => Array
        (
            [0] => B
            [1] => 10
        )

        [2] => Array
        (
            [0] => G
            [1] => 5
        )

        [3] => Array
        (
            [0] => A
            [1] => 15
        )


    )

我想移除重复的值，只和一行数组:我想要的是：

   Array
    (
        [0] => Array
        (
            [0] => A
            [1] => 35 // <= sum : 20 + 15
        )

        [1] => Array
        (
            [0] => B
            [1] => 10
        )

        [2] => Array
        (
            [0] => G
            [1] => 5
        )



    )

我以前读过this的问题。

更新

while($row = $stmt->fetch()){

    $arr = array(
        'GoodMainCode'=>persian_sql_to_php($row['GoodMainCode']), // <= like A in the example
        'title'=> persian_sql_to_php($row['GoodName']),
        'author'=>persian_sql_to_php($row['moalef']),
        'publisher'=>persian_sql_to_php($row['Nasher']),
        'translator'=>persian_sql_to_php($row['Motarjem']),
        'price'=>persian_sql_to_php($row['SellPrice1']),
        'isbn'=>persian_sql_to_php($row['ISBN']),
        'amount'=>persian_sql_to_php($row['Amount']), // <= if GoodMainCode is same key, I must sum it.
        'year_of_publish'=>persian_sql_to_php($row['SaleChap']),
        'period_print'=>persian_sql_to_php($row['NobateChap'])
    );


    array_push($mjson,$arr);

}



//added

foreach($mjson as $v){

    if(!isset($result[$v['GoodMainCode']]))
        $result[$v['GoodMainCode']] = $v;
    else
        $result[$v['GoodMainCode']]['amount'] += $v['amount'];
}

Answer 1

这应该适用于你：

只需循环遍历数组，并检查$result数组中是否有来自$arr的当前内部数组的字母键。如果没有，则将其添加到$result数组中，并使用数字初始化第二个键。

如果这个字母已经有一个键，您可以简单地将这些数字相加在这个数组中。最后，我只需使用array_values()重新索引整个数组。

<?php

    foreach($arr as $v) {
        if(!isset($result[$v[0]]))
            $result[$v[0]] = $v;
        else
            $result[$v[0]][1] += $v[1];
    }

    $result = array_values($result);
    print_r($result);

?>

产出：

Array
(
    [0] => Array
        (
            [0] => A
            [1] => 35
        )
    //...
    [2] => Array
        (
            [0] => G
            [1] => 5
        )

)