导出csv文件

最新推荐文章于 2024-04-26 12:04:39 发布

大洋PHP

最新推荐文章于 2024-04-26 12:04:39 发布

阅读量479

点赞数

分类专栏： PHP 表格处理

本文链接：https://blog.csdn.net/eddy23513/article/details/86648906

版权

PHP 同时被 2 个专栏收录

103 篇文章 1 订阅

订阅专栏

表格处理

3 篇文章 0 订阅

订阅专栏

public function putHeaderCsv($csvFileName, $dataArr ,$headerText = []){
        $csv_data = '';

        foreach ($headerText as $key => $value) {
            $csv_data .= $headerText[$key].',';
        }
        $csv_data .= PHP_EOL;


        foreach ($dataArr as $key => $value) {
            foreach ($value as $k => $v) {
                $csv_data .= $value[$k].',';
            }
            $csv_data .= PHP_EOL;
        }

        $csv_data = helper::convertEncoding($csv_data, 'utf-8', 'utf-8//TRANSLIT');
        $this->sendDownHeader($csvFileName, 'csv', $csv_data);
    }

public function sendDownHeader($fileName, $fileType, $content)
    {
        /* Clean the ob content to make sure no space or utf-8 bom output. */
        $obLevel = ob_get_level();
        for($i = 0; $i < $obLevel; $i++) ob_end_clean();

        /* Set the downloading cookie, thus the export form page can use it to judge whether to close the window or not. */
        setcookie('downloading', 1);

        /* Append the extension name auto. */
        $extension = '.' . $fileType;
        if(strpos($fileName, $extension) === false) $fileName .= $extension;

        /* urlencode the filename for ie. */
        if(strpos($this->server->http_user_agent, 'MSIE') !== false or strpos($this->server->http_user_agent, 'Trident') !== false) $fileName = urlencode($fileName);

        /* Judge the content type. */
        $mimes = $this->config->file->mimes;
        $contentType = isset($mimes[$fileType]) ? $mimes[$fileType] : $mimes['default'];

        header("Content-type: $contentType");
        header("Content-Disposition: attachment; filename=\"$fileName\"");
        header("Pragma: no-cache");
        header("Expires: 0");
        die($content);
    }