php导出excel。。麻烦高手。。
时间:2010-08-11
来源:互联网
嘿嘿。。谁能帮我这个菜鸟写下代码。。
实现将从数据库查询数据,然后将在PHP页面中导出excel!!
方法简单就可以了。。。感激不尽。。谢谢啦!不知道下面那段代码可以不!下面那代码浏览就显示那张图那样。。。是window2003的系统!
Header("Content-type: application/octet-stream");
Header("Accept-Ranges: bytes");
Header("Content-type:application/vnd.ms-excel");
Header("Content-Disposition:attachment;filename=export_excel_gshjsl.xls");
$db = new DataAccess();
$db->connect();
$sql="select * FROM bx_add ";
$result = $db-> query($sql);
$row =mysql_fetch_array($result,MYSQL_ASSOC);
echo "序号"."\t";
echo "姓名"."\t";
echo "宿舍"."\t";
echo "学号"."\t";
echo "系别"."\t";
echo "班级"."\t";
echo "联系方式"."\t";
echo "报修时间"."\t";
echo "故障类型"."\t";
echo "故障描述"."\t";
echo "处理情况"."\t";
echo "维修队员"."\t";
echo "协助队员"."\t";
echo "队员反馈"."\t";
echo "用户评价"."\t";
echo "\n";
while($row =mysql_fetch_array($result,MYSQL_ASSOC))
{
echo $row['id']."\t";
echo $row['name']."\t";
echo $row['address']."\t";
echo $row['card_number']."\t";
echo $row['grade']."\t";
echo $row['class']."\t";
echo $row['phone']."\t";
echo $row['bx_time']."\t";
echo $row['main_problem']."\t";
echo $row['detail_problem']."\t";
echo $row['bx_situation']."\t";
echo $row['deal_person']."\t";
echo $row['xiezhu_person']."\t";
echo $row['duiyuan_fankui']."\t";
echo $row['pingjia']."\t";
}
实现将从数据库查询数据,然后将在PHP页面中导出excel!!
方法简单就可以了。。。感激不尽。。谢谢啦!不知道下面那段代码可以不!下面那代码浏览就显示那张图那样。。。是window2003的系统!
Header("Content-type: application/octet-stream");
Header("Accept-Ranges: bytes");
Header("Content-type:application/vnd.ms-excel");
Header("Content-Disposition:attachment;filename=export_excel_gshjsl.xls");
$db = new DataAccess();
$db->connect();
$sql="select * FROM bx_add ";
$result = $db-> query($sql);
$row =mysql_fetch_array($result,MYSQL_ASSOC);
echo "序号"."\t";
echo "姓名"."\t";
echo "宿舍"."\t";
echo "学号"."\t";
echo "系别"."\t";
echo "班级"."\t";
echo "联系方式"."\t";
echo "报修时间"."\t";
echo "故障类型"."\t";
echo "故障描述"."\t";
echo "处理情况"."\t";
echo "维修队员"."\t";
echo "协助队员"."\t";
echo "队员反馈"."\t";
echo "用户评价"."\t";
echo "\n";
while($row =mysql_fetch_array($result,MYSQL_ASSOC))
{
echo $row['id']."\t";
echo $row['name']."\t";
echo $row['address']."\t";
echo $row['card_number']."\t";
echo $row['grade']."\t";
echo $row['class']."\t";
echo $row['phone']."\t";
echo $row['bx_time']."\t";
echo $row['main_problem']."\t";
echo $row['detail_problem']."\t";
echo $row['bx_situation']."\t";
echo $row['deal_person']."\t";
echo $row['xiezhu_person']."\t";
echo $row['duiyuan_fankui']."\t";
echo $row['pingjia']."\t";
}
图片:额.jpg
'700')this.width='700';if(this.offsetHeight>'700')this.height='700';" title="Click Here To EnLarge">
'700')this.width='700';if(this.offsetHeight>'700')this.height='700';" title="Click Here To EnLarge">
作者: 不想太多 发布时间: 2010-08-11
看看四十七讲
作者: liaoyanjian 发布时间: 2010-08-11
能不能帮个忙帮我做个。我急用!!
作者: 不想太多 发布时间: 2010-08-11
期待ing
作者: zixing1020 发布时间: 2010-08-15
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28