How to Sum the same element from different arrays in php?

Question

I have arrays like this: array('id'=>value,'id'=>value)

$arrays=array(
    [0] => Array ( [3] => 1, [102] => -1, [15] => 1,)            
    [1] => Array ( [5] => 1, [80] => -1 )                 
    [2] => Array ( [99] => -1, [3] => -1,[5] => 1 ) 
)

I need to get the total result of a given key. In the above example, if ask for id of 3, the sum is 0, if ask for id of 5, the sum is 2. I can only think of something like this:

  foreach($arrays as $array){
    foreach( $array as $id=>$v){
     if( $id == $asked )
        $total = $total + $v;
    }
  }

Somehow I guess there has to be an efficient way to do the job. I would like to learn. Thanks!

Nope, that's the most efficient method I can think of too. Since you're matching them against nested arrays. — hjpotter92, Sep 22 '12 at 00:28
Check this one out: http://stackoverflow.com/questions/1496682/php-how-to-sum-values-of-the-array-of-the-same-key — mongotop, Sep 22 '12 at 00:30
The only thing I can think of is make sure $asked exists in the array before looping through it. — noel, Sep 22 '12 at 00:39
@Barmar Sorry about that, I'm working my phone and I submit the comment too many times. — mongotop, Sep 22 '12 at 00:42

score 2 · Answer 1 · answered Sep 22 '12 at 00:42

2

Using array_reduce:

$key = 3;

$sum = array_reduce($arrays, function(&$memo, $item) use($key){

    array_key_exists($key, $item) && $memo += $item[$key];

    return $memo;

});

answered Sep 22 '12 at 00:42

moonwave99

21,957
3
43
64

score 0 · Accepted Answer · answered Sep 22 '12 at 00:43

0

foreach($arrays as $array) {
    $total += $array[$id];
}

answered Sep 22 '12 at 00:43

Mr. 14

9,228
6
37
54

score 0 · Answer 3 · answered Sep 22 '12 at 01:05

0

 $prec_array=end($arrays);
 foreach($arrays as $array){
    foreach($array as $id=>$v){
     if(array_key_exists($id, $prec_array) )
            $total[$id] += $v + $prec_array[$id] ;
    $prec_array = $array;
    } 
 }

answered Sep 22 '12 at 01:05

Ouadie

13,005
4
52
62

How to Sum the same element from different arrays in php?

3 Answers3