PHP: Search in 2-Dimensional array but only look in specific key

Question

I want to search through a 2-dimensional array, but I only want to search in a specific field in the 2nd Dimension. If found, I would like to return the Key. No need to go on from there, I only need the first occurence but I wouldn't mind to get all occurences either.

The Array might look like this:

$array = [
    0 => ['value' => 'x', 'foo' => 'bar'],
    1 => ['value' => 'y', 'foo' => 'bar'],
    2 => ['value' => 'z', 'foo' => 'x'],
];

Now my first thought would be something like this:

function myCustomArraySearch($array, $searchkey, $searchvalue) {
    foreach ($array as $key => $value) {
        if ($value[$searchkey] == $searchvalue) {
            return $key;
        }
    }
    return false;
}

echo myCustomArraySearch($array, 'value', 'x');

I'm sure, there is a more elegnt solution. Any ideas?

Try array_walk_recursive built-in php function php.net/manual/ro/function.array-walk-recursive.php — Devendra Singh Bhandari
– Devendra Singh Bhandari, Commented Nov 5, 2015 at 15:43

AbraCadaver · Accepted Answer · 2015-11-09 13:34:54Z

4

Here is one way that returns a single key:

$result = array_search('x', array_column($array, 'value'));

This will return multiple keys:

$result = array_keys(array_column($array, 'value'), 'x');

If you don't have PHP >= 5.5.0 needed for array_column() then use this in it's place:

array_map(function($v) { return $v['value']; }, $array)

edited Nov 9, 2015 at 13:34

answered Nov 5, 2015 at 15:43

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

1 Comment

Marcus Haase Over a year ago

There seams to be a small typo here: array_map(function($v) { return $v['value']; }, $array)

yosbel · Accepted Answer · 2015-11-05 17:14:22Z

2

The functions below returns the position of the first occurrence:

1 - Using foreach iteration and array_serach

function search1($array, $key, $value) {
    foreach ($array as $k => $arr) {
        if (array_search($value, $arr) != false) {
            return $k;
        }
    }
    return false;
}

2 - Using array_map, array_key_exists and array_search.

function search2($array, $key, $value) {
    $mapped = array_map(function($arr) use ($key, $value) {
        return (array_key_exists($key, $arr) && $arr[$key] == $value)
               ? true
               : false;
    },
    $array);    

    return array_search(true, $mapped);
}

edited Nov 5, 2015 at 17:14

answered Nov 5, 2015 at 16:45

yosbel

3391 silver badge4 bronze badges

Comments

Christian · Accepted Answer · 2015-11-06 09:18:10Z

2

Your code is working fine so this code just does it in less lines. Only works for PHP 5.5+.

function myCustomArraySearch($array, $searchkey, $searchvalue) {
    $cols   = array_column($array, $searchkey);
    $result = array_search($searchvalue, $cols);
    return $result;
}

Of course, if you wanted to return the array it found and not just the index you would just return like so:

function myCustomArraySearch($array, $searchkey, $searchvalue) {
    $cols   = array_column($array, $searchkey);
    $result = array_search($searchvalue, $cols);
    return $array[$result];
}

answered Nov 6, 2015 at 9:18

Christian

1,57712 silver badges16 bronze badges

Collectives™ on Stack Overflow

PHP: Search in 2-Dimensional array but only look in specific key

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related