PHP code<?php

$conn =mysql_connect('localhost', 'root', '12345678') or die('Could not connect: ' . mysql_error());

mysql_select_db('test', $conn);

$str = "SELECT Sno,Sname,Ssex,Birthday,Class FROM student";

$result = mysql_query($str) or die("Invalid query: " . mysql_error());

if($result)

{

$xmlDoc = new DOMDocument();

if(!file_exists("student.xml")){

$xmlstr = "<?xml version='1.0' encoding='utf-8' ?>";

$xmlDoc->loadXML($xmlstr);

$xmlDoc->save("student.xml");

}else {

unlink("student.xml");

$xmlDoc->load("student.xml");}

$Root = $xmlDoc->documentElement;

mysql_query("set names gb2312");

$result=mysql_query("SELECT Sno,Sname,Ssex,Birthday,Class FROM student");

while ($arr = mysql_fetch_array($result)){

$node = $xmlDoc->createElement("PERSON");

$node1 = $xmlDoc->createElement("NO");

$text1 = $xmlDoc->createTextNode(iconv("GB2312","UTF-8",$arr["Sno"]));

$node1->appendChild($text1);

$node2 = $xmlDoc->createElement("NAME");

$text2 = $xmlDoc->createTextNode(iconv("GB2312","UTF-8",$arr["Sname"]));

$node2->appendChild($text2);

$node3 = $xmlDoc->createElement("SEX");

$text3 = $xmlDoc->createTextNode(iconv("GB2312","UTF-8",$arr["Ssex"]));

$node3->appendChild($text3);

$node4 = $xmlDoc->createElement("BIRTHDAY");

$text4 = $xmlDoc->createTextNode(iconv("GB2312","UTF-8",$arr["Birthday"]));

$node4->appendChild($text4);

$node5= $xmlDoc->createElement("CLASS");

$text5= $xmlDoc->createTextNode(iconv("GB2312","UTF-8",$arr["Class"]));

$node5->appendChild($text5);

$Root->appendChild($node1);

$Root->appendChild($node2);

$Root->appendChild($node3);

$Root->appendChild($node4);

$Root->appendChild($node5);

$node->appendChild($node1);

$node->appendChild($node2);

$node->appendChild($node3);

$node->appendChild($node4);

$node->appendChild($node5);

$Root->appendChild($node);

$xmlDoc->save("student.xml");

}

echo "student数据表生成student.xml文件成功！";

}

mysql_close($conn);

?>