Undefined index when Grouping and sum values in multidimensional array

Question

I am using the below code to group the array $summary by currency and get the sum of grouped duration and cost. So far I am able to group and sum the array but since the array cells $result[$split['currency']]['duration'] and $result[$split['currency']]['cost'] are undefined I am getting notice when I run the code. How can I remove the notice without using error_reporting(0)?

Code

foreach ($summary as $split) {

            if (isset($split['currency'])) {
                $result[$split['currency']]['duration'] += $split['duration'];
                $result[$split['currency']]['cost'] += $split['cost'];
            } else {
                $result[0]['duration'] += $split['duration'];
                $result[0]['cost'] += $split['cost'];
            }
        }

EDIT

$summary = Array
(
[0] => Array
    (
        [currency] => SGD
        [duration] => 8.00
        [cost] => 228.57
    )

[1] => Array
    (
        [currency] => SGD
        [duration] => 8.00
        [cost] => 228.57
    )

[2] => Array
    (
        [currency] => 
        [duration] => 8.00
        [cost] => 
    )

[3] => Array
    (
        [currency] => MYR
        [duration] => 12.00
        [cost] => 342.86
    )

[4] => Array
    (
        [currency] => SGD
        [duration] => 8.00
        [cost] => 228.57
    )

[5] => Array
    (
        [currency] => MYR
        [duration] => 12.00
        [cost] => 342.86
    )

$result will be as show below

 Array
(
[0] => Array
    (
        [currency] => SGD
        [duration] => 24
        [cost] => 685.71
    )

[1] => Array
    (
        [currency] => MYR
        [duration] => 24
        [cost] => 685.72
    )

[2] => Array
    (
        [currency] => 
        [duration] => 8
        [cost] => 0
    )

)

show us your array values so that it will be easy for us to give you a solution. — Syed mohamed aladeen
– Syed mohamed aladeen, Commented Jul 27, 2016 at 8:25

Ondřej Hlaváček · Accepted Answer · 2016-07-27 08:34:52Z

1

You need to define the array first:

foreach ($summary as $split) {
        if (isset($split['currency'])) {
            if (!isset($result[$split['currency']]) {
                $result[$split['currency']] = [
                    'duration' => 0,
                    'cost' => 0
                ];
            }
            $result[$split['currency']]['duration'] += $split['duration'];
            $result[$split['currency']]['cost'] += $split['cost'];
        } else {
            $result[0]['duration'] += $split['duration'];
            $result[0]['cost'] += $split['cost'];
        }
    }

answered Jul 27, 2016 at 8:34

Ondřej Hlaváček

5061 gold badge4 silver badges12 bronze badges

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

Comments

MadMarc · Accepted Answer · 2016-07-27 08:35:34Z

1

Test existence of $result array indexes too.

foreach ($summary as $split) {
    if (isset($split['currency'])) {
        if(!isset($result[$split['currency']])) {
        $result[$split['currency']]['duration'] = $split['duration'];
        $result[$split['currency']]['cost'] = $split['cost'];  
        } else {
        $result[$split['currency']]['duration'] += $split['duration'];
        $result[$split['currency']]['cost'] += $split['cost'];
        }
    } else {
        $result[0]['duration'] += $split['duration'];
        $result[0]['cost'] += $split['cost'];
    }
}

answered Jul 27, 2016 at 8:35

MadMarc

1282 silver badges12 bronze badges

Comments

mickmackusa · Accepted Answer · 2021-08-05 13:01:04Z

I don't understand the need for the extra condition block.

Use currency as temporary keys. On the first encounter of a currency, store the whole row. Otherwise, add the current iteration's duration and cost to the stored group. When finished looping, re-index the array with array_values().

Code: (Demo)

$result = [];
foreach ($array as $row) {
    if (!isset($result[$row['currency']])) {
        $result[$row['currency']] = $row;
    } else {
        $result[$row['currency']]['duration'] += $row['duration'];
        $result[$row['currency']]['cost'] += $row['cost'];
    }
}
var_export(array_values($result));

Output:

array (
  0 => 
  array (
    'currency' => 'SGD',
    'duration' => 16.0,
    'cost' => 457.14,
  ),
  1 => 
  array (
    'currency' => NULL,
    'duration' => 8.0,
    'cost' => NULL,
  ),
  2 => 
  array (
    'currency' => 'MYR',
    'duration' => 24.0,
    'cost' => 685.72,
  ),
)

Collectives™ on Stack Overflow

Undefined index when Grouping and sum values in multidimensional array

Code

EDIT

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Code

EDIT

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related