Woohoo! Did it.
Thanks goes to Millenium, Collin, my
Beginning PHP4 book by wrox, and the following URLs:
http://feedvalidator.org
http://jade.mcli.dist.maricopa.edu/f...ed2php.inc.txt
http://www.inr.net/tools/html-escape-codes.cfm
http://blogs.law.harvard.edu/tech/rss (good spec page)
And a little peeking at MacNN's own .rss file by loading it in my browser.
The end result is this feed:
http://www.paxilprogress.org/paxilprogress_rss.php
I've tested it in both Firefox and NetNewsWire and it works brilliant. I'm proud.
I went from knowing nothing about RSS, to doing it in two days.
The code for the file with sensitives removed is:
[php]
<?php
// Thanks for this Collin
header("Content-Type: text/xml");
//
// Thanks for this MacNN
echo "<?xml version='1.0' encoding='ISO-8859-1'?>
<rss version='2.0'>
<channel>
<title>paxilprogress | Freedom is in you</title>
<link>
http://www.paxilprogress.org/</link>
<description>The net's best source of information and support on Paxil and Paxil Withdrawal.</description>
<language>en-us</language>
<lastBuildDate>". date("r") . "</lastBuildDate>
<image>
<title>paxilprogress</title>
<url>
http://www.paxilprogress.org/images/...gress_rss1.jpg</url>
<link>
http://www.paxilprogresss.org</link>
</image>
";
//
// let's generate the links/site news! This is my own stuff.
$link_id = mysql_connect("ip", "loginname", "password");
$result=mysql_list_dbs($link_id);
mysql_select_db("database", $link_id);
$result=mysql_query("SELECT * FROM tbl_links WHERE linkmoderate='0' ORDER BY linkid DESC LIMIT 0,20", $link_id);
if($result) {
while($query_data=mysql_fetch_row($result)){
echo "<item>";
$cleanTitle=Htmlentities($query_data[1]);
$cleanTitle=strip_tags($cleanTitle);
$cleanTitle=str_replace(" ", " ", $cleanTitle);
echo "<title>" . "Link-" . $cleanTitle . "</title>";
// url with special entities since feed validator rejected the & and =
echo "<link>" . "http://www.paxilprogress.org/forums/local_links.php?action=jump&id& ;#61;$query_data[0]" . "</link>";
$cleanDescription=Htmlentities($query_data[2]);
$cleanDescription=strip_tags($cleanDescription);
$cleanDescription=str_replace(" ", " ", $cleanDescription);
$cleanDescription=str_replace("\x96", " ", $cleanDescription); //phantom character that gotta go
$cleanDescription=str_replace("\x97", " ", $cleanDescription); //another phantom
echo "<description>"" . $cleanDescription . "</description>";
// I need to format the date. It's in int(10) format.
$rss_date=date('r', $query_data[8]);
//
echo "<pubDate>" . $rss_date . "</pubDate>";
echo "</item>
";
}
}
$result=mysql_query("SELECT * FROM tbl_sitenews WHERE newsType like 'Site News' ORDER BY newsID DESC LIMIT 0,15", $link_id);
if($result){
while ($query_data=mysql_fetch_row($result)){
echo "<item>";
$cleanTitle=Htmlentities($query_data[3]);
$cleanTitle=strip_tags($cleanTitle);
$cleanTitle=str_replace(" ", " ", $cleanTitle);
echo "<title>" . "Site News-" . $cleanTitle . "</title>";
echo "<link>" . "http://www.paxilprogress.org/newsDisplay.php?rid=$query_data[0]" . "</link>";
$cleanDescription=Htmlentities($query_data[4]);
$cleanDescription=strip_tags($cleanDescription);
$cleanDescription=str_replace(" ", " ", $cleanDescription);
$cleanDescription=str_replace("\x96", " ", $cleanDescription);
$cleanDescription=str_replace("\x97", " ", $cleanDescription);
echo "<description>"" . $cleanDescription . "</description>";
// From feed2php.inc.txt
// I need to format the date. It's in 0000-00-00 format.
$rss_date = date('r', strtotime($query_data[1]));
//
echo "<pubDate>" . $rss_date . "</pubDate>";
echo "</item>";
}
}
mysql_close($link_id);
?>
</channel>
</rss>[/php] The forum garbled my site's url field in the first part.
Top
