PHP 把数据库导成excel表

php 

$db_server = "localhost"; 

$DB_Username = "root"; 

$DB_Password = "123456"; 

$DB_DBName = "oa"; 

$DB_TBLName = "oa_form_table";

立即学习“PHP免费学习笔记（深入）”；

$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

echo mysql_field_name($result,$i) . "\t"; 

酷表ChatExcel

北大团队开发的通过聊天来操作Excel表格的AI工具

48

查看详情

} 

print("\n"); 

$i = 0; 

while($row = mysql_fetch_row($result)) { 

$schema_insert = ""; 

for($j=0; $j

if(!isset($row[$j]))    www.2cto.com

$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); 

?>