Differences

This shows you the differences between two versions of the page.

--- prog:php:samples:csv_parse [2022/03/15 13:10] – rene
+++ prog:php:samples:csv_parse [2023/11/10 16:01] (current) – rene
@@ Line 1: / Line 1: @@
-One liner to get a CSV file into 2-dimentional array:
+One liner to get a CSV file into 2-dimentional array
+NB! Only works if "," is the separator!!!
+NB! Does not work if CSV cells have line breaks in them!!!
 <code php>
 $csv = array_map('str_getcsv', file('data.csv'));
@@ Line 11: / Line 13: @@
 $is_first_row_header = true;
-for ($i = 0; $row = fgetcsv($handle ); ++$i) {
+for ($i = 0; $row = fgetcsv($handle, null, ";"); ++$i) {
     if ($is_first_row_header AND $i == 0) {
         $headers = $row;
+        continue;
     }
-    // Do something will $row array
+    // Do something with $row array
     $row[''];
 }
 fclose($handle);
 </code>