PHP MYSQL RSS FEED 限制问题

Question

我正在尝试将来自 MYsql 数据库的 RSS 提要放在一起。但脚本只会发布 2 个事件。如果 LIMIT 设置为 3 或更多，则会出现错误消息:

This page contains the following errors:
error on line 26 at column 29: xmlParseEntityRef: no name

下面是出现第一个错误之前的页面呈现。这是我的代码:

<?php
header('Content-Type: text/xml');
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());

echo '<?xml version="1.0" encoding="ISO-8859-1"?>
<rss version="2.0">
<channel>
<title>My Website Name</title>
<description>A description of the feed</description>
<link>The URL to the website</link>';

$get_articles = "SELECT id, title, description,
DATE_FORMAT(start_date,'%a, %e %b %Y %T') as formatted_date
FROM table_name ORDER BY start_date DESC LIMIT 4";

$articles = mysql_query($get_articles) or die(mysql_error());

while ($article = mysql_fetch_array($articles)){

echo '
   <item>
      <title>'.$article[title].'</title>
      <description><![CDATA[
      '.$article[description].'
      ]]></description>
      <link>http://www.gigreview.com.au/index.php/gig-review/'.$article[id].'</link>
      <pubDate>'.$row[formatted_date].' GMT</pubDate>
  </item>';
}
echo '</channel>
</rss>';
?>

Answer 1

尝试通过 http://validator.w3.org/feed/ 验证 XML - 也许它的标志像 & 需要是 & - 你可以尝试使用: http://php.net/manual/en/function.htmlspecialchars.php