php导出exel

php导出exel，网上看到的，分享下。
 <?php
   $DB_Server = "localhost";
    $DB_Username = "root";
    $DB_Password = "123456";
 
    $DB_DBName = "oa";
   $DB_TBLName = "oa_form_table";
   $savename = date("YmjHis");
   $Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die("Couldn't connect.");
   mysql_query("Set Names 'utf8'");
   $file_type = "vnd.ms-excel";
   $file_ending = "xls";
   header("Content-Type: application/$file_type;charset=utf8");
   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("$title\n");
   $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);
   ?>

转载请注明出处：魏业英技术博客 » php导出exel