Looking how to read a CSV using PHP? What to import a CSV into our database? The code snippet below will help you do just that.

PHP.net has the manual for the fgetcsv which is used in this example.

Example

$row = 1; if (($handle = fopen("test.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $num = count($data); echo "

$num fields in line $row:

\n"; $row++; for ($c=0; $c \n"; } } fclose($handle); }

Replace test.csv with your own file.

This snippet will parse CSV into a multidimensional array

*All code snippets are open source, everyone is free to use.

PhP Tricks