PHP return associative array, by multiple element search?

Question

I have an array that looks something like this:

$array = array(
    array('Field1' => 'red',  'Field2' => 'green',   'Field3' => 'blue'),
    array('Field1' => 'pink', 'Field2' => 'pinkish', 'Field3' => 'barbiecolor'),
    array('Field1' => 'red',  'Field2' => 'blue', '   Field3' => 'orange')
);

And I want to check this by the given values:

$searchBy = array('Field1' => 'red', 'Field2' => 'blue');

What I want to achieve, is to return the parent array that has all associative key & value pairs matched. I've tried in_array() but it doesn't work..

Niet the Dark Absol · Accepted Answer · 2013-04-21 19:29:59Z

3

array_filter may be better for this:

$matches = array_filter($array,function($a) use ($searchBy) {
    foreach($searchBy as $k=>$v) {
        if( $a[$k] != $v) return false;
    }
    return true;
});

answered Apr 21, 2013 at 19:29

Niet the Dark Absol

326k86 gold badges480 silver badges604 bronze badges

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

4 Comments

dbf Over a year ago

Do note the minimal required PHP version though ;)

Niet the Dark Absol Over a year ago

Oh yes. This'll work in PHP 5.3, but before that you will need to use create_function instead.

Matt Over a year ago

@Kolink - thanks works perfect! In the interest of older versions, how do you define this search function? Thanks

Niet the Dark Absol Over a year ago

Something like this: create_function('$a','global $searchBy; foreach($searchBy as $k=>$v) {if($a[$k] != $v) return false;} return true;');

Baba · Accepted Answer · 2013-04-21 21:15:25Z

1

You can try:

$find = array_filter($array, function ($a) use($searchBy) {
    return array_intersect_assoc($searchBy, $a) == $searchBy;
});

See Live Demo

Old School Version

$find = find($searchBy, $array);
print_r($find);

// Function used
function find($needle, $haystack) {
    $r = array();
    foreach ( $haystack as $k => $a ) {
        array_intersect_assoc($needle, $a) == $needle and $r[$k] = $a;
    }
    return $r;
}

Old School Demo

edited Apr 21, 2013 at 21:15

answered Apr 21, 2013 at 20:22

Baba

95.3k29 gold badges172 silver badges222 bronze badges

2 Comments

Matt Over a year ago

is it possible to achieve this with PHP < 5.3 ?

Baba Over a year ago

@Matt i won't post it because if am not using loop am forced to use globals which i don't believe in 3v4l.org/IRLu5 but i would update with a simple loop version

Collectives™ on Stack Overflow

PHP return associative array, by multiple element search?

2 Answers 2

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related