config.php
Code:
<?php
$dbhost = 'localhost';
$dbusername = 'root';
$dbpassword = 'mydbpass';
$dbname = 'test';
$conn=mysql_connect($dbhost, $dbusername, $dbpassword);
if(!$conn) :
die('Could not connect: ' . mysql_error());
endif;
$db=mysql_select_db($dbname, $conn);
if(!$db) :
die ('Can't connect to database : . mysql_error());
endif;
?>
rss.php
Code:
<?php header('Content-type: application/rss+xml'); ?>
<?php echo "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n"; ?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
<atom:link href="http://example.com/rss.php" rel="self" type="application/rss+xml" />
<title>example.com</title>
<description>news example.com</description>
<link>http://example.com</link>
<?php
include ('config.php');
$res = mysql_query("SELECT id, title, description, date
FROM news ORDER by date DESC LIMIT 5")
or die(mysql_error());
while($row = mysql_fetch_array($res)){
?>
<item>
<title> <?php echo $row['title']; ?></title>
<description> <?php echo htmlspecialchars($row['description'], ENT_QUOTES); ?> </description>
<link>http://example.com/?id=<?php echo $row['id']; ?></link>
<guid>http://example.com/<?php echo $row['id']; ?>.html</guid>
<pubDate> <?php echo date("r", strtotime($row["date"])); ?></pubDate>
</item>
<?php
}
?>
</channel>
</rss>
discuss this topic to forum
11/11/09
