>[danger]DOM 節點創建XML ~~~ //PDO連接數據庫 $dsn = 'mysql:host=localhost;dbname=test;charset=utf8'; $username = 'root'; $passwd = '556656'; $pdo = new PDO($dsn,$username,$passwd); $sql = 'select * from stu_info'; $res = $pdo->query($sql)->fetchAll(2); //print_r($res); //組裝DOM對象 $dom = new DOMDocument('1.0','utf-8'); //創建根節點 $root = $dom->createElement('root'); foreach($res as $v){ $student = $dom->createElement('student'); foreach($v as $k=>$vo){ $key = $dom->createElement($k); $value = $dom->createTextNode($vo); $key->appendChild($value); $student->appendChild($key); } $root->appendChild($student); } //追加到根節點 $dom->appendChild($root); //保存生成文件 $dom->save('studentinfo2.xml'); ~~~