how to find the sum of array values in a multi dimensional array in php

Question

My input array

$consumption = [
    'MONDAY'    => [
        'REFRIGERATOR'   => [
            3,
            9,
            7,
        ],
        'WASHINGMACHINE' => [
            2,
            4,
            2,
            8,
        ],
    ],
    'TUESDAY'   => [
        'REFRIGERATOR' => [
            5,
            3,
            8,
        ],
        'OVEN'         => [
            4,
            1,
            4,
        ],
    ],
    'WEDNESDAY' => [
        'TV'           => [
            6,
            9,
        ],
        'REFRIGERATOR' => [
            2,
            3,
            5,
            2,
        ],
    ],
    'THURSDAY'  => [
        'TV'  => [
            5,
            3,
            3,
            2,
        ],
        'FAN' => [
            4,
            9,
            8,
            5,
        ],
    ],
    'FRIDAY'    => [
        'WASHINGMACHINE' => [
            8,
            5,
        ],
        'OVEN'           => [
            3,
            9,
            7,
        ],
    ],
];

I need output as

Output:

Array ( [REFRIGERATOR] => 47 [WASHINGMACHINE] => 29 [OVEN] => 28 [TV] => 28 [FAN] => 26 )

Code attempt (pasted in from comments) [here is some pointless text so that Stack Overflow allows me to add in the code xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx]

  if(!empty($consumption))
   { 
      foreach($consumption as $key=>$val)
        { 
           foreach($val as $skey=>$sval)
           { 
              $outPutArray[$skey][] = array_sum($sval); 
           } 
       } 
    } 

   foreach($consumption as $k => $val)
   { 
     $result[$k] = array_sum(array_column($val, $k)); 
     foreach($val as $skey=>$sval)
     { 
       $result[$skey] = array_sum(array_column($val, $k)); 
     } 
   }

if(!empty($consumption)){ foreach($consumption as $key=>$val){ foreach($val as $skey=>$sval){ $outPutArray[$skey][] = array_sum($sval); } } } foreach($consumption as $k => $val){ $result[$k] = array_sum(array_column($val, $k)); foreach($val as $skey=>$sval){ $result[$skey] = array_sum(array_column($val, $k)); } } — Praseetha Vasappan
– Praseetha Vasappan, Commented Nov 24, 2016 at 10:24

Antony Thompson · Accepted Answer · 2016-11-24 10:33:16Z

1

Use a foreach loop.

$totals = [];
foreach($consumption as $day){
    foreach($day as $machine => $number){
        if(!isset($totals[$machine]){
            $totals[$machine] = array_sum($number);
        }else{
            $totals[$machine] = $totals[$machine] + array_sum($number);
        }
    }
}
echo '<pre>';
print_r($totals);
echo '</pre>';

Live demo: http://sandbox.onlinephpfunctions.com/code/ad1f529f5b5428c4ea0b9dda2ed20a8baa657d5b

edited Nov 24, 2016 at 10:33

answered Nov 24, 2016 at 10:23

Antony Thompson

1,6381 gold badge13 silver badges22 bronze badges

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

2 Comments

Praseetha Vasappan Over a year ago

i need the output as Array ( [REFRIGERATOR] => 47 [WASHINGMACHINE] => 29 [OVEN] => 28 [TV] => 28 [FAN] => 26 )

Antony Thompson Over a year ago

I added array_sum, sorry I got confused with your arrays being in one like :P

Paul Roefs · Accepted Answer · 2016-11-24 10:29:44Z

0

I know its probably not the best way but you can use a multi dimensional foreach and put it in an array like this:

foreach($consumption as $consumption_value) {
    foreach($consumption_value as $key -> $value) {
        if(isset($consumptions[$key])) {
            $consumptions[$key] += $value;
        }
        else {
            $consumptions[$key] = $value;
        }
    }
}

answered Nov 24, 2016 at 10:29

Paul Roefs

4782 gold badges5 silver badges13 bronze badges

Comments

RJParikh · Accepted Answer · 2016-11-24 10:43:06Z

0

Use below code:

$consumption = array( 'MONDAY' => array('REFRIGERATOR' => array(3, 9, 7), 'WASHINGMACHINE' => array(2, 4, 2, 8)), 'TUESDAY' => array('REFRIGERATOR' => array(5, 3, 8), 'OVEN' => array(4, 1, 4)), 'WEDNESDAY' => array('TV' => array(6, 9), 'REFRIGERATOR' => array(2, 3, 5, 2)), 'THURSDAY' => array('TV' => array(5, 3, 3, 2), 'FAN' => array(4, 9, 8, 5)), 'FRIDAY' => array('WASHINGMACHINE' => array(8, 5), 'OVEN' => array(3, 9, 7)) );

$total_ref = $total_was = $total_oven = $total_tv = $total_fan = 0;
foreach($consumption as $key=>$products)
{
    foreach($products as $productName => $data)
    {
        if(isset($newarr[$productName]))
        {
            $newarr[$productName] = $newarr[$productName] + array_sum($data);
        }
        else
        {
            $newarr[$productName] = array_sum($data);
        }
    }
}

echo "<pre>";
print_r($newarr);

Output

Array
(
    [REFRIGERATOR] => 47
    [WASHINGMACHINE] => 29
    [OVEN] => 28
    [TV] => 28
    [FAN] => 26
)

Live Demo: Click Here

edited Nov 24, 2016 at 10:43

answered Nov 24, 2016 at 10:32

RJParikh

4,1661 gold badge24 silver badges38 bronze badges

1 Comment

RJParikh Over a year ago

edited with dynamic code. please check it. @PraseethaVasappan

devmyb · Accepted Answer · 2016-11-24 11:32:08Z

0

You can simply use foreach like as

$result = [];
foreach($consumption as $v)
{
    foreach($v as $v_k => $v_v)
    {
        if(isset($result[$v_k]))
            $result[$v_k] += array_sum($v_v);
        else
            $result[$v_k] = array_sum($v_v);
    }
}

print_r($result);

Working Demo

answered Nov 24, 2016 at 11:32

devmyb

3752 silver badges14 bronze badges

Comments

LF-DevJourney · Accepted Answer · 2016-12-01 10:37:48Z

check the demo. result is,{"REFRIGERATOR":47,"WASHINGMACHINE":29,"OVEN":28,"TV":28,"FAN":26}

Hope it helps.

 <?php
    $consumption = array( 'MONDAY' => array('REFRIGERATOR' => array(3, 9, 7), 'WASHINGMACHINE' => array(2, 4, 2, 8)), 'TUESDAY' => array('REFRIGERATOR' => array(5, 3, 8), 'OVEN' => array(4, 1, 4)), 'WEDNESDAY' => array('TV' => array(6, 9), 'REFRIGERATOR' => array(2, 3, 5, 2)), 'THURSDAY' => array('TV' => array(5, 3, 3, 2), 'FAN' => array(4, 9, 8, 5)), 'FRIDAY' => array('WASHINGMACHINE' => array(8, 5), 'OVEN' => array(3, 9, 7)) );

    $result = [];
    foreach($consumption as $dayCon)
    {
      array_walk($dayCon, function($value, $key) use(&$result)
      {
         if(!isset($result[$key])) $result[$key] = 0;
         $result[$key] += array_sum($value);
      });
    }
    echo json_encode($result);

Collectives™ on Stack Overflow

how to find the sum of array values in a multi dimensional array in php

5 Answers 5

2 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related