php教程|php手册
php导出excel,php内容导出
php教程-php手册
把mysql数据库中的内容导出到excel我们只要利用header输出csv格式文档就可以简单实现mysql导出excel文件了,下面我们一起来看个实例.
微信小程序源码是什么,vscode怎么在工作区,提高ubuntu性能,tomcat 在64位,爬虫加cookie,php源码本地测试,河北seo优化供应商,html5网站怎么下载源码,dedecms 图片 模板免费下载lzw
核心代码就是这里了,代码如下:
qt linux 源码,ubuntu如何下载电影,网页爬虫怎么编写,php login.php,保定seo标准lzw
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,测试完全成功,代码如下:
500彩票的源码,ubuntu 卷boot,52是tomcat什么版本,爬虫的理解,walle php,嘉兴seo搜索引擎优化排名lzw
<?php$DB_Server = "localhost"; $DB_Username = "root"; $DB_Password = \; $DB_DBName = "ishop"; $DB_TBLName = "oi_mall_payment"; $savename = date("YmjHis"); $Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die("Couldn 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 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 $schema_insert .= "".$sep; } $schema_insert = str_replace($sep."$", "", $schema_insert); $schema_insert .= "t"; print(trim($schema_insert)); print "n"; $i++; } return (true);
本文地址：
转载随意，但请附上文章地址:-)
