php 之 csv 导出

public function OrderExports($fileName, $headArr, $data)
{
    set_time_limit(0);
    // 输出Excel文件头，可把user.csv换成你要的文件名
    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment;filename=' . $fileName . '.csv');
    header('Cache-Control: max-age=0');

    // 打开PHP文件句柄，php://output 表示直接输出到浏览器
    $fp = fopen('php://output', 'a');

    // 输出Excel列名信息
    foreach ($headArr as $i => $v) {
        // CSV的Excel支持GBK编码，一定要转换，否则乱码
        $headArr[$i] = iconv('utf-8', 'gb2312', $v);
    }
    // 将数据通过fputcsv写到文件句柄
    fputcsv($fp, $headArr);

    $string = '';

    foreach ($data as $key => $value) {
        foreach ($value as $k => $val) {
            if (strlen($val) == 11) {
                $value[$k] = iconv('utf-8', 'gb2312', '\'' . $value[$k]);
            } elseif (stripos($val, '-') == true) {
                $value[$k] = iconv('utf-8', 'gb2312', ' ' . $value[$k]);
            } else {
                $value[$k] = iconv('utf-8', 'gb2312', $value[$k]);
            }

        }

        $string .= implode(",", $value) . "\n"; //用英文逗号分开
    }

    echo $string;

}