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

Question

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);

Answer 1

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;