PHP（Thinkphp框架）将数据表导出csv文件

最新推荐文章于 2023-03-29 18:18:41 发布

Alex-Leung

最新推荐文章于 2023-03-29 18:18:41 发布

阅读量3.3k

点赞数

分类专栏： PHP 文章标签： thinkphp php

本文链接：https://blog.csdn.net/a2824256/article/details/53897844

版权

PHP 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

CSV文件类似于excel文件，用逗号表示分隔符,换行符代表该行结束

访问方法

public function export_csv()
    {
        $csvModel = M('select_question');
        $csvData = $csvModel->field('question,answer_A,answer_B,answer_C,answer_D,true_answer')->select();
        $str = "题目,答案A,答案B,答案C,答案D,正确答案\n";
        $str = iconv('utf-8', 'gb2312', $str);
        foreach ($csvData as $item) {
            $question = iconv('utf-8', 'gb2312', $item['question']);
            $a = iconv('utf-8', 'gb2312', $item['answer_a']);
            $b = iconv('utf-8', 'gb2312', $item['answer_b']);
            $c = iconv('utf-8', 'gb2312', $item['answer_c']);
            $d = iconv('utf-8', 'gb2312', $item['answer_d']);
            $t = iconv('utf-8', 'gb2312', $item['true_answer']);
            $str .= $question . "," . $a . "," . $b . "," . $c . "," . $d . "," . $t . "\n";
        }
        $filename = '选择题.csv';
        $this->export_filename($filename, $str);
    }

请求头导出方法

public function export_filename($filename,$data)
    {
        header("Content-type:text/csv");
        header("Content-Disposition:attachment;filename=" . $filename);
        header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
        header('Expires:0');
        header('Pragma:public');
        echo $data;
    }