Implement XML backup of Mysql database collection using PHP
The following is the file code for backing up Mysql database through Apache+PHP under Linux:
File 1, Listtable.php (the file lists all tables in the database for selection and backup)
Please Select the tables to be backed up:
Copy the code The code is as follows:
$con=mysql_connect('localhost','root','xswlily');
$lists=mysql_list_tables("embed ",$con);
//Database connection code
$i=0;
while($i$tb_name=mysql_tablename($lists,$i);
echo "".$tb_name."
";
// List all tables
$i++;}
?>
Copy code The code is as follows:
$con=mysql_connect('localhost','root','xswlily');
$query="select * from $table ";
/ /Database query
$result=mysql_db_query("embed",$query,$con);
$filestr="<"."?xml version="1.0" encoding="GB2312"?".">";
$filestr.="<".$table."s>";
while ($row=mysql_fetch_array($result))
//List all records
{$filestr.="<".$ table.">";
$fields=mysql_list_fields("embed",$table,$con);
$j=0;
//$num_fields=mysql_field_name($fields,$j);
//echo $ num_fields;
while ($j$num_fields=mysql_field_name($fields,$j);
$filestr.="<".$num_fields.">";
$filestr.=$row[$j];
$filestr.="";
$j++;}
$filestr.="";
}
$filestr.="";
echo $filestr;
//The following is the file operation code
$filename=$table. ".xml";
$fp=fopen("$filename","w");
fwrite($fp,$filestr);
fclose($fp);
Echo "data table".$table." has been Backup successful! ";?>
The above introduces the MySQL data table damage PHP XML backup Mysql database, including the content of MySQL data table damage. I hope it will be helpful to friends who are interested in PHP tutorials.