php导出CSV方法 (转)

 

制作网站时，经常会遇到检索数据列表的情况。通常用户希望下载这些列表数据并存储到客户端。当然下载这些数据的时候是需要固定的格式，以便于用Excel等软件阅览。说的简单一些就是CSV/Excel数据导出 。

注意事项：

输出文档的基本格式为：列1，列2，列3，……，列nn

格式化数据的同时要对特殊的字符进行过滤。譬如“,”如果不转换为全角“，”会导致数据格式的混乱。

实现方法：

举例：检索数据库表，将结果保存为字符串，进行格式和特殊字符的过滤后，导出到客户端的CSV文件。 

OrderSearchEdit_saveCSV.php

<span style="COLOR: #000000"><?</span><span style="COLOR: #000000">php
</span><span style="COLOR: #0000ff">include</span><span style="COLOR: #000000">(</span><span style="COLOR: #800080">$_SERVER</span><span style="COLOR: #000000">[</span><span style="COLOR: #000000">''</span><span style="COLOR: #000000">DOCUMENT_ROOT</span><span style="COLOR: #000000">''</span><span style="COLOR: #000000">] </span><span style="COLOR: #000000">.</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">/ftcart/OrderInfoManager.class.php</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">);
</span><span style="COLOR: #0000ff">include</span><span style="COLOR: #000000">(</span><span style="COLOR: #800080">$_SERVER</span><span style="COLOR: #000000">[</span><span style="COLOR: #000000">''</span><span style="COLOR: #000000">DOCUMENT_ROOT</span><span style="COLOR: #000000">''</span><span style="COLOR: #000000">] </span><span style="COLOR: #000000">.</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">/ftcart/CommonUtil.php</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">);
</span><span style="COLOR: #0000ff">include</span><span style="COLOR: #000000">(</span><span style="COLOR: #800080">$_SERVER</span><span style="COLOR: #000000">[</span><span style="COLOR: #000000">''</span><span style="COLOR: #000000">DOCUMENT_ROOT</span><span style="COLOR: #000000">''</span><span style="COLOR: #000000">] </span><span style="COLOR: #000000">.</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">/ftcart/CommonConst.php</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">);
</span><span style="COLOR: #0000ff">include</span><span style="COLOR: #000000">(</span><span style="COLOR: #800080">$_SERVER</span><span style="COLOR: #000000">[</span><span style="COLOR: #000000">''</span><span style="COLOR: #000000">DOCUMENT_ROOT</span><span style="COLOR: #000000">''</span><span style="COLOR: #000000">] </span><span style="COLOR: #000000">.</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">/ftcart/CommonErrorMsg.php</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">);
</span><span style="COLOR: #0000ff">include</span><span style="COLOR: #000000">(</span><span style="COLOR: #800080">$_SERVER</span><span style="COLOR: #000000">[</span><span style="COLOR: #000000">''</span><span style="COLOR: #000000">DOCUMENT_ROOT</span><span style="COLOR: #000000">''</span><span style="COLOR: #000000">] </span><span style="COLOR: #000000">.</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">/webadmin.php</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">);

</span><span style="COLOR: #800080">$searchcase</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #0000ff">new</span><span style="COLOR: #000000"> OrderInfoManager();
</span><span style="COLOR: #800080">$nowTime</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> microtime_float();
</span><span style="COLOR: #800080">$searchcase</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #008080">unserialize</span><span style="COLOR: #000000">(</span><span style="COLOR: #800080">$_SESSION</span><span style="COLOR: #000000">[</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">ORDER_SEARCH_CASE</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">]);
</span><span style="COLOR: #800080">$listcsv</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #800080">$searchcase</span><span style="COLOR: #000000">-></span><span style="COLOR: #000000">doCSV();</span><span style="COLOR: #008000">//</span><span style="COLOR: #008000"> 调用doCSV()方法</span><span style="COLOR: #008000">
</span><span style="COLOR: #800080">$filename</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #800080">$nowTime</span><span style="COLOR: #000000">;
</span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">$filename = str_replace(":","",$nowTime);
//$filename = trim($filename);
//echo $filename;</span><span style="COLOR: #008000">
</span><span style="COLOR: #008080">header</span><span style="COLOR: #000000">(</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">Content-Disposition: attachment; filename=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">.</span><span style="COLOR: #800080">$filename</span><span style="COLOR: #000000">.</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">.csv</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">);
</span><span style="COLOR: #008080">header</span><span style="COLOR: #000000">(</span><span style="COLOR: #000000">''</span><span style="COLOR: #000000">Content-Type:APPLICATION/OCTET-STREAM</span><span style="COLOR: #000000">''</span><span style="COLOR: #000000">);
</span><span style="COLOR: #0000ff">echo</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">注文No.,注文日,氏名,住所,支

您可能感兴趣的文章：
php导出csv时身份证号禁止科学计数
解决php csv文件导入mysql中文乱码
php导入csv文件中文乱码的解决方法
php导出csv格式文件的例子
使用PHP导入与导出CSV文件实例详解
php读取csv文件内容的实例代码
php读取csv、写入csv与导出csv文件
php导出csv文件乱码问题的解决实例
解决php导出csv文件乱码的问题(图文)
php导出与读取csv文件的实现代码