Count number of rows in a CSV file with PHP in a particular column

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

It's possible! How are you counting rows? Please edit your post to include code snippets that are appropriate. — Muhammad Abdul-Rahim
– Muhammad Abdul-Rahim, Commented May 7, 2015 at 13:45
yes I tried counting columns and other approaches but can't seem to figure it out. — jibly
– jibly, Commented May 7, 2015 at 13:56

Yasen Zhelev · Accepted Answer · 2015-05-07 14:41:42Z

3

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;

answered May 7, 2015 at 14:41

Yasen Zhelev

4,0454 gold badges33 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Count number of rows in a CSV file with PHP in a particular column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related