How to parse a CSV file using PHP [duplicate] How to parse a CSV file using PHP [duplicate] php php

How to parse a CSV file using PHP [duplicate]


Just use the function for parsing a CSV file

http://php.net/manual/en/function.fgetcsv.php

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


A bit shorter answer since PHP >= 5.3.0:

    $csvFile = file('../somefile.csv');    $data = [];    foreach ($csvFile as $line) {        $data[] = str_getcsv($line);    }


Handy one liner to parse a CSV file into an array

$csv = array_map('str_getcsv', file('data.csv'));