<?php
ob_start();
session_start();
require_once('./include/fun.inc.php');
$FileName = date("Ymdhis");if( !isset($_SESSION['CrossmoAdmin']['adminName']) || empty($_SESSION['CrossmoAdmin']['adminName']))
LocateURL("admincp.php");iconv("utf-8", "gb2312", $FileName);
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=$FileName.xls");$sql = "select t_admin_user.username as admin_name,
t_olebar_user.userid,
t_olebar_user.username,
t_olebar_user.lasttimestamp,
t_olebar_user.logontimes
from t_admin_user,
t_olebar_user
where t_admin_user.userid = t_olebar_user.cid
and cid > 0
order by t_admin_user.username";$table = '店员帐号明细表';
echo $table."\n\n";
//输出内容如下:
echo "用户ID"."\t";
echo "用户名"."\t";
echo "用户分公司"."\t";
echo "登陆次数"."\t";
echo "最近登陆时间"."\t";
$pq = new PageQuery();
$result = $pq->conn->GetArray($sql);
$i = 0;
foreach($result as $value)
{
$result[$i] = $value;
echo $result[$i]["userid"]."\t";
echo $result[$i]["username"]."\t";
echo $result[$i]["admin_name"]."\t";
echo $result[$i]["logontimes"]."\t";
echo $result[$i]["lasttimestamp"]."\t";
$i++;
}
?>
为什么打开文件时说我没有加载完成?
ob_start();
session_start();
require_once('./include/fun.inc.php');
$FileName = date("Ymdhis");if( !isset($_SESSION['CrossmoAdmin']['adminName']) || empty($_SESSION['CrossmoAdmin']['adminName']))
LocateURL("admincp.php");iconv("utf-8", "gb2312", $FileName);
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=$FileName.xls");$sql = "select t_admin_user.username as admin_name,
t_olebar_user.userid,
t_olebar_user.username,
t_olebar_user.lasttimestamp,
t_olebar_user.logontimes
from t_admin_user,
t_olebar_user
where t_admin_user.userid = t_olebar_user.cid
and cid > 0
order by t_admin_user.username";$table = '店员帐号明细表';
echo $table."\n\n";
//输出内容如下:
echo "用户ID"."\t";
echo "用户名"."\t";
echo "用户分公司"."\t";
echo "登陆次数"."\t";
echo "最近登陆时间"."\t";
$pq = new PageQuery();
$result = $pq->conn->GetArray($sql);
$i = 0;
foreach($result as $value)
{
$result[$i] = $value;
echo $result[$i]["userid"]."\t";
echo $result[$i]["username"]."\t";
echo $result[$i]["admin_name"]."\t";
echo $result[$i]["logontimes"]."\t";
echo $result[$i]["lasttimestamp"]."\t";
$i++;
}
?>
为什么打开文件时说我没有加载完成?
ps:我怎么记得是逗号来分隔表格的?
试试看
header("Content-type:application/vnd.ms-excel;charset=gb2312");
header("Content-Type:text/html;charset=gb2312")