在PHP中，fgetcsv将文件转换为一个数组

Question

I have a csv file I'm uploading that is structured like this:

SKU,STATUS,SUPPLIER,PRODUCT TYPE,PRODUCT SUBTYPE,PRODUCT STYLE,PRODUCER NAME,PRODUCT NAME,VINTAGE,RAW MATERIALS
00788305,Active,Pabst Brewery,Beer,Specialty,Spice/Herb/Vegetable,Small Town Brewery,Not Your Father's Root Beer (Units of 4),,
00380314,Active,The Patr¢n Spirits Company,Spirit,Tequila,Extra A§ejo,Patr¢n,En Lalique Serie 1 Extra A§ejo Tequila,,
00255814,Active,Huneeus Vintners,Wine,Still,White,Veramonte,Valle de Casablanca Chardonnay,,Chardonnay

The csv was created from an excel spreadsheet export.

When I run fgetcsv against the uploaded file I get one long array instead of each line placed into its own array as expected.

Answer 1

From the PHP Docs:

Note: If PHP is not properly recognizing the line endings when reading files either on or created by a Macintosh computer, enabling the auto_detect_line_endings run-time configuration option may help resolve the problem.

fgetcsv() will only read one row at a time, so you will need to loop over the file calling fgetcsv() to read each row in turn until you reach the end of the file.

while (($data = fgetcsv($fh, 1024, ",")) !== FALSE) {
    // Do whatever you need to do with the data
}