PHP从MySQL数据库获取数据并生成xml文档

最新推荐文章于 2015-07-14 15:23:14 发布

原创最新推荐文章于 2015-07-14 15:23:14 发布 · 1.4k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

PHP(CakePHP)

本文介绍了一个使用PHP从MySQL数据库中获取记录并将其转换为XML格式的示例代码。该过程涉及连接到数据库、执行查询并将结果集转换为DOM文档。

代码如下：(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>

标签

#mysql #xml #php #数据库 #query