php中实现xml与mysql数据相互转换的方法
author:一佰互联 2019-04-28   click:138

本文实例讲述了php中实现xml与mysql数据相互转换的方法。分享给大家供大家参考。具体分析如下:

这里提供了一个mysql2xml转换类,可以快速的把xml转换成mysql同时反之也可以把mysql转换成xml,下面看代码.

mysql2xml.php类文件,用于备份MySQL数据的,代码如下:复制代码 代码如下:<?php 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 = "<?xml version="1.0" encoding="utf-8" ?>n<datas>n";                 $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 .= "t<fields name="{$element["Field"]}" type="{$element["Type"]}" null="{$element["Null"]}" key="{$element["Key"]}" default="{$element["Default"]}" extra="{$element["Extra"]}">n";                         foreach($cdata[$element["Field"]] as $value) {                                 $xml .= "tt<data>{$value}</data>n";                         }                         $xml .= "t</fields>n";                 }                 $xml .= "</datas>";                 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 $xml = new MySQL2XML(array("host"=>"localhost", "username"=>"root", "password"=>"", "database"=>"mysql")); $xml->setTables(array("wp_term_relationships","wp_terms"));//设置备份的表 $xml->setSaveFolder("datas/");//保存备份文件的文件夹 $xml->toXML();//备份开始 ?>

希望本文所述对大家的php程序设计有所帮助。