PHP- Sum of value with the same key in arrays

Question

I have those arrays, which contains totals for a monthly report:

Array (
 [name] => Creativo
 [Total] => 98910.44
 [Pedidos] => 89
 [Descuento] => 448.54
 [Clientes] => 11
 [Pliegos] => 1504.100 
)

Array (
 [name] => Emprendedor
 [Total] => 48561.47
 [Pedidos] => 38
 [Descuento] => 0.00
 [Clientes] => 9
 [Pliegos] => 842.400 
) 

Array (
 [name] => Detallista
 [Total] => 30428.87
 [Pedidos] => 163
 [Descuento] => 0.00
 [Clientes] => 22
 [Pliegos] => 107.940 )

Array (
 [name] =>
 [Total] => 1089.98
 [Pedidos] => 3
 [Descuento] => 0.00
 [Clientes] => 2
 [Pliegos] => 10.600 
)

I need a totalized array like this:

Array (
 [Total] => 178990.79
 [Pedidos] => 293
 [Descuento] => 448.54
 [Clientes] => 44
 [Pliegos] => 2465.34
)

I dont know how sum the same keys because the values are in differents arrays. how can I do?

Regards.

i think his question is bit different, he has 4 different arrays — sumit, Jan 06 '14 at 17:03

score 1 · Answer 1 · answered Jan 06 '14 at 17:02

I think you have 4 different arrays like below

 <?php
    $arr1=array (
     'name' => 'Creativo',
     'Total' => 98910.44,
     'Pedidos' => 89,
     'Descuento' => 448.54,
     'Clientes' => 11,
     'Pliegos' => 1504.100 
    );

    $arr2=array (
     'name' => 'Emprendedor',
     'Total' => 48561.47,
     'Pedidos' => 38,
     'Descuento' => 0.00,
     'Clientes' => 9,
     'Pliegos' => 842.400 
    );

    $arr3=array (
     'name' => 'Detallista',
     'Total' => 30428.87,
     'Pedidos' => 163,
     'Descuento' => 0.00,
     'Clientes' => 22,
     'Pliegos' => 107.940 );

    $arr4=array (
     'name' =>'yyy',
     'Total' => 1089.98,
     'Pedidos' => 3,
     'Descuento' => 0.00,
     'Clientes' => 2,
     'Pliegos' => 10.600, 
    );

    echo "<pre>";
    foreach ($arr1 as $k=>$v) {
        if($k!='name')
            $arr[$k]=$v+$arr2[$k]+$arr3[$k]+$arr4[$k];
        else
            $arr[$k]=$v;    
    }

    print_r($arr);
    ?>

score 0 · Answer 2 · answered Jan 06 '14 at 16:32

0

Something like this could work (this is untested)

$total = 0;
$pedidos = 0;
$descuento = 0;
$clientes = 0;
$pliegos = 0;

foreach($array as $arr) {
    $total = $total + $arr['Total'];
    $pedidos = $pedidos + $arr['Pedidos'];
    $descuento = $descuento + $arr['Descuento'];
    $clientes = $clientes + $arr['Clientes'];
    $pliegos = $pliegos + $arr['Pliegos'];
}

echo $total;

This will iterate through each array and add on to it each time.

answered Jan 06 '14 at 16:32

Karl

5,435
11
44
70

It is adding the same value 6 times. – araujophillips Jan 06 '14 at 16:46
Not sure why, I just used `$array = array(array('Total' => 2), array('Total' => 4));` and ran it, $total gave me `6` which is the correct answer. – Karl Jan 06 '14 at 17:11

score 0 · Answer 3 · answered Jan 06 '14 at 16:33

0

you should use *array_merge* to merge all the arrays that you need into one, then do a foreach loop and sum all the desired elements

answered Jan 06 '14 at 16:33

gh0st

214
3
15

Sam · Answer 4 · 2014-01-06T16:45:35.410

0

Something like this work for you?

 $totals = array();
 foreach($Report as $item) {
   if(!array_key_exists($item['name'], $totals)) {
     // We haven't come across this name yet, so make a placeholder with 0's
     $totals[$item['name']] = array(
       'name' => $item['name'],
       'Total' => 0,
       'Pedidos' => 0,
       'Descuento' => 0,
       'Clientes' => 0,
       'Pliegos' => 0,
     );
   }

   // Increment the amounts for the specific name
   $totals[$item['name']]['Total'] += $item['Total'];
   $totals[$item['name']]['Pedidos'] += $item['Pedidos'];
   $totals[$item['name']]['Descuento'] += $item['Descuento'];
   $totals[$item['name']]['Clientes'] += $item['Clientes'];
   $totals[$item['name']]['Pliegos'] += $item['Pliegos'];
 }
 print_r($totals);

edited Jan 06 '14 at 16:45

answered Jan 06 '14 at 16:33

Sam

20,096
2
45
71

The array name is $Report – araujophillips Jan 06 '14 at 16:40
['Name'] is a key, equal that Total, Pedidos, Descuento, Clientes and Pliegos. – araujophillips Jan 06 '14 at 16:50
Oh updated the question ['Name'] is not a total, is a "label". It is not important for the total report. – araujophillips Jan 06 '14 at 16:52

PHP- Sum of value with the same key in arrays

4 Answers4