Comparing multidimensional arrays using specific key in php

Question

I have two multidimensional arrays. the first one is:

Array
(
     [0] => Array
          (
              [username] => J1
              [fullname] => John1
          )
     [1] => Array  
          (
              [username] => K1
              [fullname] => Kate
          )
     [2] => Array  
          (
              [username] => P1
              [fullname] => Peter
          ) 
     [3] => Array  
          (
              [username] => M1
              [fullname] => Mary
          ) 
) 

and the second one is:

Array
(
     [0] => Array
          (
              [username] => J1
              [fullname] => John33
          )
     [1] => Array  
          (
              [username] => L1
              [fullname] => Lucas
          )
     [2] => Array  
          (
              [username] => P1
              [fullname] => Paul
          ) 
)

I want to compare the two arrays using only their username option in order to get the elements of first array which are not included in second array (comparing only the usernames).

so i want a new array like the following:

Array
    (
         [0] => Array  
              (
                  [username] => K1
                  [fullname] => Kate
              )
         [1] => Array  
              (
                  [username] => M1
                  [fullname] => Mary
              ) 
    )

Any help?? thanks a lot!!!

What did you attempt yet?

briosheje
– briosheje

2015-05-05 13:03:41 +00:00
Commented May 5, 2015 at 13:03 — briosheje
– briosheje, Commented May 5, 2015 at 13:03

AbraCadaver · Accepted Answer · 2015-05-05 13:11:15Z

1

You could do something like this in PHP >= 5.5.0:

$result = array_diff_key(array_column($array1, null, 'username'),
                         array_column($array2, null, 'username')
);

answered May 5, 2015 at 13:11

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

Comments

MatejG · Accepted Answer · 2015-05-05 13:02:44Z

Try to loop through one array and compare like this:

   $array_one = Array
(
     [0] => Array
          (
              [username] => J1
              [fullname] => John1
          )
     [1] => Array  
          (
              [username] => K1
              [fullname] => Kate
          )
     [2] => Array  
          (
              [username] => P1
              [fullname] => Peter
          ) 
     [3] => Array  
          (
              [username] => M1
              [fullname] => Mary
          ) 
);
   $array_two = Array
(
     [0] => Array
          (
              [username] => J1
              [fullname] => John33
          )
     [1] => Array  
          (
              [username] => L1
              [fullname] => Lucas
          )
     [2] => Array  
          (
              [username] => P1
              [fullname] => Paul
          ) 
); 
   foreach($array_one as $key => $value) {
       if($value['username'] == $array_two[$key]['username'])
          // do something
       else
          // do something
    }

Noman · Accepted Answer · 2015-05-05 13:15:59Z

$array1 = array(
    "0" => Array(
        "username" => "J1",
        "fullname" => "John1"
    ),
    "1" => Array(
        "username" => "K1",
        "fullname" => "Kate"
    ),
    "2" => Array(
        "username" => "P1",
        "fullname" => "Peter"
    ),
    "3" => Array(
        "username" => "M1",
        "fullname" => "Mary"
    )
);

$array2 = array(
    "0" => Array(
        "username" => "J1",
        "fullname" => "John33"
    ),
    "1" => Array(
        "username" => "L1",
        "fullname" => "Lucas"
    ),
    "2" => Array(
        "username" => "P1",
        "fullname" => "Paul"
    )
);

$newarr = array();
foreach( $array1 as $key => $val ) {
    if($val['username'] != $array2[$key]['username']){
        $newarr[] = $val;
    }
}

echo '<pre>';print_r($newarr);echo '</pre>';

Output :

Array
(
    [0] => Array
        (
            [username] => K1
            [fullname] => Kate
        )

    [1] => Array
        (
            [username] => M1
            [fullname] => Mary
        )

)

Collectives™ on Stack Overflow

Comparing multidimensional arrays using specific key in php

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related