代码如下:(PHP5.2+MySQL5.0)
<?php
// query database for records
$connection = mysql_connect("localhost", "root", "root") or die ("Unable toconnect!");
mysql_select_db("guestbook") or die ("Unable to select database!");
mysql_query("SET NAMES UTF8");
$query = "SELECT date, name, hp, description FROM ylczgb";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
if (mysql_num_rows($result) > 0)
{
$dom = new DomDocument('1.0','UTF-8');
$rcs = $dom->createElement("rcs");
while(list($date, $name, $hp, $description) = mysql_fetch_row($result))
{
$rc = $dom->createElement("rc");
$mydate=$dom->createElement("date");
$myname = $dom->createElement("name");
$myhp=$dom->createElement("hp");
$mydescription=$dom->createElement("description");
$datetext = $dom->createTextNode($date);
$mydate->appendChild($datetext);
$nametext=$dom->createTextNode($name);
$myname->appendChild($nametext);
$hptext=$dom->createTextNode($hp);
$myhp->appendChild($hptext);
$descriptiontext=$dom->createTextNode($description);
$mydescription->appendChild($descriptiontext);
$rcs->appendChild($rc);
$rc->appendChild($mydate);
$rc->appendChild($myname);
$rc->appendChild($myhp);
$rc->appendChild($mydescription);
}
$dom->appendChild($rcs);
echo $dom->saveXML();
}
// close connection
mysql_close($connection);
?>
生成的xml文档如下:<?xml version="1.0" encoding="utf-8" ?>
<records>
<record>
<date></date>
<summary></summary>
<name></name>
<hp>/hp>
<description></description>
</record>
</records>
<?php
// query database for records
$connection = mysql_connect("localhost", "root", "root") or die ("Unable toconnect!");
mysql_select_db("guestbook") or die ("Unable to select database!");
mysql_query("SET NAMES UTF8");
$query = "SELECT date, name, hp, description FROM ylczgb";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
if (mysql_num_rows($result) > 0)
{
$dom = new DomDocument('1.0','UTF-8');
$rcs = $dom->createElement("rcs");
while(list($date, $name, $hp, $description) = mysql_fetch_row($result))
{
$rc = $dom->createElement("rc");
$mydate=$dom->createElement("date");
$myname = $dom->createElement("name");
$myhp=$dom->createElement("hp");
$mydescription=$dom->createElement("description");
$datetext = $dom->createTextNode($date);
$mydate->appendChild($datetext);
$nametext=$dom->createTextNode($name);
$myname->appendChild($nametext);
$hptext=$dom->createTextNode($hp);
$myhp->appendChild($hptext);
$descriptiontext=$dom->createTextNode($description);
$mydescription->appendChild($descriptiontext);
$rcs->appendChild($rc);
$rc->appendChild($mydate);
$rc->appendChild($myname);
$rc->appendChild($myhp);
$rc->appendChild($mydescription);
}
$dom->appendChild($rcs);
echo $dom->saveXML();
}
// close connection
mysql_close($connection);
?>
生成的xml文档如下:<?xml version="1.0" encoding="utf-8" ?>
<records>
<record>
<date></date>
<summary></summary>
<name></name>
<hp>/hp>
<description></description>
</record>
</records>