PHP mysql列表在线导出excel文件

最新推荐文章于 2021-08-14 18:05:57 发布

Young-杨

最新推荐文章于 2021-08-14 18:05:57 发布

阅读量586

点赞数 1

分类专栏：从入门到放弃文章标签： php 数据库 excel 数据导出

本文链接：https://blog.csdn.net/vailook/article/details/53260083

版权

从入门到放弃专栏收录该内容

86 篇文章 1 订阅

订阅专栏

<?php

require_once '../../config.inc.php'; //数据库配置文件

$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");

 // END 配置
 //链接数据库
 $link = mysql_connect($dbhost,$dbuser,$dbpw);
 mysql_select_db($dbname);
 //选择编码
 mysql_query("set names ".$charset);


//我们先在excel输出表头，当然这不是必须的
echo iconv("utf-8", "gb2312", "编号")."\t";
echo iconv("utf-8", "gb2312", "关键词")."\t";
echo iconv("utf-8", "gb2312", "来源")."\t";
echo iconv("utf-8", "gb2312", "添加时间")."\t";
echo iconv("utf-8", "gb2312", "IP地址")."\t";
echo iconv("utf-8", "gb2312", "归属地")."\t";
echo iconv("utf-8", "gb2312", "客户端")."\n";
//输出表中记录

$btime = $_POST['btime'];
$etime = $_POST['etime'];
if(!empty($btime) && !empty($etime)){

    $b_time = strtotime($btime);
    $e_time = strtotime($etime);    
    $where = " where addtime between $b_time and $e_time ";
}else{
    $where = '';
}

$query=mysql_query("SELECT * FROM `chat_talk` ".$where." order by `tid` desc");
if($query){
    while($row=mysql_fetch_array($query)){
        echo iconv("utf-8", "gb2312", $row['tid'])."\t";
        echo iconv("utf-8", "gb2312", $row['keyword'])."\t";
        echo iconv("utf-8", "gb2312", $sorce)."\t";
        echo iconv("utf-8", "gb2312", date('Y-m-d H:i:s', $row['addtime']))."\t";
        echo iconv("utf-8", "gb2312", $row['ip'])."\t";
        echo iconv("utf-8", "gb2312", $row['area'])."\t";
        echo iconv("utf-8", "gb2312", $row['display'])."\n";
        }
    }



?>