PHP读取CSV文件

二话不说 直接上代码

1function getCSVdata($filename)
2{
3    $row = 1;//第一行开始
4    if(($handle = fopen($filename, "r")) !== false){
5        while(($dataSrc = fgetcsv($handle)) !== false){
6            $num = count($dataSrc);
7            for ($c=0; $c < $num; $c++){//列 column
8                 if($row === 1){//第一行作为字段
9                        $dataName[] = $dataSrc[$c];//字段名称
10             }else{
11                foreach($dataName as $k=-->$v){
12                    if($k == $c){//对应的字段
13                            $data[$v] = $dataSrc[$c];
14                     }
15                }
16                }
17            }
18            if(!empty($data)){
19                 $dataRtn[] = $data;
20                 unset($data);
21            }
22            $row++;
23        }
24        fclose($handle);
25        return $dataRtn;
26    }
27}
28 
29$aData = getCSVdata('test.csv');
30var_dump($aData);

CSV文件内容:

得到的结果是:

1array
20 =>
3array
4'detail' => string 'a1' (length=2)
5'nickname' => string 'b1' (length=2)
6'title' => string 'c1' (length=2)
7 1 =>
8array
9'detail' => string 'a2' (length=2)
10'nickname' => string 'b2' (length=2)
11'title' => string 'c2' (length=2)
122 =>
13array
14'detail' => string 'a3' (length=2)
15'nickname' => string 'b3' (length=2)
16'title' => string 'c3' (length=2)