用PHP从动态内容创建一个简单的RSS

<?php
header("Content-Type: application/rss+xml; charset=UTF-8");

// 获取动态内容的数据，这里假设从数据库获取
$dbHost = "数据库主机";
$dbUser = "数据库用户名";
$dbPass = "数据库密码";
$dbName = "数据库名";

$conn = mysqli_connect($dbHost, $dbUser, $dbPass, $dbName);
if (!$conn) {
    die("数据库连接失败: " . mysqli_connect_error());
}

$query = "SELECT * FROM 动态内容表";
$result = mysqli_query($conn, $query);

// 创建RSS的XML结构
$xml = xml_create_element("rss");
$xml->setAttribute("version", "2.0");

$channel = xml_create_element("channel");
$xml->appendChild($channel);

// 设置RSS的基本信息
$title = xml_create_element("title", "动态内容的标题");
$description = xml_create_element("description", "动态内容的描述");
$link = xml_create_element("link", "动态内容的链接");

$channel->appendChild($title);
$channel->appendChild($description);
$channel->appendChild($link);

// 添加动态内容项到RSS的XML结构中
while ($row = mysqli_fetch_assoc($result)) {
    $item = xml_create_element("item");

    $itemTitle = xml_create_element("title", $row["标题"]);
    $itemDescription = xml_create_element("description", $row["描述"]);
    $itemLink = xml_create_element("link", $row["链接"]);

    $item->appendChild($itemTitle);
    $item->appendChild($itemDescription);
    $item->appendChild($itemLink);

    $channel->appendChild($item);
}

// 输出生成的XML内容
echo $xml->saveXML();

// 释放资源和关闭数据库连接
mysqli_free_result($result);
mysqli_close($conn);

// 创建XML元素的辅助函数
function xml_create_element($name, $value = "") {
    $dom = new DOMDocument("1.0", "UTF-8");
    $element = $dom->createElement($name);
    $element->appendChild($dom->createTextNode($value));
    return $element;
}
?>