PHP開啟CSV文件

PHP打开CSV文件

//设置UTF-8编码
setlocale(LC_ALL, 'en_US.UTF-8');
//csv路径
$csv_file = "csv/excel.csv";
//以只读方式打开文件
$handle = fopen($csv_file, "r");
//定义结果数组
$listarr = array();
//打开csv中一行,并用","分割为数组
while($data = fgetcsv($handle, 1000, ",")){
	$num = count($data);
	for($i=0; $i<$num; $i++){
		$data[$i] = mb_convert_encoding($data[$i],"UTF-8","UTF-8");
	}
	$listarr[] = $data;
}

return $listarr;