Compare two associative arrays problem.

Question

Not very good at explaining these things so will try my best.

I have two associative arrays:

array(1)

  ["result"]=> array(2) { 
                                    ["status"]=> int(1) 
                                    ["names"]=> array(1209) {
 [0]=> array(2) {
 ["id"]=> int(58725218) 
 ["defindex"]=> int(4036) 



array(2)

  ["result"]=> array(2) { 
                                    ["status"]=> int(1) 
                                    ["names"]=> array(4000) {
 [0]=> array(3) {
 ["id"]=> int(58725218) 
["name"]=>string("robert") 
 ["defindex"]=> int(4036)

I want to first check that if array1['result']['defindex'] matches a array2['result']['defindex'] .

Then I want to print out only the array2['result']["name"] for all that match but as array1 does not contain a ['name'] key I am now stunk on how I can do this.

As im new to PHP I checked the documentation and found array_intersect_assoc function but this only returns the the keys and values of those that match.

If I have made a balls of asking the question I do apologise but any help here would be amazing.

Thanks in advance to anyone who can help.

Answer 1 · 2014-04-27T04:18:25Z

April 27, 2014 4:18am

Hello,

By what you are asking, I created a simple script that does what you are asking for. I haven't tested the script but I know that it should work syntactically.

$count = (count(array1["names"]) <= count(array2["names"])) ? count(array1["names"]) : count(array2["names"]);

for($i=0; $i<$count; $i++) {
   if(array1["names"][$i]["defindex"] == array2["names"][$i]["defindex"]) {
      echo array2["names"][$i]["name"];
   }
}

LINE1: finds out if the size of array1 is less than or equal to array 2 then use the count for the smallest array. LINE2: uses a for loop to loop through both arrays LINE3: checks to see if the defindex for both arrays match LINE4: echos out the value in the name key of array2

I hope this what you are asking or close. I know you can probably do it some other way, but I go for simplicity since you don't know that much about PHP. Hope this what you are looking for; if not I can always modify it to your specs.

Cheers!

Answer 2 · 2014-04-27T05:08:50Z

April 27, 2014 5:08am

No that does not work for me, I understand what that is doing too but I think I need something different than that.

Both arrays have a ['defindex']

array1 holds a list of employees in a particular department

array2 holds every employee in the company

So to get array1 I use a company api to return an array of ['names']=> array(1209} for the design team. The design team has 1209 employees.

Then using another api call I bring back array2 which is the full list of employees ["names"]=> array(4000) The company has 4000 employees.

I want to then match the [' defindex'] from both array1 and array2 removing all that do not match from array2.

It must leave other keys and values though, it can not just return an array with only ['defindex'] I want it to give me all of the ['names'] array key=>values from array2 if array1['defindex'] match.

Then store what is left from array2 into a variable and foreach loop over it printing out their names and other key=>values from that array.

As I say I am really poor at explaining this but hopefully you can understand what I mean.

Welcome to the Treehouse Community

Looking to learn something new?

Robert Walker

Robert Walker

Compare two associative arrays problem.

2 Answers

Shawn Gregory

Shawn Gregory

Robert Walker

Robert Walker