Ravens PHP Scripts

How To Read A CSV With PHP
Date: Monday, December 21, 2020 @ 11:21:24 CET
Topic: PHP


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









This article comes from Ravens PHP Scripts
https://www.ravenphpscripts.com

The URL for this story is:
https://www.ravenphpscripts.com/modules.php?name=News&file=article&sid=4089