Debian News RSS Feed

[netXolutions / Jens Voskuhl <voskuhl@netxolutions.de>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

i have read the 47th issue of DWN, that there is no official RSS feed provided 
by the debian project. I wrote some code for my website with PHP, to build in 
a RSS feed (that includes my news). It works just fine and was validatet by a 
RSS-Validator. It was also tested with knewsticker. Here is the code i use.
Hope someone can use it:

<?php
$date = date("r");
header('Content-type: application/xml'); 
echo "<?xml version='1.0' encoding='ISO-8859-1' ?>\n";
echo "<!DOCTYPE rss PUBLIC '-//Netscape Communications//DTD RSS 0.91//EN'
'http://my.netscape.com/publish/formats/rss-0.91.dtd'>\n";
echo "<rss version='0.91'>\n";
echo "<channel>\n";
echo "<title>debian</title>\n";
echo "<link>http://www.debian.org</link>\n";
echo "<description>debian WEEKLY NEWS</description>\n";
echo "<language>en-en</language>\n";
echo "<lastBuildDate>$date</lastBuildDate>\n";
echo "<copyright>2004 debian</copyright>\n";
echo "<image>\n";
echo "<title>debian WEEKLY NEWS</title>\n";
echo "<url>http://www.debian.org/favicon.ico</url>\n";
echo "<link>http://www.debian.org</link>\n";
echo "</image>\n";
	
#######################################################################################
	#connect to database
	
#######################################################################################
	$conn_id = mysql_connect ("database","user","passwd");
	$result = mysql ("database","select * from news");
	$num = mysql_numrows ($result);
	if ($num != 0)
	{
	for ($i=0;$i<$num;$i++)
	{
	#########################################
	#database query
	#########################################
		$nrak = $num - $i - 1;
		$id = mysql_result ($result,$nrak,"id");
		$datum = mysql_result ($result,$nrak,"date");
		$header = mysql_result ($result,$nrak,"header");
		$eintrag = mysql_result ($result,$nrak,"entry");

		echo "<item>\n";
		echo "<title>$header</title>\n";
		echo "<link>http://www.debian.org/read_news.php?id=$id</link>\n";
		echo "<description>debian WEEKLY NEWS</description>\n";
		echo "</item>\n";

		    	}
	}
echo "</channel>\n";
echo "</rss>";
?>

- -- 
Greetings


Jens Voskuhl
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBrOh7V3K9CB+D8fgRAhmiAKDU5pFVFQc01TM7syuYvuTGg7rd7gCfZQhI
6YvxK2bccfTuvUYDv0yXV28=
=1S2a
-----END PGP SIGNATURE-----