Process CSV Into Array With Column Headings For Key

php arrays csv heading
Bit Bucket picture Bit Bucket · Apr 16, 2012 · Viewed 47.3k times · Source

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 column heading. I guess it would something like this for row 1:

$array = [
    "Make" => "Chevy",
    "Model" => "1500",
    "Note" => "loaded"
];

...row 2...

$array = [
    "Make" => "Chevy",
    "Model" => "1500",
    "Note" => ""
];

...and row 3...

$array = [
    "Make" => "Chevy",
    "Model" => "",
    "Note" => "loaded"
];

I'm not sure how to do this other than statically - problem is the columns with their associated data could change from one file to the next... columns rearranged, dropped, or added.

You ideas are much appreciated.

Answer

Tim Cooper picture Tim Cooper · Apr 16, 2012 
$all_rows = array();
$header = fgetcsv($file);
while ($row = fgetcsv($file)) {
  $all_rows[] = array_combine($header, $row);
}

print_r($all_rows);

Related questions

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

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 …

Read More
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