用php导入导出csv文件-php教程-PHP中文网

用php导入导出csv文件

php中文网

发布： 2016-07-29 09:12:28

原创

1265人浏览过

用php导入导出csv文件

最近在做一些模块的时候，频繁导入导出csv文件，与excel相比他的处理更简单，文件体积更小，数据处理量大，而且很多语言都支持。

废话不多，上代码~

导入代码：

<code><span><<span>meta</span><span>charset</span> = "<span>utf-8</span>"></span><span><<span>form</span><span>method</span> = "<span>post</span>" <span>enctype</span> = "<span>multipart</span>/<span>form-data</span>" ></span><span><<span>h3</span>></span><strong>上传文件</strong><span></<span>h3</span>></span><span><<span>input</span><span>type</span> = "<span>file</span>" <span>name</span> = "<span>file</span>"></span><span><<span>button</span><span>type</span> = "<span>submit</span>" ></span>提交<span></<span>button</span>></span><span></<span>form</span>></span><span><span><?php</span><span>$csv</span> = <span>$_FILES</span>[<span>'file'</span>];

    <span>$suffix</span> = array_pop(explode(<span>'.'</span>, <span>$csv</span>[<span>'name'</span>]));

    <span>//检查是否是csv文件</span><span>if</span>(<span>$suffix</span> <> <span>'csv'</span>)
        <span>exit</span>(<span>'请上传csv文件'</span>);

    <span>$file</span> = fopen(<span>$csv</span>[<span>'tmp_name'</span>], <span>'r'</span>);

    <span>$lines</span> = <span>array</span>();

    <span>while</span>(<span>$data</span>  = fgetcsv(<span>$file</span>))
        <span>$lines</span>[] = <span>$data</span>;

    <span>echo</span><span>'<pre class="brush:php;toolbar:false;">'</span>;
    print_r(<span>$lines</span>);
<span>?></span></span></code>

登录后复制

导出代码：

立即学习“PHP免费学习笔记（深入）”；

白果AI论文

论文AI生成学术工具，真实文献，免费不限次生成论文大纲 10 秒生成逻辑框架，10 分钟产出初稿，智能适配 80+学科。支持嵌入图表公式与合规文献引用

查看详情

<code><span><<span>meta</span><span>charset</span> = "<span>utf-8</span>" /></span><span><<span>a</span><span>href</span> = "?<span>test</span>"></span>点我下载CSV文件<span></<span>a</span>></span><span><span><?php</span><span>if</span>(<span>isset</span>(<span>$_REQUEST</span>[<span>'test'</span>])){
    ob_end_clean();
    ob_start();

    <span>//第一行题头</span><span>echo</span><span>"题头1,题头2,题头3,题头4\n"</span>;
    <span>//第一行数值</span><span>echo</span><span>"数值1,数值2,数值3,数值4\n"</span>;

    <span>$content</span> = ob_get_contents();

    ob_end_clean();

    header(<span>'Content-Type: text/html;charset=gb2312'</span>);
    header(<span>'Content-Type: application/force-download'</span>);
    header(<span>'Content-Disposition: attachment; filename=test.csv'</span>);

    <span>echo</span> iconv(<span>'utf-8'</span>, <span>'gb2312'</span>, <span>$content</span>);
}
<span>?></span></span></code>

登录后复制

测试链接

上传功能测试链接

下载功能测试链接

以上~如果有不明白，可以留言

').addClass('pre-numbering').hide(); $(this).addClass('has-numbering').parent().append($numbering); for (i = 1; i ').text(i)); }; $numbering.fadeIn(1700); }); });

以上就介绍了用php导入导出csv文件，包括了上传文件,导入导出方面的内容，希望对PHP教程有兴趣的朋友有所帮助。