Author: mydowns Source: grasp the time Website: www.85time.com, www.mydowns.com original Post address: www. mydowns. comarticle_show.php? Id32 details :? Php $ DB_Serverlocalhost; $ DB_Usernamemydowns; $ DB_Password; $ DB_DBNamemydowns; $ DB_TB Excel
Author: mydowns Source: grasp the time Website: http://www.85time.com, http://www.mydowns.com
The original post address is as follows:
Http://www.mydowns.com/article_show.php? Id = 32
The details are as follows:
$ 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 = "database name: $ DB_DBName, Data Table: $ DB_TBLName, backup date: $ 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 );
?>
