Add values of only matching array elements PHP

Question

Lets say I've got an array:

Array
(
    [0] => Array
        (
            [filmType] =>  Symphony 15%
            [rollSize] => 36
            [linearFt] => 3
        )

    [1] => Array
        (
            [filmType] =>  Symphony 15%
            [rollSize] => 36
            [linearFt] => 3
        )
    [2] => Array
        (
            [filmType] =>  Symphony 15%
            [rollSize] => 48
            [linearFt] => 5
        )

    [3] => Array
        (
            [filmType] =>  Symphony 25%
            [rollSize] => 36
            [linearFt] => 7
        )
    [4] => Array
        (
            [filmType] =>  Symphony 35%
            [rollSize] => 36
            [linearFt] => 10
        )
    [5] => Array
        (
            [filmType] =>  Symphony 35%
            [rollSize] => 36
            [linearFt] => 10
        )

How is it possible to add up the [linearFt] of ONLY unique array elements. By unique I mean [filmtype] and [rollSize] the same.

I have tried multible ways including searching array, array filter, and usort... I am new to PHP and this is NOT homework. Thanks for any help!

So my output would be:

$totalsArray = Array(

    [0] => Array
        (
            [filmType] =>  Symphony 15%
            [rollSize] => 36
            [linearFt] => 8
        )

    [1] => Array
        (
            [filmType] =>  Symphony 15%
            [rollSize] => 48
            [linearFt] => 3
        )
    [2] => Array
        (
            [filmType] =>  Symphony 25%
            [rollSize] => 48
            [linearFt] => 7
        )
    [3] => Array
        (
            [filmType] =>  Symphony 35%
            [rollSize] => 48
            [linearFt] => 20
        )

Also, make sure when you ask questions to mark correct answers when received. Your other questions need that attention. (Or people may stop helping) — Blake
– Blake, Commented Apr 25, 2012 at 19:38

Malovich · Accepted Answer · 2012-04-25 21:01:51Z

1

Ah. I would attack this with a foreach loop to get each array, then accumulate the different types and sizes and add them as I go. It would look like this:

$filmTotals = array();
$filmTemp   = array();
foreach ($filmInventory as $film){
    $filmTemp[$film['filmType']][$film['rollSize']] = $filmTemp[$film['filmType']][$film['rollSize']] + $film['linearFt'];
}

// A second foreach to resort into the final format, nested to get the keys out to rename them correctly
foreach ($filmTemp as $filmType=>$film){
    foreach ($film as $filmSize=>$filmLength){
        $filmTotals[] = array('filmType'=>$filmType, 'rollSize'=>$filmSize, 'linearFt'=>$filmLength);
    } //END inner foreach
} // END outer foreach

edited Apr 25, 2012 at 21:01

answered Apr 25, 2012 at 19:36

Malovich

9811 gold badge5 silver badges15 bronze badges

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

3 Comments

Blake Over a year ago

Have you tested this? I see some glaring issues.

Malovich Over a year ago

Derp! Yeah, sloppy copypasta, sorry. I've used a similiar structure before...only with everything correctly labeled. Fix'd.

Joe Fisher Over a year ago

Thank you Malovich! Works like a charm. I will study and learn from your code.

Blake · Accepted Answer · 2012-04-25 19:36:35Z

0

Try this:

foreach ($myArray as $value) {
   $sumsArray[$value['filmType']_$value['rollSize']]['length_tally'][] = $value['linearFt'];
}

Will group all similar filmType and rollSize and then you can use array_sum() with the length_tally array to give the total length.

The output won't be exactly what you're looking for, but should put you on the right path.

edited Apr 25, 2012 at 19:36

answered Apr 25, 2012 at 19:31

Blake

2,3241 gold badge16 silver badges24 bronze badges

Collectives™ on Stack Overflow

Add values of only matching array elements PHP

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related