PHP backup database is SQL file and can download source code

This is a copy of all the tables in the specified database to a SQL file and can be downloaded. The source code from the DEDECMS program, the function is quite many, also very practical, but the quality of codes still need to improve

 
 

  
  

  
<!? Php
  
  

  

  
  

  
/****** BACKUP DATABASE Structure ******/
  
  

  

  
  

  
/*
  
  

  
Function name: Table2sql ()
  
  

  
function function: Transform the structure of a table into SQL
  
  

  
Function parameters: $table: Table name to be extracted
  
  

  
Return value: Returns the result after extraction, 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]. "; N\n ";
  
  

  
return $tabledump;
  
  

  
}
  
  

  

  
  

  

  
  

  
/****** backup database structure and all data ******/
  
  

  
/*
  
  

  
Function name: Data2sql ()
  
  

  
function function: Transform the structure and data of a table into SQL
  
  

  
Function parameters: $table: Table name to be extracted
  
  

  
Return value: Returns the result after extraction, 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]. "; N\n ";
  
  

  

  
  

  
$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;
  
  

  
}
  
  

  
?>
  
  

  

  
  

  
<!--? php
  
  

  
$host = "localhost"; Host Name
  
  

  
$user = "root"; MySQL User name
  
  

  
$password = "root"; Password
  
  

  
$dbname = "DEDECMSV4"; Backed up databases
  
  

  

  
  

  
Mysql_connect ($host, $user, $password);
  
  

  
mysql_select_db ($dbname);
  
  

  

  
  

  
$q 1=mysql_query ("Show Tables");
  
  

  
while ($t =mysql_fetch_array ($q 1)) {
  
  

  
$table = $t [0];
  
  

  
$q 2=mysql_query ("Show create Table ' $table '");
  
  

  
$sql =mysql_fetch_array ($q 2);
  
  

  
$mysql. = $sql [' Create Table ']. " r\n\r\n "; #DDL
  
  

  

  
  

  
$q 3=mysql_query ("select * from ' $table");
  
  

  
while ($data =mysql_fetch_assoc ($q 3))
  
  

  
{
  
  

  
$keys =array_keys ($data);
  
  

  
$keys =array_map (' addslashes ', $keys);
  
  

  
$keys =join (', ', $keys);
  
  

  
$keys = "'. $keys." `";
  
  

  
$vals =array_values ($data);
  
  

  
$vals =array_map (' addslashes ', $vals);
  
  

  
$vals =join ("', '", $vals);
  
  

  
$vals = "'" $vals. "'";
  
  

  

  
  

  
$mysql. = "INSERT INTO ' $table ' ($keys) values ($vals); \ r \ n";
  
  

  
}
  
  

  
$mysql. = "\ r \ n";
  
  

  

  
  

  
}
  
  

  
$filename =date (' Ymd '). " _ ". $dbname.". SQL "; File name is the date of the day
  
  

  
$fp = fopen ($filename, ' w ');
  
  

  
Fputs ($fp, $mysql);
  
  

  
Fclose ($FP);
  
  

  
echo "Data backup succeeded, generate backup file". $filename;
  
  

  
?>