php导出CSV文件

来源：互联网发布：mac选股好帮手编辑：程序博客网时间：2024/05/13 05:10

1.php导出CSV文件

<?php

header( "Cache-Control: public" );

header( "Pragma: public" );

header("Content-type:application/vnd.ms-excel");

header("Content-Disposition:attachment;filename=txxx.csv");

header('Content-Type:APPLICATION/OCTET-STREAM');

ob_start();

$header_str = iconv("utf-8",'gbk',"信息id,标题,名称,电话,QQ,Email,内容,时间\n");

$file_str="";

$mysqli= new mysqli('localhost','root','','test');

if (mysqli_connect_errno()) {

printf("Connect failed: %s\n", mysqli_connect_error());

exit();

}

$sql='select * from messages';

$mysqli->query("set names utf8 ;");

$result=$mysqli->query($sql);

if($result){

while ($row = mysqli_fetch_assoc($result)){

$file_str.= $row['id'].','.$row['title'].','.$row['name'].','."'{$row['telephone']}'".','.$row['qq'].','.$row['email'].','.str_ireplace(',','，',$row['content']).','.$row['retime']."\n";

}

}else{

echo "nonono!!!";

}

$file_str= iconv("utf-8",'gbk',$file_str);

ob_end_clean();

echo $header_str;

echo $file_str;