dongxun1978 2016-11-16 15:25
浏览 37
已采纳

合并数组时计算相同键值对的总和第一对 - php

I have 2 different arrays:

Array 1:

array(5) {
  [0]=>
  array(2) {
    ["all_totals"]=>
    string(1) "3"
    ["month_name"]=>
    string(3) "Jul"
  }
  [1]=>
  array(2) {
    ["all_totals"]=>
    string(2) "20"
    ["month_name"]=>
    string(3) "Aug"
  }
  [2]=>
  array(2) {
    ["all_totals"]=>
    string(2) "10"
    ["month_name"]=>
    string(3) "Sep"
  }
  [3]=>
  array(2) {
    ["all_totals"]=>
    string(2) "14"
    ["month_name"]=>
    string(3) "Oct"
  }
  [4]=>
  array(2) {
    ["all_totals"]=>
    string(3) "102"
    ["month_name"]=>
    string(3) "Nov"
  }
}

Array 2:

array(2) {
  [0]=>
  array(2) {
    ["all_totals"]=>
    string(1) "9"
    ["month_name"]=>
    string(3) "Oct"
  }
  [1]=>
  array(2) {
    ["all_totals"]=>
    string(2) "30"
    ["month_name"]=>
    string(3) "Nov"
  }
}

For joining them and having only one foreach loop, I merged them:

$result = array_merge($array1, $array2);
foreach($result as $item){
   //my actions here
}

But how you notice I have same key=>value pairs in both arrays. The only difference is ["all_totals"] value. For example,

["all_totals"]=>"14", ["month_name"]=> "Oct" and
["all_totals"]=> "9", ["month_name"]=> "Oct"

When merging I want to check whether there are such key-value pairs and join them by having one such element but sum ["all_totals"] values so that I won't lose any data. So in final result I will have one such element:

["all_totals"]=>"23", ["month_name"]=> "Oct"

Any ideas?

  • 写回答

1条回答 默认 最新

  • douping3891 2016-11-16 15:38
    关注

    What about this way to rome:

    $coll=array();
    foreach(array($arr,$arr2) as $array){
     foreach($array as $a){
      if(!isset($coll[$a['month_name']])){
        $coll[$a['month_name']]=$a;
      } else {
        $coll[$a['month_name']]['all_totals'] += $a['all_totals'];
      }
     }
    }
    ksort($coll);
    print_r(array_values($coll));
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题