PHP实例：用PHP将mysql数据表转换为excel文件格式

2024-07-24 12:43:10

字体：大中小

来源：转载

供稿：网友

DB_Server = "localhost";
DB_Username = "mydowns";
DB_Password = "";
DB_DBName = "mydowns";
DB_TBLName = "user";
Connect = @mysql_connect(DB_Server, DB_Username, DB_Password)
or die("Couldn't connect.");
Db = @mysql_select_db(DB_DBName, Connect)
or die("Couldn't select database.");
file_type = "vnd.ms-excel";
file_ending = "xls";
header("Content-Type: application/file_type");
header("Content-Disposition: attachment; filename=mydowns.file_ending");
header("Pragma: no-cache");
header("Expires: 0");
now_date = date('Y-m-d H:i');
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{
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技巧：用PHP导出MySQL数据库内容为.sql文件

下一篇：php+mysql实现无限级分类