php从数组中获取特定列的所有值

Question

Array ( [0] => Array ( [No.,"Ticker","Company"] => 
                        1,"A","Agilent Technologies Inc." ) 
        [1] => Array ( [No.,"Ticker","Company" ] => 
                        2,"AA","Alcoa, Inc.") 
      )

这是我输入 print_r($arrayOne) 时的输出；
我该怎么做才能获得 Company 列，即 Agilent Technologies Inc 和 Alocoa, Inc.

我试过 echo $arrayOne['Company'] 和 $arrayOne[0]['Company'] 但它只是输出了'Array'。

Answer 1

您拥有的是一个带有两个子数组的外部数组，每个子数组只有一个值。它的key是3列的描述，value是CSV值。如果您有 PHP 5.3，请使用 str_getcsv() 解析它并返回第三列

// Loop over the outer array
foreach ($arrayOne as  $subarr) {
  // Loop over the sub-arrays (though your sample only has one value each)
  // could also use array_pop()
  foreach ($subarr as $key => $csvstring) {
    // $csvstring holds the CSV value like  '1,"A","Agilent Technologies Inc."'
    // Parse it with str_getcsv()
    $cols = str_getcsv($csvstring);
    // Company name is the 3rd value, key [2]
    echo $cols[2] . "\n";
  }
}

例如输入:

$arrayOne = array(
  array('No.,"Ticker","Company"' => '1,"A","Agilent Technologies Inc."' ), 
  array('No.,"Ticker","Company"'  => '2,"AA","Alcoa, Inc."') 
);
// The above loop prints:
Agilent Technologies Inc.
Alcoa, Inc.