php中将数据库的内容导出到excel
发布:smiling 来源: PHP粉丝网 添加日期:2014-09-10 11:09:06 浏览: 评论:0
把mysql数据库中的内容导出到excel我们只要利用header输出csv格式文档就可以简单实现mysql导出excel文件了,下面我们一起来看个实例.
核心代码就是这里了,代码如下:
- header("Content-Type: application/vnd.ms-excel; charset=UTF-8");
- header("Pragma: public");
- header("Expires: 0");
- header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
- header("Content-Type: application/force-download");
- header("Content-Type: application/octet-stream");
- header("Content-Type: application/download");
- header("Content-Disposition: attachment;filename=".$title .".xls ");
- header("Content-Transfer-Encoding: binary ");
以下是用php将数据库导出成excel,测试完全成功,代码如下:
- <?php
- $DB_Server = "localhost";
- $DB_Username = "root";
- $DB_Password = www.phpfensi.com;
- $DB_DBName = "ishop";
- $DB_TBLName = "oi_mall_payment";
- $savename = date("YmjHis");
- $Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die("Couldn't connect.");
- mysql_query("Set Names 'gbk'");
- $file_type = "vnd.ms-excel";
- $file_ending = "xls";
- header("Content-Type: application/$file_type;charset=big5");
- header("Content-Disposition: attachment; filename=".$savename.".$file_ending");
- //header("Pragma: no-cache");
- $now_date = date("Y-m-j H:i:s");
- $title = "数据库名:$DB_DBName,数据表:$DB_TBLName,备份日期:$now_date";
- $sql = "Select * from $DB_TBLName";
- $ALT_Db = @mysql_select_db($DB_DBName, $Connect) or die("Couldn't select database");
- $result = @mysql_query($sql,$Connect) or die(mysql_error());
- echo("$titlen");
- $sep = "t";
- for ($i = 0; $i < mysql_num_fields($result); $i++) {
- echo mysql_field_name($result,$i) . "t";
- }
- print("n");
- $i = 0;
- while($row = mysql_fetch_row($result)) {
- $schema_insert = "";
- for($j=0; $j<mysql_num_fields($result);$j++) {
- if(!isset($row[$j]))
- $schema_insert .= "NULL".$sep;
- elseif ($row[$j] != "")
- $schema_insert .= "$row[$j]".$sep;
- else //开源代码phpfensi.com
- $schema_insert .= "".$sep;
- }
- $schema_insert = str_replace($sep."$", "", $schema_insert);
- $schema_insert .= "t";
- print(trim($schema_insert));
- print "n";
- $i++;
- }
- return (true);
- ?>
Tags: php内容导出 php导出excel
相关文章
- ·PHP中利用PHPExcel导出Excel示例(2014-08-27)
- ·php 中mysql导出excel文件方法(2014-08-29)
- ·php怎么把数据表中的数据导出到excel表中(2014-09-10)
- ·PHP将mysql数据库导出为excel表(2014-09-10)
- ·php 导出excel数据实例代码(2014-09-10)
- ·php导出mysql数据库中为excel代码(2014-09-11)
- ·php导出word文档与excel电子表格的简单示例代码(2020-10-20)
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)