How can I get the total number of rows in a CSV file with PHP?

Question

How can I get the total number of rows that are in a CSV file using PHP? I'm using this method but can get it to work properly.

if (($fp = fopen("test.csv", "r")) !== FALSE) {    while (($record = fgetcsv($fp)) !== FALSE) {       $row++;   }    echo $row; } 

Answer 1

Create a new file reference using SplFileObject:

$file = new SplFileObject('test.csv', 'r'); 

Try to seek to the highest Int PHP can handle:

$file->seek(PHP_INT_MAX); 

Then actually it will seek to the highest line it could in the file, there is your last line and the last line + 1 is equals to your total lines:

echo $file->key() + 1; 

Tricky, but this will avoid you from loading the file contents into memory, which is a very cool thing to do when dealing with really large files.

Answer 2

Here's another option using file() to read the entire file into an array, automatically parsing new lines etc:

$fp = file('test.csv'); echo count($fp); 

Also, since PHP5, you can pass in the FILE_SKIP_EMPTY_LINES... to skip empty lines, if you want to:

$fp = file('test.csv', FILE_SKIP_EMPTY_LINES); 

Manual: http://php.net/manual/en/function.file.php