PHP XML backup Mysql database_PHP tutorial

Use PHP to implement XML backup of Mysql database collection
The following is the file code for backing up the Mysql database through Apache+PHP under Linux:
File 1. Listtable.php (the file lists all tables in the database , for backup selection)
Please select the table 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 Table
$i++;}
?>

File 2, Backup.php

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 backed up successfully! ";?>

By operating the above files, you can back up the selected tables in the database.
The above mainly introduces the operation method of XML backup database through PHP. In fact, It is not complicated. Through XML, we can back up various databases. Of course, we can also restore the backed-up XML documents to the database through related methods, which will not be described in detail here.

http://www.bkjia.com/PHPjc/320086.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/320086.htmlTechArticleUsing PHP to implement XML backup of Mysql database collection The following are files for backing up Mysql database through Apache+PHP under Linux Code: File 1, Listtable.php (file lists all the items in the database...