Total up array element using its value and nested array elements value

Question

I cant get my head around how to do this.

Consider I have the following php array

I want to somehow iterate over each array element and total up the Product Count element based on its on value and all child values (which could be n levels deep)

The end result I am looking for is

can anyone help please? Speed or efficiency is not really a major issue as this will be run once a day at 3 in the morning so no-one will be waiting for it to finish its work!!

you can write a recursive code which checks if child array exists and if it does then get the product count, add the product count and again check if child array exists. — Robin
– Robin, Commented Jun 24, 2015 at 15:34

l0ckm4 · Accepted Answer · 2015-06-25 11:05:21Z

1

The only reasonable way to tally up values in an array with unknown depth is by using recursive methods.

function sumItems(&$branch,$sum){

    $sum = $branch['Product Count'];
    foreach($branch['children'] as &$item){
          $sum += sumItems($item,$sum); // Each sub array runs this function
                                        // And adds thier count to the parent branch
    }

    $branch['Product Count'] = $sum; // Since branch is passed to function as
                                    // Reference, this line overrides the original value

    return $sum; // Each recursion of this function returns its own value + the sum of all sub arrays to the parent
}
sum_items($array,0); // Will return the sum of all branches and sub branches

edited Jun 25, 2015 at 11:05

l0ckm4

7475 silver badges17 bronze badges

answered Jun 24, 2015 at 15:36

Skarlinski

2,48715 silver badges29 bronze badges

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

4 Comments

Skarlinski Over a year ago

Made some changes, should work or require fine tuning. Let me know if you need clarification on any of parts of the example

l0ckm4 Over a year ago

Thanks for the reply. I cant get my head around how to use this though - must be Wednesday afternoon thing! Say my array is in the variable $tree. How would I call this function to total up all of the elements and the sub arrays etc in $tree.

Skarlinski Over a year ago

Fixed a bug and added comments. Hope you can make it worl

l0ckm4 Over a year ago

Thank you Skarlinksi :-) I had to call it using sum_items($array[0],0); There was also an errant } which was just above return $sum; which I have edited out - just waiting on peer review. Many thanks for your help

Collectives™ on Stack Overflow

Total up array element using its value and nested array elements value

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related