搜索数组值并返回php中的行

Question

Can't find quite the right answer so hope someone can help. Basically want to Search [VIN] value and if matched then return [MEDIAID] or row.

Array
(
    [0] => Array
        (
            [CLIENTID] => GALLEY
            [VIN] => WBAFDEG2317MCB73388
            [MEDIAID] => 10011020061817-galley_082114-SDvcl-140880481613056500
            [DEALERNAME] => Demo
            [PUBLISHON] => 2014-08-28
        )
    [1] => Array
        (
            [CLIENTID] => GALLEY
            [VIN] => WAULC68E74A053WE251
            [MEDIAID] => 10011020061817-galley_082114-SDvcl-140880482109709900
            [DEALERNAME] => Demo
            [PUBLISHON] => 2014-08-26
        )
    [2] => Array
        (
            [CLIENTID] => GALLEY
            [VIN] => WAULC68E74A053WE251
            [MEDIAID] => 10011020061817-galley_082114-SDvcl-140880482109709900
            [PUBLISHON] => 2014-08-26
        )
)       

I need do this in php.

Answer 1

Function structure copied from this already answered question, and I just made a few changes to make it work for your application:

function searchForId($id, $array) {
   foreach ($array as $key => $val) {
       if ($val['VIN'] === $id) {
           return $val['MEDIAID'];
       }
   }
   return null;
}

$array = array(
  0=> array(
    'CLIENTID' => 'GALLEY',
    'VIN' => 'WBAFDEG2317MCB73388',
    'MEDIAID' => '10011020061817-galley_082114-SDvcl-140880481613056500',
    'DEALERNAME' => 'Demo',
    'PUBLISHON' => '2014-08-28'
    ),
  1=> array(
    'CLIENTID' => 'GALLEY',
    'VIN' => 'WAULC68E74A053WE251',
    'MEDIAID' => '10011020061817-galley_082114-SDvcl-140880482109709900',
    'DEALERNAME' => 'Demo',
    'PUBLISHON' => '2014-08-26'
    ),
  2=> array(
    'CLIENTID' => 'GALLEY',
    'VIN' => 'WAULC68E74A053WE251',
    'MEDIAID' => '10011020061817-galley_082114-SDvcl-140880482109709900',
    'DEALERNAME' => 'Demo',
    'PUBLISHON' => '2014-08-26'
    ),    
  );

$search = searchForId('WAULC68E74A053WE251', $array);

var_dump($search);

Result:

string(53) "10011020061817-galley_082114-SDvcl-140880482109709900"

See demo