Search in a multidimensional array (PHP)

Question

Recently, I have a problem that drives me crazy. I have a multidimensional array like this:

$a = array(
'db' => array(
    '0' => array(
        'id' => '1',
        'name' => 'test',
        'cat' => array(
            'a' => '15',
            'b' => '20',
            'c' => '30'
        ),
        'canvas' => '2'
    ),
    '1' => array(
        'id' => '2',
        'name' => 'test2',
        'cat' => array(
            'a' => '15',
            'b' => '20',
            'c' => '30'
        ),
        'canvas' => '2'
    )
    '2' => array(
        'id' => '3',
        'name' => 'test',
        'cat' => array(
            'a' => '50',
            'b' => '40',
            'c' => '90'
        ),
        'canvas' => '1'
    )
)
);

And I want to find it using a function like this: search ('canvas = 1');

This will return all arrays, db children that have a key canvas with a value of 1. Or, for example:

search ('a = 15');

Will return all arrays that have a key, a child of cat, with the name a and a value of 15.

Answer 1

$a = array(
'db' => array(
    '0' => array(
        'id' => '1',
        'name' => 'test',
        'cat' => array(
            'a' => '15',
            'b' => '20',
            'c' => '30'
        ),
        'canvas' => '2'
    ),
    '1' => array(
        'id' => '2',
        'name' => 'test2',
        'cat' => array(
            'a' => '15',
            'b' => '20',
            'c' => '30'
        ),
        'canvas' => '2'
    ),
)
);

//checks if array $array contains element with $searchKey key, and $searchVal value
function arrayContains($array, $searchVal, $searchKey) {
        if (!is_array($array))
            return false;
        foreach ($array as $key => $value) {
            if ($key === $searchKey && $searchVal === $value)
                return true;
            if (is_array($value) && arrayContains($value, $searchVal, $searchKey))
                return true;
        }
        return false;
    }

function search($a, $search) {
    list($searchKey, $searchVal) = explode('=', $search);
    $result = array();
    foreach($a as $val) {
        if (arrayContains($val, $searchVal, $searchKey))
            $result[] = $val;
    }
    return $result;
}

print_r(search($a['db'], "a=15"));
print_r(search($a['db'], "canvas=1"));

What produces this output (outputs subarrays of $ a ['db'] that contain the found key pair => value):

Array
(
    [0] => Array
        (
            [id] => 1
            [name] => test
            [cat] => Array
                (
                    [a] => 15
                    [b] => 20
                    [c] => 30
                )

            [canvas] => 2
        )

    [1] => Array
        (
            [id] => 2
            [name] => test2
            [cat] => Array
                (
                    [a] => 15
                    [b] => 20
                    [c] => 30
                )

            [canvas] => 2
        )

)
Array
(
    [0] => Array
        (
            [id] => 3
            [name] => test
            [cat] => Array
                (
                    [a] => 50
                    [b] => 40
                    [c] => 90
                )

            [canvas] => 1
        )

)

Answer 2

, - http://php.net/manual/en/function.array-search.php

php array_search() .

Answer 3

function search($array, $canvas)
{
    $result = array();
    foreach ($array as $k1 => $v1) {
        foreach ($v1 as $k2 => $v2) {
            if ($v2['canvas'] == $canvas) {
                $result[] = $array[$k1][$k2];
            }
        }
    }
    return $result;
}

// $a = your array
print_r(search($a, 1));