RSS Feed - Free Code Script

This small snippet will create an RSS feed. I've tested the format using several popular RSS readers and it seems to work fine.

<?php // Some RSS readers don't like certain characters in the text so this function will replace them with HTML entities function escape_upper_chars($text) { // 32-90, 97-122 for ($x = 0; $x < strlen($text); $x++) { $w = $text{$x}; if ((ord($w) < 32) || ((ord($w) > 90) && (ord($w) < 97)) || (ord($w) > 122)) { $q .= '&#'.ord($w).';'; } else { $q .= $w; } } return $q; } header("Content-type: text/xml"); // Send the header data echo "<?xml version=\"1.0\"?><!DOCTYPE rss SYSTEM \"http://my.netscape.com/publish/formats/rss-0.91.dtd\"> <rss version=\"0.91\"> <channel> <title>RSS Feed</title> <language>en</language> <link>http://www.website.com</link> <description>RSS Feed Description</description>\n"; // Force int data type on $limit to prevent SQL injection attacks $limit = (int)$_GET['limit']; if (($limit < 1) || ($limit > 50)) { $limit = 15; } // Set the default number of results // Query the database (make sure you have included the necessary commands to connect to a MySQL server) $query = "SELECT id,title,time,author FROM articles ORDER BY time DESC LIMIT $limit"; $s = mysql_query($query); // Change the variables here according to your query above while (list($id,$title,$time,$author) = mysql_fetch_row($s)) { $title = escape_upper_chars($title); // Customize the data sent to the RSS reader. You should pass text grabbed from the database through escape_upper_chars() echo "<item>\n"; // Begin a new item echo "<title><![CDATA[$title]]></title>\n"; // Send the title echo "<link><![CDATA[http://www.website.com/view.php?id=$id]]></link>\n"; // Send link to the item echo "<description><![CDATA[Posted by $author on " . date("l dS of F @ h:ia",$time) . "]]></description>\n"; // Send description echo "</item>\n"; //End the item } echo "</channel>\n</rss>"; // Close the RSS channel ?> <a target="_blank" href="http://www.freecodescript.com/">Free Code Script</a>

PHP Code: RSS Feed Next Code