php two Multidimensional Array difference

Question

I am working with two multidimensional array difference bellow are my array:

Array1:

Array
(
    [0] => Array
        (
            [F_CONTACT_ID] => 2
            [F_CONTACT_FNAME] => name2
            [F_CONTACT_NAME] => name22
        )

    [1] => Array
        (
            [F_CONTACT_ID] => 3
            [F_CONTACT_FNAME] => name3
            [F_CONTACT_NAME] => name33
        )

)

Array2:

Array
(
    [0] => Array
        (
            [F_CONTACT_ID] => 2
            [F_CONTACT_FNAME] => name2
            [F_CONTACT_NAME] => name22
        )

    [1] => Array
        (
            [F_CONTACT_ID] => 3
            [F_CONTACT_FNAME] => name3
            [F_CONTACT_NAME] => name33
        )

    [2] => Array
        (
            [F_CONTACT_ID] => 5
            [F_CONTACT_FNAME] => name5
            [F_CONTACT_NAME] => name55
        )

)

I just want o compare the difference with 'F_CONTACT_ID' in the array.

My Resulting Array Should be:

Result:

Array
(
    [2] => Array
        (
            [F_CONTACT_ID] => 5
            [F_CONTACT_FNAME] => name5
            [F_CONTACT_NAME] => name55
        )
)

Also If one array is empty: suppose Array2 is empty. My result Array should be:

Array
(
    [0] => Array
        (
            [F_CONTACT_ID] => 2
            [F_CONTACT_FNAME] => name2
            [F_CONTACT_NAME] => name22
        )

    [1] => Array
        (
            [F_CONTACT_ID] => 3
            [F_CONTACT_FNAME] => name3
            [F_CONTACT_NAME] => name33
        )

)

I tried with different solutions but nothing worked for me. I tried to retrieve the F_CONTACT_ID and stored in single-dimensional array and compare but It took lot of time. Kindly help me in better and fast solution.

This link may help you.. stackoverflow.com/questions/12246039/… — Deepu Sasidharan
– Deepu Sasidharan, Commented Jan 9, 2015 at 8:55

Dung Tran · Accepted Answer · 2015-01-09 09:30:51Z

1

Have you tried this?

for($i=0;$i<count($array1);$i++) {
    $temp[$array1[$i]['F_CONTACT_ID']] = $array1[$i];
};

for($i=0;$i<count($array2);$i++) {
    if($temp[$array2[$i]['F_CONTACT_ID']]) {
        unset($temp[$array2[$i]['F_CONTACT_ID']]);
    } else {
        $temp[$array2[$i]['F_CONTACT_ID']] = $array2[$i];
    }
}

echo "<pre>";
print_r($temp);
echo "</pre>";

The result will be some thing like this:

Array
(
    [5] => Array
        (
            [F_CONTACT_ID] => 5
            [F_CONTACT_FNAME] => name5
            [F_CONTACT_NAME] => name55
        )

)

edited Jan 9, 2015 at 9:30

answered Jan 9, 2015 at 9:23

Dung Tran

1187 bronze badges

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

Comments

O.S.Kaya · Accepted Answer · 2015-01-09 08:59:30Z

0

You could try the function array-diff-key() function, which helps you to compare two multidimensional arrays using keys.

You could visit this page for more information: http://php.net/manual/en/function.array-diff-key.php

answered Jan 9, 2015 at 8:59

O.S.Kaya

1282 silver badges9 bronze badges

Comments

Nemesis · Accepted Answer · 2015-01-09 09:10:26Z

0

what about something like this?

$array1;
$array2;

$array3;
foreach ($array1 as $ar1) {
    foreach ($array2 as $ar2) {
        if ($ar1['F_CONTACT_ID']==$ar2['F_CONTACT_ID']) {
            array_push($array3, $ar1);
        }
    }
}

it's not very optimize, to maximize performance change the second foreach checking if array_push is already append (using a bool condition)

answered Jan 9, 2015 at 9:10

Nemesis

221 silver badge4 bronze badges

2 Comments

DonOfDen Over a year ago

Nope! I have gone through this long back.!

DonOfDen Over a year ago

if u read the question again and check with ur solution u will know that.. if u explain me what will be the output of $array3 u will know it.

Collectives™ on Stack Overflow

php two Multidimensional Array difference

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related