本文章提供了一个mysql 2xml转换类，可以快速的把xml转换成mysql同时反之也可以把mysql转换成xml哦，下面看代码。
mysql2xml.
php类文件：用于备份mysql数据的！！
代码如下复制代码class MySQL2XML {protected $conn;protected $result;protected $tables;protected $saveFolder = 'datas/';public function __construct($config = NULL) {if($config !== NULL && is_array($config)) {$this->connect($config);}}public function connect($config) {$this->conn = mysql_connect($config['host'], $config['username'], $config['password']);if($this->conn) {mysql_select_db($config['database']);return true;}return false;}public function setSaveFolder($folder) {if(is_dir($folder)) {$this->saveFolder = rtrim(str_replace("\", "/", $folder),'/');return true;}return false;}public function setTables($tables) {if(is_array($tables)) {$this->tables = $tables;return true;}return false;}public function query($query) {if(!isset($query) || trim($query) == '') return false;$this->result = mysql_query($query);if($this->result) return true;return false;}public function toXML() {if(!isset($this->tables)) return false;foreach($this->tables as $table) {$file = $this->saveFolder.$table.'.xml';$fp = @fopen($file, 'w');if(!$fp) exit('Can not write file');fwrite($fp, $this->tableToXML($table));fclose($fp);unset($fp);}return true;}public function tableToXML($table) {header("content-type:text/xml;charset=utf-8");$xml = "nn";$fields = $this->getFields($table);$datas = $this->getDatas($table);$cdata = array();foreach($datas as $data) {foreach($data as $key => $value)$cdata[$key][] = $value;}foreach($fields as $element) {$xml .= "tn";foreach($cdata[$element['Field']] as $value) {$xml .= "tt{$value}n";}$xml .= "tn";}$xml .= '';return $xml;}protected function getFields($table) {$query = "SHOW FIELDS FROM {$table}";$this->query($query);return $this->fetchAll();}protected function getDatas($table) {$query = "SELECT * FROM {$table}";$this->query($query);return $this->fetchAll();}protected function fetch() {if(is_resource($this->result)) {return mysql_fetch_assoc($this->result);}return false;}protected function fetchAll() {if(is_resource($this->result)) {$return = array();$row = NULL;while($row = mysql_fetch_assoc($this->result)) {$return[] = $row;}return $return;}return false;}}?>
调用方法：
PHP 8.5.5 PHP 8.5.5 是 PHP 8.5 分支的维护更新版本。该版本延续了“小步快跑”的迭代逻辑，通过深度错误修复、底层性能微调以及安全加固，旨在为开发者提供一个更健壮、更高效的运行环境。该版本严格遵守语义化版本规范，不包含破坏性变更。
下载代码如下复制代码$xml = new MySQL2XML(array('host'=>'localhost', 'username'=>'root', 'password'=>'', 'database'=>'mysql'));$xml->setTables(array('wp_term_relationships','wp_terms'));//设置备份的表$xml->setSaveFolder('datas/');//保存备份文件的文件夹$xml->toXML();//备份开始?>http://www.bkjia.com/PHPjc/632929.html www.bkjia.com true http://www.bkjia.com/PHPjc/632929.html TechArticle本文章提供了一个mysql2xml转换类，可以快速的把xml转换成mysql同时反之也可以把mysql转换成xml哦，下面看代码。 mysql2xml.php类文件：用于备份...