How to sum value of array if some values are same?

Question

I have following array

Array (
    [0] => 1995,17500
    [1] => 2052,17500
    [2] => 2052,17500
    [3] => 2236,30000
    [4] => 2235,15000
    [5] => 2235,40000
);

I have exploded the value with comma ,.

foreach($array as $key=>$value) {

      $newar = explode(',', $value);
}

So I have similar first value i.e $newar["0"]. For example 2235 and 2052. And I would like to have sum of second value i.e $newar["1"].

How can I achieve following result with PHP.

Array (
   [0] => 1995, 17500
   [1] => 2052, 35000
   [2] => 2036, 30000
   [3] => 2235, 55000
)

Daan · Accepted Answer · 2016-01-21 08:48:09Z

1

You can create a new array key/index based and use array_key_exists to check if the key already exists. If so sum the value, if not create the key. This is not the exact result you want, but it's neater.

$newar = []; //New Array

foreach($array as $value) {
     $explArr = explode(',', $value);

     if(array_key_exists($explArr[0], $newar)){ //Check if the key already exists
        $newar[$explArr[0]] += $explArr[1]; //Sum value to existing key
     } else {
        $newar[$explArr[0]] = $explArr[1]; //Create key
     }
}

Your result array will look like this:

Array (
   [1995] => 17500
   [2052] => 35000
   [2036] => 30000
   [2235] => 55000
)

answered Jan 21, 2016 at 8:48

Daan

12.3k6 gold badges36 silver badges51 bronze badges

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

2 Comments

Narendrasingh Sisodia Over a year ago

You can better use isset($newar[$explArr[0]]) instead of using another php function array_key_exists($explArr[0], $newar)

Daan Over a year ago

@Uchiha Because? Micro-optimizing?

Collectives™ on Stack Overflow

How to sum value of array if some values are same?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related