PHP Compare 2 multidimensional arrays and remove duplicate based on key value

Question

I have 2 arrays e.g.

OldMembers:

Array (
  [0] => Array
    (
        [time] => 1361612421
        [memberid] => 90
    )

  [1] => Array
    (
        [time] => 1361614422
        [memberid] => 96
    )

  [2] => Array
    (
        [time] => 1361617423
        [memberid] => 108
    )
)

and NewMembers

Array (
  [0] => Array
    (
        [time] => 1361618411
        [memberid] => 103
    )

  [1] => Array
    (
        [time] => 1361618443
        [memberid] => 129
    )
  [2] => Array
    (
        [time] => 1361618463
        [memberid] => 96
    )
)

What is the best way to remove duplicates from NewMembers based on key memberid ? E.g. in this case I need removed second array from NewMembers because memberid 96 already exist in OldMembers on position 1... and I just need that instance removed from NewMembers array ?

try the in_arrayfunction and post your code then

michi
– michi

2013-02-23 11:50:50 +00:00
Commented Feb 23, 2013 at 11:50 — michi
– michi, Commented Feb 23, 2013 at 11:50

lauriys · Accepted Answer · 2013-02-23 12:10:43Z

4

Not the best answer for sure, but if nobody else will propose anything, at least you will have that.

foreach($newmembers as $newmemberId => $newmember) {
    foreach($oldmembers as $oldmember) {
        if($oldmember['memberid'] == $newmember['memberid']) {
            unset($newmembers[$newmemberId]);
            break;
        }
    }
}

$newmembers and $oldmembers are your arrays of course.

edited Feb 23, 2013 at 12:10

answered Feb 23, 2013 at 11:49

lauriys

4,8318 gold badges34 silver badges40 bronze badges

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

1 Comment

Barmar Over a year ago

You should break out of the inner loop when it finds a match. Otherwise it looks like a fine solution.

Dipesh Parmar · Accepted Answer · 2013-02-23 11:58:07Z

2

Try

array_unique( array_merge($oldMember, $newMember) );

Did not tested but hope it will work.

Tested Code.

<?php
$oldMember = array
(
    '0' => array
    (
        'time' => 1361612421,
        'memberid' => 90
    ),
    '1' => array
    (
        'time' => 1361614422,
        'memberid' => 96
    ),
    '2' => array
    (
        'time' => 1361617423,
        'memberid' => 108
    )
);

$newMember = array
(
    '0' => array
    (
        'time' => 1361618411,
        'memberid' => 103
    ),
    '1' => array
    (
        'time' => 1361618443,
        'memberid' => 129
    ),
    '2' => array
    (
        'time' => 1361618463,
        'memberid' => 96
    )
);


$id_arr = array();
$final_arr = array();

checkmemberidArray($oldMember, $id_arr, $final_arr);
checkmemberidArray($newMember, $id_arr, $final_arr);

function checkmemberidArray($arr, &$id_arr, &$final_arr)
{
    foreach ($arr as $key => $value)
    {
        if (!in_array($value['memberid'], $id_arr))
        {
            $id_arr[] = $value['memberid'];
            $final_arr[] = $value;
        }
    }
}

echo "<pre>";
print_r($final_arr);
echo "</pre>";
?>

edited Feb 23, 2013 at 11:58

answered Feb 23, 2013 at 11:49

Dipesh Parmar

27.3k8 gold badges65 silver badges92 bronze badges

2 Comments

Barmar Over a year ago

That won't work because the times don't match between the two arrays. He only wants to compare memberids.

michi Over a year ago

not working on multi-dimensional arrays, unfortunately... see: (php.net/manual/en/function.array-unique.php)

Collectives™ on Stack Overflow

PHP Compare 2 multidimensional arrays and remove duplicate based on key value

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related