php数组重复求和,php-如何求和重复数据的数组值

我有一些具有相同ID值的数组,如下所示.

[

{"ID":"126871","total":"200.00","currency":"USD","name":"John"},

{"ID":"126872","total":"2000.00","currency":"Euro","name":"John"},

{"ID":"126872","total":"1000.00","currency":"Euro","name":"John"},

{"ID":"126872","total":"500.00","currency":"USD","name":"John"},

{"ID":"126872","total":"1000.00","currency":"Euro","name":"John"},

]

如果ID值重复,则将同一货币的总值相加.对于具有相同ID的不同货币,无需总计.

这就是我想要的.

[

{"ID":"126871","total":"200.00","currency":"USD","name":"John"},

{"ID":"126872","total":"4000.00","currency":"Euro","name":"John"},

{"ID":"126872","total":"500.00","currency":"USD","name":"John"}

]

我陷入上述问题.我已经尽力了.但是我得到了错误的结果.我非常感谢任何建议.

解决方法:

@Cloud我已根据您的要求提供了功能,感谢@M.我来看看这个总和部分.

$array = array(

array("ID" => "126871","total"=>"200.00","currency"=>"USD","name"=>"John"),

array("ID" => "126872","total"=>"2000.00","currency"=>"Euro","name"=>"John"),

array("ID" => "126872","total"=>"1000.00","currency"=>"Euro","name"=>"John"),

array("ID" => "126872","total"=>"500.00","currency"=>"USD","name"=>"John"),

array("ID" => "126872","total"=>"1000.00","currency"=>"Euro","name"=>"John"),

);

echo "

";

print_r($array);

function unique_multidim_array($array, $key,$key1,$addedKey) {

$temp_array = array();

$i = 0;

$key_array = array();

$key1_array = array();

foreach($array as $val) {

if (!in_array($val[$key], $key_array) && !in_array($val[$key1], $key1_array)) {

$key_array[$i] = $val[$key];

$key1_array[$i] = $val[$key1];

$temp_array[$i] = $val;

}else{

$pkey = array_search($val[$key],$key_array);

$pkey1 = array_search($val[$key1],$key1_array);

if($pkey==$pkey1){

$temp_array[$pkey][$addedKey] += $val[$addedKey];

}else{

$key_array[$i] = $val[$key];

$key1_array[$i] = $val[$key1];

$temp_array[$i] = $val;

}

// die;

}

$i++;

}

return $temp_array;

}

$nArray = unique_multidim_array($array,"ID","currency","total");

// die;

print_r($nArray);

die;

标签：php,arrays,json,sum,grouping

来源： https://codeday.me/bug/20191012/1896723.html