php loop through 2 arrays to find keys and values that match

Question

I have the following arrays named investmentprogramscriteria and companyInvestmentProfil:

Array
(
[0] => Array
    (
        [investmentprogramcriteriaID] => 20
        [investmentprogramID] => 21
        [criteriaID] => 59
        [criteriaIsMatchedIf] => 1
    )

[1] => Array
    (
        [investmentprogramcriteriaID] => 21
        [investmentprogramID] => 21
        [criteriaID] => 57
        [criteriaIsMatchedIf] => 1
    )

)


Array
(
[0] => Array
    (
        [investmentprofileID] => 1
        [companyID] => 27
        [criteriaID] => 54
        [investmentprofileCriteriaAnswer] => 1
    )

[1] => Array
    (
        [investmentprofileID] => 2
        [companyID] => 27
        [criteriaID] => 57
        [investmentprofileCriteriaAnswer] => 0
    )

[2] => Array
    (
        [investmentprofileID] => 3
        [companyID] => 27
        [criteriaID] => 58
        [investmentprofileCriteriaAnswer] => 0
    )

[3] => Array
    (
        [investmentprofileID] => 4
        [companyID] => 27
        [criteriaID] => 59
        [investmentprofileCriteriaAnswer] => 1
    )

)

If the last 2 KEYS AND THEIR VALUES from the first array are found in the second array, code should return match, else should return not match.

I make an attempt to resolve this with array functions, but nothing worked and now I am trying to solve it with php, but no luck so far.

I am trying with:

foreach ($investmentprogramscriteria as $programcriteria) {
    //foreach($companyInvestmentProfil as $profile) {
        if (($programcriteria['criteriaID'] == $companyInvestmentProfil[$i]['criteriaID']) && ($programcriteria['criteriaIsMatchedIf'] == $companyInvestmentProfil[$i]['investmentprofileCriteriaAnswer']))  {
        $match = "Match";                              
    } else {
       $match = "Not Match";
       continue;
// }                                
}

                        }

Jack jdeoel · Accepted Answer · 2016-08-31 10:14:10Z

2

The best way is use foreach twice !!!

foreach ($investmentprogramscriteria  as $value) {
    foreach ($companyInvestmentProfil as $v) {
        if($v["criteriaID"] == $value["criteriaID"]) echo "match<br>";
        else echo "not Match<br>";
    }    
}

answered Aug 31, 2016 at 10:14

Jack jdeoel

4,5886 gold badges28 silver badges57 bronze badges

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

2 Comments

user2417624 Over a year ago

Like this, I get bunch of match and / or not match, depending from the key. Even if one value is not matched, code should return not match. Any idea how to do that?

Elias Van Ootegem Over a year ago

This will return a match for every $companyInvestmentProfil value that matches any $investmentprogramscriteria value. I think OP is after a 1-to-1 match

Elias Van Ootegem · Accepted Answer · 2016-08-31 10:37:38Z

2

Update

Your code contains a bug:

$programcriteria['criteriaID'] == $companyInvestmentProfil[$i]['criteriaID']

the variable $i is never defined. You probably meant to write something like:

// assign keys to $i
foreach ($investmentprogramscriteria as $i => $programcriteria) {
}

In which case, either using the array_slice + array_keys approach below, with or without the array_intersect_assoc approach should work, if you use them on the $programcriteria and $companyInvestmentProfil[$k] arrays respectively.

What you're basically looking for is the array_intersect_assoc function. That function returns an array with all key-value pairs that are present in both arrays:

$intersect = array_intersect_assoc($array1, $array2);

To see how many key-value pairs match, just count($intersect);

To see if the last 2 keys of the first array matched, simply write this:

$lastKeys = array_slice(array_keys($array1), -2);
if (isset($intersect[$lastKeys[0]]) && isset($intersect[$lastKeys[1])) {
    return 'match';
}
return 'no match';

Check the manual on array_slice for details.

edited Aug 31, 2016 at 10:37

answered Aug 31, 2016 at 9:59

Elias Van Ootegem

76.7k10 gold badges123 silver badges160 bronze badges

6 Comments

user2417624 Over a year ago

give me a moment to try this

user2417624 Over a year ago

$intersect didn't worked. However ,if you can notice, my keynames are not the same. Do you think that that may be the reason why intersect give wrong results?

Elias Van Ootegem Over a year ago

Set up a fiddle with what you tried. I've used $array1 and $array2 as variable names, but I suspect what you need/want is $investmentprogramscriteria[0] and $companyInvestmentProfil[0] instead

Elias Van Ootegem Over a year ago

@user2417624: I've also spotted an issue in the code you originally posted, updated my answer and added some suggestions on how to use the functions I mentioned correctly

user2417624 Over a year ago

I was googling where I can create fiddle, when I notice your second comment. The [$i] variable is setted elsewhere in the code, because there may be many investment programs array, so I was trying to use it, but it is the one that cause the issues. However, If I use [0] as you suggest, it will check only the first key-value par and then it will stop.

|

sunil patidar · Accepted Answer · 2017-03-24 05:52:23Z

0

$array1 = array("a" => "greens", "reds", "blues", "red");
$array2 = array("b" => "green", "yellow", "red");
$result = array_intersect($array1, $array2);

 if(is_array($result)){
    echo 'match';
 }else{
    echo 'not match';
 }

answered Mar 24, 2017 at 5:52

sunil patidar

846 bronze badges

Collectives™ on Stack Overflow

php loop through 2 arrays to find keys and values that match

3 Answers 3

2 Comments

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related