? Php $ DB_Serverlocalhost; $ DB_Usernamemydowns; $ DB_Password; $ response; $ DB_TBLNameuser; $ Connect @ mysql_connect ($ DB_Server, $ DB_Username, $ DB_Password) ordie (Couldntconnect .); $ Db @ mysql_select_db ($ DB_DBName, $ Connect) Excel
$ 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 ("$ titlen ");
$ 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 );
?>