For reading it all at once you can use: $csv = array_map(“str_getcsv”, file(“file1.csv”,FILE_SKIP_EMPTY_LINES)); $keys = array_shift($csv); To turn all the rows into a nice associative array you could then apply: foreach ($csv as $i=>$row) { $csv[$i] = array_combine($keys, $row); }
Try this: function removeBomUtf8($s){ if(substr($s,0,3)==chr(hexdec(‘EF’)).chr(hexdec(‘BB’)).chr(hexdec(‘BF’))){ return substr($s,3); }else{ return $s; } }
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”; … Read more