PHP : Grouping array in for-each loop

Question

I have an array like this :

array(2) {
  ["currency"]=>
    string(7) "bitcoin"
  ["Totalcs"]=>
   string(1) "1"
}
array(2) {
  ["currency"]=>
    string(8) "ethereum"
  ["Totalcs"]=>
   string(1) "1"
}
array(2) {
  ["currency"]=>
    string(8) "ethereum"
  ["Totalcs"]=>
   string(1) "1"
}

I want to group this array like this :

array(2) {
 ["currency"]=>
   string(7) "bitcoin"
 ["Totalcs"]=>
   string(1) "1"
}
array(2) {
 ["currency"]=>
   string(8) "ethereum"
 ["Totalcs"]=>
   string(1) "2"
 }

I tried many ways, but didn't work anyone ....please help me

try array_unique($array, SORT_REGULAR); for more visit http://php.net/language.operators.array — Sanjit Bhardwaj, Feb 16 '18 at 07:08
Was really unclear until I have noticed u are increasing count...... as sanjit specified try array unique. — Alice, Feb 16 '18 at 07:10
@Irfan that is an unsuitable dupe link. There is no summing going on there. Probably 100 other/better links to find. — mickmackusa, Feb 16 '18 at 07:42
@mickmackusa, I am assuming group by functionality on array, therefore I was marked, may be It is wrong.. — er.irfankhan11, Feb 16 '18 at 08:50
@VishnuGopinath i have changed my solution so please have a look to the current edited solution (`I HAVE USED isset() INSIDE foreach()`) — Alive to die - Anant, Feb 16 '18 at 10:46

Alive to die - Anant · Accepted Answer · 2018-02-16T07:48:15.877

Simple foreach() with new array creation will do the job:-

$final_array = [];

foreach($array as $arr){

  $final_array[$arr['currency']]['currency'] = $arr['currency'];
  $final_array[$arr['currency']]['Totalcs'] = (isset($final_array[$arr['currency']]['Totalcs']))? $final_array[$arr['currency']]['Totalcs']+$arr['Totalcs'] : $arr['Totalcs'];

}

$final_array = array_values($final_array);

print_r($final_array);

Output:- https://eval.in/957322

score 0 · Answer 2 · answered Feb 16 '18 at 17:36

You will need to assign temporary keys as you iterate your input array. This method will not perform any unnecessary value overwrites.

Code: (Demo)

$array=[
    ['currency'=>'bitcoin','Totalcs'=>'1'],
    ['currency'=>'ethereum','Totalcs'=>'1'],
    ['currency'=>'ethereum','Totalcs'=>'1']
];
foreach($array as $row){  // iterate all rows
    if(!isset($result[$row['currency']])){  // if first occurrence of currency...
        $result[$row['currency']]=$row;     // save the full row with currency as the temporary key
    }else{                                    // if not the first occurrence of currency...
        $result[$row['currency']]['Totalcs']+=$row['Totalcs'];  // add Totalcs value
    }
}
var_export(array_values($result));

Output:

array (
  0 => 
  array (
    'currency' => 'bitcoin',
    'Totalcs' => '1',
  ),
  1 => 
  array (
    'currency' => 'ethereum',
    'Totalcs' => 2,
  ),
)

PHP : Grouping array in for-each loop

2 Answers2