Making a Sum of a nested array in PHP

Question

I have 3 level nested array and I would like some help to make the generate the sum of its values. The array goes like

                                    SUM
                                 /       \
                               A          B
                              / \         /\
                        Billed  Route Billed Route
                         /        \      /      \
                       Value     Value  Value    Value

How can i make a sum of the Billed and Route fields?

So far I have this code

foreach($sum as $client)
            {

                $s = 0;
                foreach($client as $stat_name=>$stat_value)
                {
                    $val = 0;
                    // echo "<br><u><i>";
                    // echo $stat_name;
                    // echo "</u></i><br>";
                    foreach($stat_value as $value)
                    {
                        $val += intval($value);
                    }
                    $sum2[$stat_name] += $val;
                }

            }

I receive an undefine index error on the first loop for each new key.

if (isset($sum2[$stat_name])) { /* do += */ } else { /* do = */ } — bwoebi
– bwoebi, Commented May 15, 2014 at 15:54
You want to sum all billed and route fields or sum the billed fields and then sum the routes fields or what? — AbraCadaver
– AbraCadaver, Commented May 15, 2014 at 15:55
Also, a print_r of array would help, as there is a much easier way. — AbraCadaver
– AbraCadaver, Commented May 15, 2014 at 16:01
@bwoebi that was EXACTLY what the problem was. Thank you very much — Harris Geo
– Harris Geo, Commented May 20, 2014 at 8:10

Alex W · Accepted Answer · 2014-05-15 15:59:11Z

1

Have you defined $sum2[$stat_name] as 0 ? If not, you'll get an undefined index error on each iteration of the second foreach loop because you're trying to do += on a value that isn't defined.

Also, if you're trying add the values of Billed and Route then storing them in different parts of an associative array ($sum2[$stat_name]) is an extra step. Just add them together in the same key of the array.

answered May 15, 2014 at 15:59

Alex W

38.5k13 gold badges114 silver badges115 bronze badges

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

Comments

Marc B · Accepted Answer · 2014-05-15 15:55:24Z

0

If those are the actual keys in your array, then:

$route = 0;
$billed = 0;
foreach($yourarray['SUM'] AS $ab => $subarray) {
   $billed += $subarray['Billed']['Value'];
   $route  += $subarray['Routed']['Value'];
}

answered May 15, 2014 at 15:55

Marc B

362k44 gold badges433 silver badges508 bronze badges

Comments

jeroen · Accepted Answer · 2014-05-15 15:58:40Z

0

$sum2[$stat_name] += $val;

is the same as:

$sum2[$stat_name] = $sum2[$stat_name] + $val;
                    ^^^^^^^^^^^^^^^^^ undefined the first time you loop

To solve that, you should initialize it:

$sum2[$stat_name] = isset($sum2[$stat_name]) ? $sum2[$stat_name] : 0;
$sum2[$stat_name] += $val;

answered May 15, 2014 at 15:58

jeroen

91.8k22 gold badges117 silver badges132 bronze badges

Collectives™ on Stack Overflow

Making a Sum of a nested array in PHP

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related