php把csv文件内容转为数组,php – 将CSV转换为数组

我有这个数组与机场代码和城市名称(约3500行).

code,city

"Abilene, TX ",ABI

"Adak Island, AK ",ADK

"Akiachak, AK ",KKI

"Akiak, AK ",AKI

"Akron/Canton, OH ",CAK

"Akuton, AK ",KQA

"Alakanuk, AK ",AUK

"Alamogordo, NM ",ALM

我需要将该文件转换为php数组.到目前为止这是我的代码：

if(($handle = fopen('test.csv', 'r')) !== FALSE) {

while (($data = fgetcsv($handle, 1000, ',', '"')) !== FALSE) {

echo '

';

print_r($data);

echo '

';

}

fclose($handle);

}

虽然我正在设置fgetcsv函数的分隔符和封闭字符,但是我得到了这个结果：

Array

(

[0] => code

[1] => city

"Abilene

[2] => TX "

[3] => ABI

"Adak Island

[4] => AK "

[5] => ADK

"Akiachak

[6] => AK "

[7] => KKI

"Akiak

[8] => AK "

[9] => AKI

"Akron/Canton

[10] => OH "

[11] => CAK

"Akuton

[12] => AK "

[13] => KQA

"Alakanuk

[14] => AK "

[15] => AUK

"Alamogordo

[16] => NM "

[17] => ALM

)