php merge arrays of the same array

Question

I have this array in php :

array:5 [
  0 => array:3 [
    "tab" => "9"
    "layout_id" => "11"
    "banners_ids" => "7"
  ]
  1 => array:3 [
    "tab" => "9"
    "layout_id" => "11"
    "banners_ids" => "8"
  ]
  2 => array:3 [
    "tab" => "10"
    "layout_id" => null
    "banners_ids" => null
  ]
  3 => array:3 [
    "tab" => "11"
    "layout_id" => null
    "banners_ids" => null
  ]
  4 => array:3 [
    "tab" => "12"
    "layout_id" => null
    "banners_ids" => null
  ]
]

And i need to merge in the same array those that have the same "tab" key to have something like this:

array:5 [
  0 => array:3 [
    "tab" => "9"
    "layout_id" => "11"
    "banners_ids" => "8,7"
  ]
  1 => array:3 [
    "tab" => "10"
    "layout_id" => null
    "banners_ids" => null
  ]
  2 => array:3 [
    "tab" => "11"
    "layout_id" => null
    "banners_ids" => null
  ]
  3 => array:3 [
    "tab" => "12"
    "layout_id" => null
    "banners_ids" => null
  ]
]

How can I reach this? I trie with a foreach and positions like current() or prev() but with no result.

Possible duplicate of [PHP: Merge 2 Multidimensional Arrays](http://stackoverflow.com/questions/1558291/php-merge-2-multidimensional-arrays) — Fabian Horlacher, Mar 15 '17 at 14:15
can you post json_encode($array) so I can write up some code really quick? — Dimi, Mar 15 '17 at 14:17
@Dimi This is the json_encode: `[{"tab":"9","layout_id":"11","banners_ids":"7"},{"tab":"9","layout_id":"11","banners_ids":"8"},{"tab":"10","layout_id":null,"banners_ids":null},{"tab":"11","layout_id":null,"banners_ids":null},{"tab":"12","layout_id":null,"banners_ids":null}]` — Gerard Luque, Mar 15 '17 at 14:19
@Ahmad I don't see how array_column can help me in this case — Gerard Luque, Mar 15 '17 at 14:34

score 1 · Answer 1 · answered Mar 15 '17 at 14:46

$finala = $c = $arr;
echo "<pre>"; print_r($finala);echo "</pre>";
foreach($arr as $ke=>$ss){
foreach($c as $k => $cc){
    if($ke == $k) continue;
    if($ss['tab'] == $cc['tab']){            
        $finala[$ke]['tab'] = $ss['tab'];
        $finala[$ke]['layout_id'] = $ss['layout_id'];
        $finala[$ke]['banners_ids'] = implode(',', array( $cc['banners_ids'],$ss['banners_ids']));
        unset($finala[$k]);
    }
}
}
ksort($finala);
echo "<pre>"; print_r($finala);echo "</pre>";

score 1 · Accepted Answer · answered Mar 15 '17 at 14:57

Got distracted with things. Either use Bhaskar's answer or mine... Or combine them.

<?php

$array=json_decode('[{"tab":"9","layout_id":"11","banners_ids":"7"},{"tab":"9","layout_id":"11","banners_ids":"8"},{"tab":"10","layout_id":null,"banners_ids":null},{"tab":"11","layout_id":null,"banners_ids":null},{"tab":"12","layout_id":null,"banners_ids":null}]',true);


//var_dump($array);
$new_array=array();
foreach($array as $entry)
{
$new_array[$entry['tab']]['tab']=$entry['tab'];
$new_array[$entry['tab']]['layout_id']=$entry['layout_id'];
$new_array[$entry['tab']]['banners_ids'][]=$entry['banners_ids'];
}

foreach($new_array as $key=>$val)
{
$new_array[$key]['banners_ids']=implode(',',$new_array[$key]['banners_ids']);
}

var_dump($new_array);

score 0 · Answer 3 · answered Mar 15 '17 at 15:52

// Manual sort by tab value
usort($array, function($a, $b){
    return $a['tab'] - $b['tab'];
});

$serve = -1;
$merge = array();
foreach ($array as $value) {
    $tab_position = array_search($value['tab'], array_column($array,'tab')); // find same tab value position

    if($tab_position > $serve) $serve = $tab_position;

    if($tab_position == $serve){
        $merge[$tab_position]['tab'] = $value['tab'];
        $merge[$tab_position]['layout_id'] = $value['layout_id']; // if you want to merge layout_id as well, do as below
        $merge[$tab_position]['banners_ids'] = !isset($merge[$tab_position]['banners_ids']) ? 
                                                $value['banners_ids'] : 
                                                $merge[$tab_position]['banners_ids'].','.$value['banners_ids'];

        $merge[$tab_position]['banners_ids'] = rtrim($merge[$tab_position]['banners_ids'], ','); // remove extre comma (.)

    }
}

print_r($merge); // output

php merge arrays of the same array

3 Answers3