PHP Merge 2 arrays of multi-dimension arrays and sum value

Question

I would like to merge those two arrays and make the sum of the value movements while keeping day.

first array:

array (30)
0 => array (2)
    day => "01" (2)
    movements => 49
1 => array (2)
    day => "02" (2)
    movements => 50
2 => array (2)
    day => "03" (2)
    movements => 54
...

second array :

array (30)
0 => array (2)
    day => "01" (2)
    movements => 50
1 => array (2)
    day => "02" (2)
    movements => 51
2 => array (2)
    day => "03" (2)
    movements => 41
...

As a result I am expecting, an array of arrays with the same day index and the sum of movements:

array (30)
0 => array (2)
    day => "01" (2)
    movements => 99
1 => array (2)
    day => "02" (2)
    movements => 101
2 => array (2)
    day => "03" (2)
    movements => 95
...

Any help would be greatly appreciated.

$arr1 = array_column($arr1, null, 'day'); and the 2nd array. Then combine the same indexes — splash58
– splash58, Commented Dec 28, 2017 at 16:56

Ravi Roshan · Accepted Answer · 2017-12-28 17:28:13Z

1

$arr1 = [ ['day' => '01', 'movement' => 50], ['day' => '02', 'movement' => 10] ];
$arr2 = [ ['day' => '01', 'movement' => 20], ['day' => '02', 'movement' => 10] ];

$sum = [];

echo '<pre>';
print_r($arr1);
print_r($arr2);


if(!empty($arr1)){
    $result = [];
    foreach ($arr1 as $key => $value) {
        if(isset($arr2[$key]['day']) && $arr2[$key]['day'] == $value['day']){
            $result['day'] = $value['day'];
            $result['movement'] = $value['movement']+$arr2[$key]['movement'];
        }
        array_push($sum, $result);
    }
}

print_r($sum);

answered Dec 28, 2017 at 17:28

Ravi Roshan

5703 silver badges15 bronze badges

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

Comments

Evaldas · Accepted Answer · 2017-12-28 17:21:02Z

It is even calculate movments if any array miss any day.

<?php
$arrayFirst = [
    ['day' => '01', 'movements' => 10],
    ['day' => '02', 'movements' => 20],
    ['day' => '04', 'movements' => 40],
];

$arraySecond = [
    ['day' => '01', 'movements' => 15],
    ['day' => '03', 'movements' => 30],
    ['day' => '04', 'movements' => 45],
];

$arrColFirst = array_column($arrayFirst, 'movements', 'day');
$arrColSecond = array_column($arraySecond, 'movements', 'day');
$merrgedArray = array_merge($arrColFirst, $arrColSecond);

$result = [];
foreach ($merrgedArray as $day=> $movments) {
    $result[$day] =  [
        'day' => $day,
        'movements' => isset($arrColFirst[$day]) ? $arrColFirst[$day] + $movments : $movments,
    ];
}

sort($result);

Collectives™ on Stack Overflow

PHP Merge 2 arrays of multi-dimension arrays and sum value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related