Home > Article > Backend Development > Using PHP to implement XML backup of Mysql database_PHP tutorial
Using PHP to implement XML backup of Mysql database_PHP tutorial
- WBOYOriginal
- 2016-07-13 17:02:24664browse
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)
Please select the table to be backed up:
$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."
";
//column Out all tables
$i ;}
?>
File 2, Backup.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." already Backup successful! ";?>
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, and of course, we can also restore the backed-up XML documents to the database through related methods.