PHP uses XML to back up MySQL database instance_PHP tutorial

This article will introduce you to a PHP backup MySQL database instance using XML. Personally, I think this method is only suitable for users with small data volumes and low security requirements.

The following is the file code for backing up the Mysql database through Apache+PHP under Linux:
File 1, Listtable.php (file lists all tables in the database for backup)
Please select the table to backup:

"; //List all tables

The code is as follows

代码如下	复制代码
$con=mysql_connect('localhost','root','xswlily'); $lists=mysql_list_tables("embed",$con); //数据库连接代码 $i=0; while($i$tb_name=mysql_tablename($lists,$i); echo "".$tb_name." "; //列出所有的表格 $i++;} ?>

Copy code

$con=mysql_connect('localhost',' root','xswlily'); $lists=mysql_list_tables("embed",$con);

代码如下

复制代码

"") header("Location:listtable.php");?>   $con=mysql_connect('localhost','root','xswlily'); $query="select * from $table "; //数据库查询 $result=mysql_db_query("embed",$query,$con); $filestr="<"."?xml version="1.0" encoding="GB2312"?".">"; $filestr.="<".$table."s>"; while ($row=mysql_fetch_array($result)) //列出所有的记录 {$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; //以下是文件操作代码 $filename=$table.".xml"; $fp=fopen("$filename","w"); fwrite($fp,$filestr); fclose($fp); Echo "数据表".$table."已经备份成功！";?>

//Database connection code

$i=0;
while($i$tb_name=mysql_tablename($lists,$i);

echo "".$tb_name."

$i++;} ?>

File 2, Backup.php

The code is as follows

Copy code

"") header("Location:listtable.php");?> $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."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 http://www.bkjia.com/PHPjc/632924.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/632924.htmlTechArticleThis article will introduce you to a PHP backup MySQL database instance using XML. Personally, I think this method is only suitable for small data. users who have high volume and do not have high security requirements. The following is in Linu...