How to group multidimension array values and get the sum of each group? [duplicate]

Question

How can I dynamically group the array values and count the sum of each group? This is my current array:

Array ( [0] => Array ( [source] => web [count] => 1 ) 
        [1] => Array ( [source] => web [count] => 1 ) 
        [2] => Array ( [source] => catalog [count] => 1 ) 
        [3] => Array ( [source] => magazine [count] => 1 ) 
        [4] => Array ( [source] => newspaper [count] => 1 ) 
        [5] => Array ( [source] => web [count] => 1 ) 
        [6] => Array ( [source] => newspaper [count] => 1 ) 
        [7] => Array ( [source] => web [count] => 1
)

This is what I'd like to acheive:

Array ( [0] => Array ( [source] => web [count] => 4 ) 
        [1] => Array ( [source] => catalog [count] => 1 ) 
        [2] => Array ( [source] => magazine [count] => 1 ) 
        [3] => Array ( [source] => newspaper [count] => 2 ) 
)

stackoverflow.com/questions/13284036/…

Avinash Babu
– Avinash Babu

2014-07-30 03:47:18 +00:00
Commented Jul 30, 2014 at 3:47 — Avinash Babu
– Avinash Babu, Commented Jul 30, 2014 at 3:47

Casimir et Hippolyte · Accepted Answer · 2014-07-30 04:17:30Z

1

I will proceed like that:

<pre><?php

$arr = array ( array ( 'source' => 'web', 'count' => 1 ), 
               array ( 'source' => 'web', 'count' => 1 ), 
               array ( 'source' => 'catalog', 'count' => 1 ), 
               array ( 'source' => 'magazine', 'count' => 1 ), 
               array ( 'source' => 'newspaper', 'count' => 1 ), 
               array ( 'source' => 'web', 'count' => 1 ), 
               array ( 'source' => 'newspaper', 'count' => 1 ), 
               array ( 'source' => 'web', 'count' => 1)
      );

$temp = array();
foreach ($arr as $v) {
    $temp[$v['source']] += $v['count'];
}

$result = array();
foreach ($temp as $k => $v) {
    $result[] = array( 'source' => $k, 'count' => $v );
}
unset($temp);

print_r($result);

answered Jul 30, 2014 at 4:17

Casimir et Hippolyte

90k5 gold badges102 silver badges131 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to group multidimension array values and get the sum of each group? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related