php导出excel电子表格,php导出数据到excel表格

$filename=date("Y-m-d H:i:s").".xls";//先定义一个excel文件

header("Content-Type: application/vnd.ms-execl");

header("Content-Type: application/vnd.ms-excel; charset=utf-8");

header("Content-Disposition: attachment; filename=$filename");

header("Pragma: no-cache");

header("Expires: 0");

//我们先在excel输出表头，当然这不是必须的

echo iconv("utf-8", "gb2312", "访问时间")."\t";

echo iconv("utf-8", "gb2312", "IP")."\t";

echo iconv("utf-8", "gb2312", "来源地区")."\t";

echo iconv("utf-8", "gb2312", "来路")."\t";

echo iconv("utf-8", "gb2312", "关键词")."\t";

echo iconv("utf-8", "gb2312", "受访页面")."\n";

//输出表中记录

$query=mysql_query("SELECT * FROM `logs` order by `id` desc");

if($query){

while($row=mysql_fetch_array($query)){

echo iconv("utf-8", "gb2312", $fw_time)."\t";

echo iconv("utf-8", "gb2312", $row['ip'])."\t";

echo iconv("utf-8", "gb2312", $row['ip_city'])."\t";

echo iconv("utf-8", "gb2312", $row['lailu'])."\t";

echo iconv("utf-8", "gb2312", $row['word'])."\t";

echo iconv("utf-8", "gb2312", $row['page'])."\n";

}

}