利用PHP实现XML和MySQL的相互转换

PHP代码

2. class MySQL2XML {
3. protected $conn;
4. protected $result;
5. protected $tables;
6. protected $saveFolder = 'datas/';
8. public function __construct($config = NULL) {
9. if($config !== NULL && is_array($config)) {
10. $this->connect($config);
11. }
12. }
14. public function connect($config) {
15. $this->cOnn= mysql_connect($config['host'], $config['username'], $config['password']);
16. if($this->conn) {
17. mysql_select_db($config['database']);
18. return true;
19. }
20. return false;
21. }
23. public function setSaveFolder($folder) {
24. if(is_dir($folder)) {
25. $this->saveFolder = rtrim(str_replace("\\", "/", $folder),'/');
26. return true;
27. }
28. return false;
29. }
31. public function setTables($tables) {
32. if(is_array($tables)) {
33. $this->tables = $tables;
34. return true;
35. }
36. return false;
37. }
39. public function query($query) {
40. if(!isset($query) || trim($query) == '') return false;
41. $this->result = mysql_query($query);
42. if($this->result) return true;
43. return false;
44. }
46. public function toXML() {
47. if(!isset($this->tables)) return false;
48. foreach($this->tables as $table) {
49. $file = $this->saveFolder.$table.'.xml';
50. $fp = @fopen($file, 'w');
51. if(!$fp) exit('Can not write file');
52. fwrite($fp, $this->tableToXML($table));
53. fclose($fp);
54. unset($fp);
55. }
56. return true;
57. }
59. public function tableToXML($table) {
60. header("content-type:text/xml;charset=utf-8");
61. $xml = ""1.0\" encoding=\"utf-8\" ?>\n\n";
62. $fields = $this->getFields($table);
63. $datas = $this->getDatas($table);
64. $cdata = array();
65. foreach($datas as $data) {
66. foreach($data as $key => $value)
67. $cdata[$key][] = $value;
68. }
69. foreach($fields as $element) {
70. $xml .= "\t\n";
71. foreach($cdata[$element['Field']] as $value) {
72. $xml .= "\t\t{$value}\n";
73. }
74. $xml .= "\t\n";
75. }
76. $xml .= '';
77. return $xml;
78. }
80. protected function getFields($table) {
81. $query = "SHOW FIELDS FROM {$table}";
82. $this->query($query);
83. return $this->fetchAll();
84. }
86. protected function getDatas($table) {
87. $query = "SELECT * FROM {$table}";
88. $this->query($query);
89. return $this->fetchAll();
90. }
92. protected function fetch() {
93. if(is_resource($this->result)) {
94. return mysql_fetch_assoc($this->result);
95. }
96. return false;
97. }
99. protected function fetchAll() {
100. if(is_resource($this->result)) {
101. $return = array();
102. $row = NULL;
103. while($row = mysql_fetch_assoc($this->result)) {
104. $return[] = $row;
105. }
106. return $return;
107. }
108. return false;
109. }
110. }
111. ?>

调用方法：

PHP代码

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