<?php header('Content-type: text/xml'); ?>
<rss version="2.0">
 
<?php
(connection goes here)
(recordset goes here)
?>
<channel>
	<title>X</title>
	<description>I like the Internet</description>
	<link>http://www.x.com</link>
 
<?php
	mysql_select_db($aCon, $acCon);
    $top5q="SELECT blogIndex,title,content,DATE_FORMAT(date,'%a, %d %b %Y %T') AS rfcdate,tag1,tag2,tag3,tag4,tag5,tag6,tag7,tag8,tag9,tag10 FROM rhododendrites_blog ORDER BY date DESC LIMIT 10";
    $recentp = mysql_query($top5q,$acCon) or die(mysql_error());
	while($row=mysql_fetch_array($recentp))
		{ ?>
		<item>
			<title><?php
				echo htmlentities(strip_tags($row['title'])); ?>
			</title>
			<description>
				<?php echo $row['content']; ?>
			</description>
			<link>http://www.x.com/blog/post.php?blogid=<?php echo $row['blogIndex']; ?></link>
			<pubDate><?php echo $row['rfcdate']; ?></pubDate>
		</item>
		<?php } ?> 
 
</channel>
</rss>

<?php
  require_once 'smarty/Smarty.class.php';
  $tpl = new Smarty();
  require_once './inc/defines.inc.php';
  $tpl->force_compile = false;
  $tpl->caching = 1;
  $tpl->cache_lifetime = 14400;		
  if ($tpl->is_cached('rss.tpl')) {
    $content = $tpl->fetch('rss.tpl');
  }
  else {
    $content = '';
    $db_link = @mysql_connect(HOST, USER, PASS);
    @mysql_select_db(DB);
    $query = "<omitted>";
    $result = @mysql_query($query);
    if ($result) {
      $rss = array ();
      while ($row = mysql_fetch_assoc($result)) {
        $dp = explode('-', $row['date']);
        $dt = mktime(12, 0, 0, $dp[1], $dp[2], $dp[0]);
        $row['date'] = date("D, d M Y H:i:s ", $dt) . '+0100';
        $row['article'] = substr($row['article'], 0, strpos($row['article'], '</p>'));
        $row['article'] = htmlentities(strip_tags($row['article']));
        $rss[] = $row;
      }
      $pd = date("D, d M Y H:i:s ", time()) . '+0100'; 
      $tpl->assign('PUBDATE', $pd);
      $tpl->assign('YEAR', date('Y'));
      $tpl->assign('RSS', $rss);
      $content = $tpl->fetch('rss.tpl');
    }
    if ($db_link)
      mysql_close($db_link);
  }	
  header("Content-Type: application/xml; charset=ISO-8859-1");
  echo $content;
?>

<?xml version="1.0" encoding="ISO-8859-1" ?>
<rss version="2.0">
  <channel>
    <title>Stichting Kledingbank Limburg - Actueel</title>
    <link>http://www.kledingbank-limburg.nl/page/actueel</link>
    <description>Actueel nieuws</description>
    <language>nl-nl</language>
    <lastBuildDate>{$PUBDATE}</lastBuildDate>
    <pubDate>{$PUBDATE}</pubDate>
    <copyright>Copyright 2005-{$YEAR} Stichting Kledingbank Limburg</copyright>
    <image>
      <url>http://www.kledingbank-limburg.nl/img/kledingbank-limburg.png</url>
      <link>http://www.kledingbank-limburg.nl/</link>
    </image>
    {foreach from=$RSS item=item}
      <item>
        <title>{$item.title}</title>
        <link>{$item.url}</link>
        <description>{$item.article}</description>
        <author>{$item.author}</author>
        <pubDate>{$item.date}</pubDate>
        <category>{$item.category}</category>
      </item>
    {/foreach}
  </channel>
</rss>

<?php $db = new mysqli("localhost", "root", "", "rss"); ?>
<?php header('Content-type: text/xml'); ?>
<?php echo "<?";?>xml version="1.0" encoding="iso-8859-1"<?php echo "?> ";?>
<rss version="2.0" xmlns:atom="http://www.geocities.com/jas_jo679"> 
<channel> 
	<title> Making a Dynamic RSS Feed</title> 
	<description> Getting items from the database.</description> 
	<link> http://barbz.0fees.net/</link> 
	<copyright> Your Copyright Information</copyright> 
	<atom:link href="http://barbz.0fees.net/" rel="self" type="application/rss+xml" /> 
	<image> 
        <url> http://www.upd.edu.ph/~music/graphics/up%20logo%20colored.gif</url> 
    </image>  
 
	<?php
	$query = "SELECT * FROM `article`";
	$results = $db-> query($query);
	$number = $results->num_rows;
 
	for ($i = 1; $i <= $number; $i++) {
		$row = $results-> fetch_assoc();
		$title = $row['title'];
		$description = $row['body'];
		$link = $row['link'];
	?>
		<item> 
			<title> <?php echo $title; ?> </title> 
			<description> <?php echo $description; ?> </description> 
			<link> <?php echo $link; ?> </link> 
		</item> 
		<?php
	}?> 
</channel> 
</rss> 
<?php
 
$db-> close();
 
?>