php中将数据库的内容导出到excel
把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 = HdhCmsTestphpfensi测试数据; $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测试数据 $schema_insert .= "" . $sep ; } $schema_insert = str_replace ( $sep . "$" , "" , $schema_insert ); $schema_insert .= "t" ; print(trim( $schema_insert )); print "n" ; $i ++; } return (true); ?>查看更多关于php中将数据库的内容导出到excel - php高级应用的详细内容...
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://www.haodehen.cn/did30518