php导出CSV文件的简单示例

3. /**

4. * 导出csv文件，header函数示例
5. * edit: bbs.it-home.org
6. */
7. header( "Cache-Control: public" );
8. header( "Pragma: public" );
9. header("Content-type:application/vnd.ms-excel");
10. header("Content-Disposition:attachment;filename=txxx.csv");
11. header('Content-Type:APPLICATION/OCTET-STREAM');

12. ob_start();

13. $header_str = iconv("utf-8",'gbk',"信息id,标题,名称,电话,QQ,Email,内容,时间\n");
14. $file_str="";
16. $mysqli= new mysqli('localhost','root','','test');

17. if (mysqli_connect_errno()) {

18. printf("Connect failed: %s\n", mysqli_connect_error());
19. exit();
20. }
21. $sql='select * from messages';
22. $mysqli->query("set names utf8 ;");
23. $result=$mysqli->query($sql);

24. if($result){

25. while ($row = mysqli_fetch_assoc($result)){
26. $file_str.= $row['id'].','.$row['title'].','.$row['name'].','."'{$row['telephone']}'".','.$row['qq'].','.$row['email'].','.str_ireplace(',','，',$row['content']).','.$row['retime']."\n";
27. }
28. }else{
29. echo "nonono!!!";
30. }
31. $file_str= iconv("utf-8",'gbk',$file_str);
32. ob_end_clean();
33. echo $header_str;
34. echo $file_str;
35. ?>

复制代码