php导出数据为CSV文件DEMO
发布时间:2020-05-25 03:33:24 所属栏目:PHP 来源:互联网
导读:代码示例:private function _download_send_headers($filename) {// disable caching$now = gmdate(D, d M Y H:i:s);header(Expires: Tue, 03 Jul 2001 06:00:00 GMT);header(Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate);heade
|
代码示例: _download_send_headers( = ("D,d M Y H:i:s"("Expires: Tue,03 Jul 2001 06:00:00 GMT"("Cache-Control: max-age=0,no-cache,must-revalidate,proxy-revalidate"("Last-Modified: {} GMT" </span><span style="color: #008000;">//</span><span style="color: #008000;"> force download</span>
<span style="color: #008080;">header</span>("Content-Type: application/force-download"<span style="color: #000000;">);
</span><span style="color: #008080;">header</span>("Content-Type: application/octet-stream"<span style="color: #000000;">);
</span><span style="color: #008080;">header</span>("Content-Type: application/download"<span style="color: #000000;">);
</span><span style="color: #008000;">//</span><span style="color: #008000;"> disposition / encoding on response body</span>
<span style="color: #008080;">header</span>("Content-Disposition: attachment;filename={<span style="color: #800080;">$filename</span>}"<span style="color: #000000;">);
</span><span style="color: #008080;">header</span>("Content-Transfer-Encoding: binary"<span style="color: #000000;">);
}
</span><span style="color: #0000ff;">private</span> <span style="color: #0000ff;">function</span> _array2csv(<span style="color: #800080;">$array</span><span style="color: #000000;">) {
</span><span style="color: #0000ff;">if</span> (<span style="color: #008080;">count</span>(<span style="color: #800080;">$array</span>) == 0<span style="color: #000000;">) {
</span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">null</span><span style="color: #000000;">;
}
</span><span style="color: #800080;">$keys</span> = <span style="color: #008080;">array_keys</span>(<span style="color: #008080;">reset</span>(<span style="color: #800080;">$array</span><span style="color: #000000;">));
</span><span style="color: #0000ff;">echo</span> <span style="color: #008080;">implode</span>(',',<span style="color: #800080;">$keys</span>) . <span style="color: #ff00ff;">PHP_EOL</span><span style="color: #000000;">;
</span><span style="color: #0000ff;">for</span> (<span style="color: #800080;">$i</span> = 0,<span style="color: #800080;">$j</span> = <span style="color: #008080;">count</span>(<span style="color: #800080;">$array</span>); <span style="color: #800080;">$i</span> < <span style="color: #800080;">$j</span>; <span style="color: #800080;">$i</span>++<span style="color: #000000;">) {
</span><span style="color: #0000ff;">echo</span> <span style="color: #008080;">implode</span>(',<span style="color: #800080;">$array</span>[<span style="color: #800080;">$i</span>]) . <span style="color: #ff00ff;">PHP_EOL</span><span style="color: #000000;">;
}
}
</span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">function</span><span style="color: #000000;"> saveAsCsv() {
</span><span style="color: #800080;">$this</span> -> _download_send_headers("data_export_" . <span style="color: #008080;">date</span>("Y-m-d") . ".csv"<span style="color: #000000;">);
</span><span style="color: #800080;">$ret</span> = <span style="color: #0000ff;">array</span><span style="color: #000000;">(
</span><span style="color: #0000ff;">array</span><span style="color: #000000;">(
</span>'id' => 1,'name' => 'hello'<span style="color: #000000;">
)</span>,<span style="color: #0000ff;">array</span><span style="color: #000000;">(
</span>'id' => 2,'name' => 'world'<span style="color: #000000;">
)</span>,<span style="color: #0000ff;">array</span><span style="color: #000000;">(
</span>'id' => 3,'name' => 'good'<span style="color: #000000;">
)</span>,<span style="color: #000000;">
);
</span><span style="color: #800080;">$this</span> -> _array2csv(<span style="color: #800080;">$ret</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">die</span><span style="color: #000000;">();
}</span></pre>
当然还有用 (编辑:安卓应用网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
