Removing Duplicates and Merging Multidimensional Array

Question

Need to merge the Multidimensional array into single array, thereby, eleminating the duplicate values taking key as username and values as their user friends details

How should I need to merge the above array as shown below

Expected Result:

[MergedUser] => Array
    (
        [0] => Array
            (
                [ID] => 3
                [username] => IronMan
            )

        [1] => Array
            (
                [ID] => 5
                [username] => SpiderMan
            )

        [2] => Array
            (
                [ID] => 8
                [username] => AntMan
            )

        [3] => Array
            (
                [ID] => 10
                [username] => BatMan
            )

        [4] => Array
            (
                [ID] => 11
                [username] => SuperMan
            )

        [5] => Array
            (
                [ID] => 14
                [username] => Hulk
            )
    )

Making use of array_unique() would print as it is. How should we need to achieve this?

You forgot Array ( [ID] => 1 [username] => Nishanth ) in your output array. Am i right? As well as i am unable to understand the logic of achieving your goal. Can you please explain it a bit more? — Death-is-the-real-truth
– Death-is-the-real-truth, Commented May 21, 2019 at 8:02
That should not be supposed to print I had changed in the SQL query. It doesn't matter whether if its included or not as from the expected result in the array. Since I'm retrieving user's friends list that's why. Only thing is I need is to get rid of duplicate values in an array @AlivetoDie — Nɪsʜᴀɴᴛʜ ॐ
– Nɪsʜᴀɴᴛʜ ॐ, Commented May 21, 2019 at 8:06
After the input array is flattened (array_merge(...$array)), then determine uniqueness by a column value. — mickmackusa
– mickmackusa ♦, Commented May 19, 2022 at 6:46

Progrock · Accepted Answer · 2019-05-21 08:27:22Z

1

<?php
$people =
[
    [
        [
            'id'=>3,
            'name'=>'George'
        ],
        [
            'id'=>5,
            'name'=>'Ringo'
        ]
    ],
    [
        [
            'id'=>3,
            'name'=>'George'
        ],
        [
            'id'=>7,
            'name'=>'Paul'
        ]
    ],
    [
        [
            'id'=> 9,
            'name'=> 'John'
        ]
    ]
];

$peeps = array_merge(...$people);
$peeps = array_column($peeps, null, 'id');
var_export($peeps);

Output:

array (
    3 => 
    array (
      'id' => 3,
      'name' => 'George',
    ),
    5 => 
    array (
      'id' => 5,
      'name' => 'Ringo',
    ),
    7 => 
    array (
      'id' => 7,
      'name' => 'Paul',
    ),
    9 => 
    array (
      'id' => 9,
      'name' => 'John',
    ),
  )

array_column, will filter out duplicates by using the id as the keys for the final array.

Thanks to Alive to Die for noting this will break with your original format. As the array unpacking fails with string keys, this can be fixed by a call of array_values first, so in your case:

$output = array_merge(...array_values($array));
$output = array_column($output, null, 'ID');

edited May 21, 2019 at 8:27

answered May 21, 2019 at 8:11

Progrock

7,4831 gold badge21 silver badges25 bronze badges

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

3 Comments

Death-is-the-real-truth Over a year ago

You have changed OP input array format? Why?Anything wrong there?

Death-is-the-real-truth Over a year ago

With OP given input array your code will throw fatal error:- 3v4l.org/vQp6h

Progrock Over a year ago

Thanks for noticing. Was aiming for brevity here, the OP's input breaks when unpacking as it has string keys (that I omitted), added correction/example to my solution, calling array_values before unpacking fixes this. If sequential keys are really needed for the final array, another call to array_values is required.

Rakesh Jakhar · Accepted Answer · 2019-05-21 08:39:09Z

1

You can use array_map and foreach' to remove duplicated from the existingarray`

$res['MergedUser'] = [];
array_map(function($v) use (&$res){
 foreach($v as $value){
    if(!array_key_exists($value['ID'], $res['MergedUser']))
        $res['MergedUser'][$value['ID']] = $value;
 }
}, $arr);

Live Demo

answered May 21, 2019 at 8:39

Rakesh Jakhar

6,4082 gold badges13 silver badges20 bronze badges

Comments

Rahul · Accepted Answer · 2019-05-21 09:04:21Z

1

You can use function to achieve the same, please see inline doc.

function unique_multidim_array($array, $key)
{
    $temp_array = [];
    $i          = 0;
    $key_array  = [];
    foreach ($array as $val) {
        foreach ($val as $key1 => $value1) {
            if (!in_array($value1[$key], $key_array)) { // will check if already in array
                $key_array[$i]  = $value1[$key]; // once added then wont be added again
                $temp_array[$i] = $value1; // result array
            }
            $i++;
        }
    }
    $ret['MergedUser'] = $temp_array;
    return $ret;
}
$temp = unique_multidim_array($array, "ID"); // unique by which key

Working demo.

answered May 21, 2019 at 9:04

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

Comments

Niket Joshi · Accepted Answer · 2019-05-21 11:57:44Z

0

You can do following to generate unique array.

array_unique($YOUR_ARRAY_VARIABLE, SORT_REGULAR);

this way only unique value is there in your array instead of duplication.

<?php
 // define array 
 $a = array(1, 5, 2, 5, 1, 3, 2, 4, 5); 

 // print original array 
 echo "Original Array : \n"; 
 print_r($a); 

 // remove duplicate values by using  
 // flipping keys and values 
 $a = array_flip($a); 

 // restore the array elements by again  
 // flipping keys and values. 
 $a = array_flip($a); 

 // re-order the array keys 
 $a= array_values($a); 

 // print updated array 
 echo "\nUpdated Array : \n "; 
 print_r($a); 
?>

I hope this link will helps you.

answered May 21, 2019 at 11:57

Niket Joshi

7365 silver badges23 bronze badges

1 Comment

androidXP Over a year ago

OP saying about multidimensional array

Collectives™ on Stack Overflow

Removing Duplicates and Merging Multidimensional Array

4 Answers 4

3 Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related