How to add the particular key values after matching?

Question

i have a array:

  Array
(
    [0] => Array
        (
            [cam_id] => 136
            [partner_id] => 350
            [marketing] => [{"quartername":"q1","tactic":"Linkedin(Connections & Pages)","1":"9000","2":"4000","3":"3000","4":"2000","5":"1400","6":"1000","7":"700","8":"600","9":"500","10":"65"},{"quartername":"q1","tactic":"Single Email Campaign","1":"350","2":"200","3":"156","4":"142","5":"122","6":"112","7":"80","8":"65","9":"35","10":"15"},{"quartername":"q4","tactic":"Single Email Campaign","1":"350","2":"200","3":"156","4":"142","5":"122","6":"112","7":"80","8":"65","9":"35","10":"15"}]
        )

)

after decode the jason of "marketing" key value i got this array.

Array
(
    [0] => Array
        (
            [quartername] => q1
            [tactic] => Linkedin(Connections & Pages)
            [1] => 9000
            [2] => 4000
            [3] => 3000
            [4] => 2000
            [5] => 1400
            [6] => 1000
            [7] => 700
            [8] => 600
            [9] => 500
            [10] => 65
        )

    [1] => Array
        (
            [quartername] => q1
            [tactic] => Single Email Campaign
            [1] => 350
            [2] => 200
            [3] => 156
            [4] => 142
            [5] => 122
            [6] => 112
            [7] => 80
            [8] => 65
            [9] => 35
            [10] => 15
        )

    [2] => Array
        (
            [quartername] => q4
            [tactic] => Single Email Campaign
            [1] => 350
            [2] => 200
            [3] => 156
            [4] => 142
            [5] => 122
            [6] => 112
            [7] => 80
            [8] => 65
            [9] => 35
            [10] => 15
        )

)

i want to check the "quartername" key if the key match in the array then there respective added.

i want the result array just like after adding the same "quartername" key:

    Array
(
    [0] => Array
        (
            [quartername] => q1
            [tactic] => 
            [1] => 9350
            [2] => 4200
            [3] => 3156
            [4] => 2142
            [5] => 1522
            [6] => 1112
            [7] => 780
            [8] => 665
            [9] => 535
            [10] => 80
        )


    [1] => Array
        (
            [quartername] => q4
            [tactic] => Single Email Campaign
            [1] => 350
            [2] => 200
            [3] => 156
            [4] => 142
            [5] => 122
            [6] => 112
            [7] => 80
            [8] => 65
            [9] => 35
            [10] => 15
        )

)

here is the code which i tried .it will add all the values of "quartername" key.

foreach($actual_leads as $key => $val){
                $actual_leads[$key]['marketing'] = json_decode($actual_leads[$key]['marketing'],true);
                echo "<pre>"; print_r($actual_leads[$key]['marketing']);echo "</pre>";
            } 

            $actual_leads_tot = array();
            foreach($actual_leads as $key => $val){

                foreach($val as $key2 => $val2){

                    foreach($val2 as $key3=> $val3){

                        foreach($val3 as $key4=>$val4){

                            if($key4 != 'quartername' && $key4 != 'tactic'){
                                $actual_leads_tot[$key][$key4] += $val4;
                                $actual_leads[$key]['marketing'] = $actual_leads_tot;
                            }
                        }
                    }
                }
            }

[This question](http://stackoverflow.com/questions/14195916/associative-array-sum-values-of-the-same-key) might help too. — Jurik, Jun 10 '16 at 07:45

score 1 · Answer 1 · answered Jun 10 '16 at 07:37

1

Just use the quatername as key:

<?php
  $actual_leads_tot = array();

  foreach($actual_leads as $lead) {
    foreach($lead as $key => $item) {
      if(isset($actual_leads_tot[$lead['quatername']][$key] && $key != 'quatername' && $key != 'tactic') {
        $item = $item + $actual_leads_tot[$lead['quatername']][$key];
      }

      $actual_leads_tot[$lead['quatername']][$key] = $item;
    }
  }
?>

Now you have an array full of your combined leads.

answered Jun 10 '16 at 07:37

Jurik

3,244
1
31
52

Actually this should give you an idea what to do. What happens if you take my lines of code? – Jurik Jun 10 '16 at 07:52

score 1 · Accepted Answer · answered Jun 13 '16 at 06:15

$actual_leads3 =  array();
        foreach($actual_leads2 as $key=> $val ){
            foreach($val as $key1 => $val1){
                if(in_array($key1,$_POST['sel_qtrs'])){
                    $actual_leads3[$key][$key1] = $actual_leads2[$key][$key1]; // Filtered array
                }
            }
        }

        $actual_total3 =  array();
        foreach($actual_leads3 as $key=>$val){
            foreach($val as $key1=>$val1){
                foreach($val1 as $key2=>$val2){
                    foreach($val2 as $key3=>$val3){
                        //$actual_leads3[$key][$key1]['total'][$key3] += $val3;
                        $actual_total3[$key][$key1][$key3] += $val3;
                        //echo "<pre>"; print_r($key3); echo "</pre>";

                    }
                }
            }
        }

How to add the particular key values after matching?

2 Answers2