dongyuan9149 2015-05-07 13:44
浏览 163
已采纳

使用特定列中的PHP计算CSV文件中的行数

I've got my php working to count the number of rows in the full csv document, but trying to get a number of rows that have data in them in a particular column. Is this possible with PHP?

$fp = file('test.csv');
echo count($fp);
  • 写回答

1条回答 默认 最新

  • duanjianao0592 2015-05-07 14:41
    关注

    You can use fgetcsv function and check in every row the data.

    For example if you want to check how many rows have data in the second column, run that.

    $data_found = 0;
    $handle = fopen("test.csv", "r");
    while ($data = fgetcsv($handle))
    {
      if ($data[1] != '')
      {
        // check the data specifically in the second column
        $data_found ++;
      }
    }
    echo 'Rows with data in the second column:'.$data_found;
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

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