How to create an array from a CSV file using PHP and the fgetcsv function

php arrays csv
Thomas picture Thomas · Aug 13, 2009 · Viewed 287.3k times · Source

Can someone kindly provide a code to create an array from a CSV file using fgetcsv?

I've used the following code to create an array from a simple CSV file, but it doesn't work right when one of my fields has multiple commas - such as addresses.

$lines =file('CSV Address.csv');

foreach($lines as $data)
{
list($name[],$address[],$status[])
= explode(',',$data);
}

*Also, str_getcsv is not supported by my hosting service.

The above code doesn't work with the following CSV file example. First column is name, second column is address, third column is marital status.

Scott L. Aranda,"123 Main Street, Bethesda, Maryland 20816",Single
Todd D. Smith,"987 Elm Street, Alexandria, Virginia 22301",Single
Edward M. Grass,"123 Main Street, Bethesda, Maryland 20816",Married
Aaron G. Frantz,"987 Elm Street, Alexandria, Virginia 22301",Married
Ryan V. Turner,"123 Main Street, Bethesda, Maryland 20816",Single

Answer

Dave DeLong picture Dave DeLong · Aug 13, 2009

Like you said in your title, fgetcsv is the way to go. It's pretty darn easy to use.

$file = fopen('myCSVFile.csv', 'r');
while (($line = fgetcsv($file)) !== FALSE) {
  //$line is an array of the csv elements
  print_r($line);
}
fclose($file);

You'll want to put more error checking in there in case fopen() fails, but this works to read a CSV file line by line and parse the line into an array.

Related questions

php implode (101) with quotes

Imploding a simple array would look like this $array = array('lastname', 'email', 'phone'); $comma_separated = implode(",", $array); and that would return this lastname,email,phone great, so i might do this instead $array = array('lastname', 'email', 'phone'); $comma_separated = implode("…

Read More
CSV to Associative Array

I've seen numerous examples on how to take a CSV file and then create an associative array with the headers as the keys. For example: Brand,Model,Part,Test Honda,Civic,123,244 Honda,Civic,135,434 Toyota,Supra,511,664 Where it would create an …

Read More
Process CSV Into Array With Column Headings For Key

I have a CSV with the first row containing the field names. Example data is... "Make","Model","Note" "Chevy","1500","loaded" "Chevy","2500","" "Chevy","","loaded" I need my data formatted in an array of key-value pairs where the key name is the …

Read More