php中实现xml与mysql数据相互转换的方法_PHP

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

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

mysql2xml.php类文件,用于备份MySQL数据的,代码如下:

<?php <br />class MySQL2XML { <br />        protected $conn; <br />        protected $result; <br />        protected $tables; <br />        protected $saveFolder = 'datas/'; <br />         <br />        public function __construct($config = NULL) { <br />                if($config !== NULL && is_array($config)) { <br />                        $this->connect($config); <br />                } <br />        } <br />         <br />        public function connect($config) { <br />                $this->conn = mysql_connect($config['host'], $config['username'], $config['password']); <br />                if($this->conn) { <br />                        mysql_select_db($config['database']); <br />                        return true; <br />                } <br />                return false; <br />        } <br />         <br />        public function setSaveFolder($folder) { <br />                if(is_dir($folder)) { <br />                        $this->saveFolder = rtrim(str_replace("\", "/", $folder),'/'); <br />                        return true; <br />                } <br />                return false; <br />        } <br />         <br />        public function setTables($tables) { <br />                if(is_array($tables)) { <br />                        $this->tables = $tables; <br />                        return true; <br />                } <br />                return false; <br />        } <br />         <br />        public function query($query) { <br />                if(!isset($query) || trim($query) == '') return false; <br />                $this->result = mysql_query($query); <br />                if($this->result) return true; <br />                return false; <br />        } <br />         <br />        public function toXML() { <br />                if(!isset($this->tables)) return false; <br />                foreach($this->tables as $table) { <br />                        $file = $this->saveFolder.$table.'.xml'; <br />                        $fp = @fopen($file, 'w'); <br />                        if(!$fp) exit('Can not write file'); <br />                        fwrite($fp, $this->tableToXML($table)); <br />                        fclose($fp); <br />                        unset($fp); <br />                } <br />                return true; <br />        } <br />         <br />        public function tableToXML($table) { <br />                header("content-type:text/xml;charset=utf-8"); <br />                $xml = "nn"; <br />                $fields = $this->getFields($table); <br />                $datas = $this->getDatas($table); <br />                $cdata = array(); <br />                foreach($datas as $data) { <br />                        foreach($data as $key => $value) <br />                                $cdata[$key][] = $value; <br />       <em>￥本文来%源[email protected]搞@^&代*@码)网5</em><strong>搞gaodaima代码</strong>         } <br />                foreach($fields as $element) { <br />                        $xml .= "tn"; <br />                        foreach($cdata[$element['Field']] as $value) { <br />                                $xml .= "tt{$value}n"; <br />                        } <br />                        $xml .= "tn"; <br />                } <br />                $xml .= ''; <br />                return $xml; <br />        } <br />         <br />        protected function getFields($table) { <br />                $query = "SHOW FIELDS FROM {$table}"; <br />                $this->query($query); <br />                return $this->fetchAll(); <br />        }<br />         <br />        protected function getDatas($table) { <br />                $query = "SELECT * FROM {$table}"; <br />                $this->query($query); <br />                return $this->fetchAll(); <br />        } <br />         <br />        protected function fetch() { <br />                if(is_resource($this->result)) { <br />                        return mysql_fetch_assoc($this->result); <br />                } <br />                return false; <br />        } <br />         <br />        protected function fetchAll() { <br />                if(is_resource($this->result)) { <br />                        $return = array(); <br />                        $row = NULL; <br />                        while($row = mysql_fetch_assoc($this->result)) { <br />                                $return[] = $row; <br />                        } <br />                        return $return; <br />                } <br />                return false; <br />        } <br />} <br />?>

调用方法,代码如下:

<?php <br />$xml = new MySQL2XML(array('host'=>'localhost', 'username'=>'root', 'password'=>'', 'database'=>'mysql')); <br />$xml->setTables(array('wp_term_relationships','wp_terms'));//设置备份的表 <br />$xml->setSaveFolder('datas/');//保存备份文件的文件夹 <br />$xml->toXML();//备份开始 <br />?>

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

喜欢 (0)赏

[搞代码]

分享 (0)