dongliufa6380 2019-06-06 20:01
浏览 143
已采纳

如何通过行和列值获取csv单元格值

I have a simple CSV table

Name,Year of birth,City
Yeremy,1980,New York
Louis,1982,Washington
Marta,1987,Chicago
David,1985,Los Angeles

Also, I have this code to can get cell value by number of row and number of column:

$trow = 3;
$tcolumn = 3;

$output .= '<span>';
$row = 1;
$mycsvfile = array();
if (($handle = fopen($abspath, "r")) !== FALSE) {
   while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
   $num = count($data);
   $row++;
   $mycsvfile[] = $data;.
   }
   fclose($handle);
}
$output .= $mycsvfile[$trowN][$tcolumnN];
$output .= '</span>';

I want to define that $trow=Marta and $tcolumn=City, so, in this case to get value "Chicago"...

  • 写回答

1条回答 默认 最新

  • doupingzhi9674 2019-06-06 20:11
    关注

    The code could be optimized a lot, but with the current code:

    $output .= array_column($mycsvfile, null, 0)['Marta'][2];
    
    • Re-index the array on the values in the Name (column 0)
    • Access the one with index Marta, getting the value in the City (column 2)

    You can access by column name if you combine the column names:

    if (($handle = fopen($abspath, "r")) !== FALSE) {
       $columns = fgetcsv($handle, 1000, ",");
    
       while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
           $mycsvfile[] = array_combine($columns, $data);
       }
       fclose($handle);
    }
    $output .= array_column($mycsvfile, null, 'Name')['Marta']['City'];
    

    Keep in mind that if Marta occurs more than once in the Name column then the LAST one will be returned.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 在获取boss直聘的聊天的时候只能获取到前40条聊天数据
  • ¥20 关于URL获取的参数,无法执行二选一查询
  • ¥15 液位控制,当液位超过高限时常开触点59闭合,直到液位低于低限时,断开
  • ¥15 marlin编译错误,如何解决?
  • ¥15 有偿四位数,节约算法和扫描算法
  • ¥15 VUE项目怎么运行,系统打不开
  • ¥50 pointpillars等目标检测算法怎么融合注意力机制
  • ¥20 Vs code Mac系统 PHP Debug调试环境配置
  • ¥60 大一项目课,微信小程序
  • ¥15 求视频摘要youtube和ovp数据集