php 查询二个时间段然后导出excel怎么做,新手 php 查询二个时间段然后导出excel怎么做,附:bmtime > '$time1' and bmtime < '$time2 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 给你个函数$data_array为要导出数据数组$keynames为表头数组$keynames=array("username"=>"用户名","password"=>"密码");function exportExcel($data_array,$keynames,$filename) { //组合表头行,以制表符\t分隔,并转码为gb18030 $title = implode ( "\t", array_values ( $keynames ) ); $title = iconv ( "UTF-8", "GB18030", $title ); $result [] = $title; //组合表体行 foreach ( $data_array as $data ) { //按行组合数据体 $a1 = array (); foreach ( $keynames as $k => $v ) { if ($k == "time") { $data [$k] = date ( "Y-m-d", $data [$k] ); } //utf8转码到gb18030,为了windows正常显示 $a1 [] = iconv ( "UTF-8", "GB18030", preg_replace ( "/[\t]+/", " ", $data [$k] ) ); } //以制表符分隔每列gb2312 $result [] = implode ( "\t", $a1 ); } //为了windows下正常显示,以\r\n为换行符,分隔数据字符串 $result = implode ( "\r\n", $result ); header ( "Content-type: text/html; charset=GB18030" ); header ( "Content-Disposition: attachment; filename=\"" . $filename . ".xls\"" ); exit ( $result ); } $filename为导出excel表名编码可以改成gb2312 web服务器的硬件配置要求 动易转dede php zip扩展问题 服务器用smtp批量发量邮件对服务器有影响吗? 怎么下载别人网站源码 电子商务的商品分类功能如何用PHP实现? 请教一网站镜像解决方案(PHP+MySQL) AJAX没反应 Fckeditor直接输入就不乱码,从word粘贴就乱码,咋整 请教网站镜像的问题!!! ecmall2.2安装成功后报错,高手给看看吧 zencart兰亭模板问题。Warning: Call-time pass-by reference
$data_array为要导出数据数组
$keynames为表头数组
$keynames=array("username"=>"用户名","password"=>"密码");function exportExcel($data_array,$keynames,$filename) {
//组合表头行,以制表符\t分隔,并转码为gb18030
$title = implode ( "\t", array_values ( $keynames ) );
$title = iconv ( "UTF-8", "GB18030", $title );
$result [] = $title;
//组合表体行
foreach ( $data_array as $data ) {
//按行组合数据体
$a1 = array ();
foreach ( $keynames as $k => $v ) {
if ($k == "time") {
$data [$k] = date ( "Y-m-d", $data [$k] );
}
//utf8转码到gb18030,为了windows正常显示
$a1 [] = iconv ( "UTF-8", "GB18030", preg_replace ( "/[\t]+/", " ", $data [$k] ) );
}
//以制表符分隔每列gb2312
$result [] = implode ( "\t", $a1 );
}
//为了windows下正常显示,以\r\n为换行符,分隔数据字符串
$result = implode ( "\r\n", $result );
header ( "Content-type: text/html; charset=GB18030" );
header ( "Content-Disposition: attachment; filename=\"" . $filename . ".xls\"" );
exit ( $result );
}
编码可以改成gb2312