Using PHP fgetcsv() to Read and Parse CSV Files

fgetcsv() reads a line from an open file pointer, parses it as CSV, and returns an array of fields.

It works similarly to fgets() but automatically splits the line according to the specified delimiter, enclosure and escape characters. The function signature is

array fgetcsv ( resource $handle [, int $length = 0 [, string $delimiter = ',' [, string $enclosure = '"' [, string $escape = '\\' ]]]] )

.

Parameters: $handle – a valid file pointer from fopen(), popen() or fsockopen(); $length – maximum line length (optional, 0 means no limit); $delimiter – field separator (single character); $enclosure – field enclosure character; $escape – escape character (default backslash).

Return value: an indexed array of fields, NULL on invalid handle, FALSE on EOF or error.

Example usage:

<?php
$handle = fopen('test.csv', 'r');
if ($handle !== FALSE) {
    $row = 1;
    while (($data = fgetcsv($handle, 1000, ',')) !== FALSE) {
        $num = count($data);
        echo "<p>$num fields in line $row:<br/></p>
";
        $row++;
        for ($c = 0; $c < $num; $c++) {
            echo $data[$c] . "<br />
";
        }
    }
    fclose($handle);
}
?>