在多维数组上搜索值然后显示结果

Question

I'm trying to retrieve the values on multidimensional arrays using a search like function.

$rows = array(
    array(
        'Name'=>'City of God',
        'Year'=>'2002',
        'Rating'=>'10'
    ),
    array(
        'Name'=>'The Great Escape',
        'Year'=>'1963',
        'Rating'=>'9'
    ),
    array(
        'Name'=>'Dune',
        'Year'=>'1984',
        'Rating'=>'6'
    ),
    array(
        'Name'=>'Superbabies: Baby Geniuses 2',
        'Year'=>'2004',
        'Rating'=>'1'
    )
);

So for example, if you want to search the array with a value of Name with 'City of God' and Year with '1963' the expected output should be like this

$rows = array(
    array(
        'Name'=>'City of God',
        'Year'=>'2002',
        'Rating'=>'10'
    ),
    array(
        'Name'=>'The Great Escape',
        'Year'=>'1963',
        'Rating'=>'9'
    ),
);

Currently, the function I am using is this

function multiSearch(array $array, array $pairs)
{
    $found = array();
    foreach ($array as $aKey => $aVal) {
        $coincidences = 0;
        foreach ($pairs as $pKey => $pVal) {
            if (array_key_exists($pKey, $aVal) && $aVal[$pKey] == $pVal) {
                $coincidences++;
            }
        }

        if ($coincidences == count($pairs)) {
            $found[$aKey] = $aVal;
        }
    }

    return $found;
} 

However, using this function only capable of retrieving data of the same array key. So for example if I search the value of Name of 'City of God'

$x = multiSearch($rows, array('Name' => 'City of God') 

This will display the correct output like this

$rows = array(
    array(
        'Name'=>'City of God',
        'Year'=>'2002',
        'Rating'=>'10'
    ),
);

Unfortunately, if you try to use, 'Name' => 'City of God' and 'Year' => '1963' It will not display any output. I'm stuck on figuring out on displaying the correct output, any ideas would be appreciated

Answer 1

Try this :

$datas = array(
    array(
        'Name'=>'City of God',
        'Year'=>'2002',
        'Rating'=>'10'
    ),
    array(
        'Name'=>'The Great Escape',
        'Year'=>'1963',
        'Rating'=>'9'
    ),
    array(
        'Name'=>'Dune',
        'Year'=>'1984',
        'Rating'=>'6'
    ),
    array(
        'Name'=>'Superbabies: Baby Geniuses 2',
        'Year'=>'2004',
        'Rating'=>'1'
    )
);

$search = array(
    'Name' => 'Dune',
    'Year' => '2004'
);

$output = array();
foreach ($datas as $key1 => $row) {
    foreach ($row as $key2 => $value) {
        if($search[$key2] == $value) {
        // if(stristr($value, $search[$key2]) !== FALSE) {  // if you want to search
            $output[] = $datas[$key1];
            break;
        }
    }
}

echo "<pre>"; print_r($output); exit;

Output:

Array
(
    [0] => Array
        (
            [Name] => Dune
            [Year] => 1984
            [Rating] => 6
        )

    [1] => Array
        (
            [Name] => Superbabies: Baby Geniuses 2
            [Year] => 2004
            [Rating] => 1
        )

)