Export data from php to an EXCEL table in windows & lt ;? Php & nbsp; date_default_timezone_set (PRC); & nbsp; set time & nbsp; $ DB_Server & quot; localhost & quot; & nbsp; export data from php to an EXCEL table in windows
Date_default_timezone_set ('prc'); // Set the time
$ DB_Server = "localhost ";
$ DB_Username = "root ";
$ DB_Password = "123 ";
$ DB_DBName = "user ";
$ DB_TBLName = $ _ REQUEST ['tbname'];
$ 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 = utf-8 ");
Header ("Content-Disposition: attachment; filename =". $ DB_TBLName. $ savename. ". $ file_ending ");
// Header ("Pragma: no-cache ");
// Iconv ("UTF-8", "gb2312", "data". $ DB_TBLName. $ savename );
$ Now_date = date ("Y-m-j H: I: s ");
$ Title = "database name \ t $ DB_DBName \ t data table \ t $ DB_TBLName \ t backup date \ t $ 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 iconv ("UTF-8", "gb2312", "$ 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;
Else if ($ row [$ j]! = "")
$ Schema_insert. = "$ row [$ j]". $ sep;
Else
$ Schema_insert. = "". $ sep;
}
// $ Schema_insert = str_replace ($ sep. "$", $ schema_insert );
$ Schema_insert. = "\ t ";
Echo iconv ("UTF-8", "gb2312", $ schema_insert );
// Print (trim ($ schema_insert ));
Print "\ n ";
// $ I ++;
}
Return (true );
?>