PHP backup database Generate SQL file and download the function code _php tutorial

Copy CodeThe code is as follows:
/****** backing up the database structure ******/
/*
Function name: Table2sql ()
function function: Convert the structure of a table into SQL
Function parameters: $table: The name of the table to extract
Return value: Returns the extracted result, SQL collection
Function Author: heiyeluren
*/
function Table2sql ($table)
{
Global $db;
$tabledump = "DROP TABLE IF EXISTS $table; n";
$createtable = $db--->query ("SHOW CREATE TABLE $table");
$create = $db->fetch_row ($createtable);
$tabledump. = $create [1]. "; nn ";
return $tabledump;
}
/****** backing up the database structure and all data ******/
/*
Function name: Data2sql ()
function function: Convert the structure and data of a table into SQL
Function parameters: $table: The name of the table to extract
Return value: Returns the extracted result, SQL collection
Function Author: heiyeluren
*/
function Data2sql ($table)
{
Global $db;
$tabledump = "DROP TABLE IF EXISTS $table; n";
$createtable = $db->query ("SHOW CREATE TABLE $table");
$create = $db->fetch_row ($createtable);
$tabledump. = $create [1]. "; nn ";
$rows = $db->query ("SELECT * from $table");
$numfields = $db->num_fields ($rows);
$numrows = $db->num_rows ($rows);
while ($row = $db->fetch_row ($rows))
{
$comma = "";
$tabledump. = "INSERT into $table VALUES (";
for ($i = 0; $i < $numfields; $i + +)
{
$tabledump. = $comma. "'". Mysql_escape_string ($row [$i]). "'";
$comma = ",";
}
$tabledump. = "); n";
}
$tabledump. = "n";
return $tabledump;
}
?>