14, February 2012

on-the-fly RSS - webmaster forum

 
Webdigity webmaster forums
[ Home | Help | Search | Forum's Shop | Archive | Login | Register | Webmaster Directory ]
Webdigity Webmaster Forums  >  Web Development  >  PhP
Topic: on-the-fly RSS 		« previous next »
Pages: [1] Print
Instabuck - The easy way to sell digital products online

Author Topic: on-the-fly RSS  (Read 1301 times)
aka J Love
Community Supporter ?
Bill Gates is my home boy
*****
Gender: Male
Posts: 886
1148 credits
Members referred : 4
« on: Apr 18, 2007, 06:52:10 pm »
apparently there is a problem now with my RSS file, as i coded the file myself to create itself from news in the database as im sure most of you have.. but what is the problem?

here is the file itself: http://jlove.justinlove.net/rss.php

Code:
<?php
$conn = mysql_connect("DATAHIDDEN","DATAHIDDEN","DATAHIDDEN");
mysql_select_db("DATAHIDDEN") or die(mysql_error());
function bbdecode($text) {
 $text = str_replace('[b]', '', $text);
 $text = str_replace('[/b]', '', $text);
 $text = str_replace('[i]', '', $text);
 $text = str_replace('[/i]', '', $text);
 $text = str_replace('[u]', '', $text);
 $text = str_replace('[/u]', '', $text);
 $text = str_replace('[url]', '', $text);
 $text = str_replace('[/url]', '', $text);
 $text = str_replace('[img]', '', $text);
 $text = str_replace('[/img]', '', $text);
 $text = str_replace('[center]', '', $text);
 $text = str_replace('[/center]', '', $text);
 $text = str_replace('[small]', '', $text);
 $text = str_replace('[/small]', '', $text);
 $text = str_replace('[big]', '', $text);
 $text = str_replace('[/big]', '', $text);
 return $text;
}
function showdate($format, $val) {
 return strftime($format, $val+(1*3600));
}

$result = mysql_query("SELECT * FROM haze_news ORDER BY postdate DESC");
header("content-type:text/xml;charset=utf-8");

echo "<rss version='2.0'>\n";
echo "<channel>\n";
echo "<title>J Love's Blog RSS Feed</title>\n";
echo "<link>http://jlove.justinlove.net/</link>\n";
echo "<description>Justin Love's Personal Site - Blog : RSS Feed</description>\n";
while($row = mysql_fetch_array($result)) {
 $news_cat = mysql_fetch_array(mysql_query("SELECT news_cat_id, news_cat_title FROM haze_news_cats WHERE news_cat_id = ".$row['news_cat_id']));
 $cat_name = stripslashes($news_cat['news_cat_title']);
 $cat_id = $news_cat['news_cat_id'];
 echo "<item>\n";
 echo "<title>".stripslashes($row['title'])."</title>\n";
 echo "<link>http://jlove.justinlove.net/page.php?id=8&amp;view=news&amp;news_id=".$row['id']."</link>\n";
 echo "<description>".bbdecode($row['content'])."</description>\n";
 echo "<guid isPermaLink='true'>http://jlove.justinlove.net/page.php?id=8&amp;view=news&amp;news_id=".$row['id']."</guid>\n";
 echo "<category domain='http://jlove.justinlove.net/page.php?id=12&amp;cat_id=".$cat_id."'>".$cat_name."</category>\n";
 echo "<pubDate>".showdate("%a, %d %b %G %H:%M:%S EST", $row['postdate'])."</pubDate>\n";
 echo "</item>\n";
}
echo "</channel>\n";
echo "</rss>\n";
?>

this is of course the same feed i am still trying to submit to my profile on webdigity =/
Elitix Internet Technologies - World Play Online - My Blog

Last blog : phpHaze 1.59.1 in Development
aka J Love
Community Supporter ?
Bill Gates is my home boy
*****
Gender: Male
Posts: 886
1148 credits
Members referred : 4
« Reply #1 on: Apr 18, 2007, 07:08:55 pm »
nevermind.. have found the problem, has alot to do with single quotes and ampersands, here is how i solved the problem if anyone needs help with those rss self creating files:

Code:
<?php

<?php
$conn = mysql_connect("datahidden","datahidden","datahidden");
mysql_select_db("datahidden") or die(mysql_error());
define("QUOTES_GPC", (ini_get('magic_quotes_gpc') ? TRUE : FALSE));

function bbdecode($text) {
 $text = str_replace('[b]', '', $text);
 $text = str_replace('[/b]', '', $text);
 $text = str_replace('[i]', '', $text);
 $text = str_replace('[/i]', '', $text);
 $text = str_replace('[u]', '', $text);
 $text = str_replace('[/u]', '', $text);
 $text = str_replace('[url]', '', $text);
 $text = str_replace('[/url]', '', $text);
 $text = str_replace('[img]', '', $text);
 $text = str_replace('[/img]', '', $text);
 $text = str_replace('[center]', '', $text);
 $text = str_replace('[/center]', '', $text);
 $text = str_replace('[small]', '', $text);
 $text = str_replace('[/small]', '', $text);
 $text = str_replace('[big]', '', $text);
 $text = str_replace('[/big]', '', $text);
 return $text;
}
function showdate($format, $val) {
 return strftime($format, $val+(1*3600));
}
function phpentities($text) {
 $search = array("&", "\"", "'", "\\", "<", ">");
 $replace = array("&amp;", "&quot;", "&apos;", "&#92;", "&lt;", "&gt;");
 $text = str_replace($search, $replace, $text);
 return $text;
}
function stripinput($text) {
 if (QUOTES_GPC) $text = stripslashes($text);
 $search = array("\"", "'", "\\", '\"', "\'", "<", ">", "&nbsp;");
 $replace = array("&quot;", "&#39;", "&#92;", "&quot;", "&#39;", "&lt;", "&gt;", " ");
 $text = str_replace($search, $replace, $text);
 return $text;
}

$result = mysql_query("SELECT * FROM haze_news ORDER BY postdate DESC");
header("content-type:text/xml;charset=utf-8");

echo "<rss version='2.0'>\n";
echo "<channel>\n";
echo "<title>J Love's Blog RSS Feed</title>\n";
echo "<link>http://jlove.justinlove.net/</link>\n";
echo "<description>Justin Love's Personal Site - Blog : RSS Feed</description>\n";
while($row = mysql_fetch_array($result)) {
 $news_cat = mysql_fetch_array(mysql_query("SELECT news_cat_id, news_cat_title FROM haze_news_cats WHERE news_cat_id = ".$row['news_cat_id']));
 $cat_name = stripslashes($news_cat['news_cat_title']);
 $cat_id = $news_cat['news_cat_id'];
 echo "<item>\n";
 echo "<title>".str_replace(" & ", " &amp; ", stripinput($row['title']))."</title>\n";
 //echo "<title>".str_replace(" & ", " &amp; ", stripslashes($row['title']))."</title>\n";
 echo "<link>http://jlove.justinlove.net/page.php?id=8&amp;view=news&amp;news_id=".$row['id']."</link>\n";
 echo "<description>".phpentities(bbdecode($row['content']))."</description>\n";
 echo "<guid isPermaLink='true'>http://jlove.justinlove.net/page.php?id=8&amp;view=news&amp;news_id=".$row['id']."</guid>\n";
 echo "<category domain='http://jlove.justinlove.net/page.php?id=12&amp;cat_id=".$cat_id."'>".$cat_name."</category>\n";
 echo "<pubDate>".showdate("%a, %d %b %G %H:%M:%S EST", $row['postdate'])."</pubDate>\n";
 echo "</item>\n";
}
echo "</channel>\n";
echo "</rss>\n";
?>
Elitix Internet Technologies - World Play Online - My Blog

Last blog : phpHaze 1.59.1 in Development
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 5779
46271 credits
Members referred : 3
« Reply #2 on: Apr 18, 2007, 08:00:33 pm »
Looks like you are going better with php Method.

Bravo! Smiley
Trial and Error my two best teachers Cool
Join us @ facebook or twitter

Last blog : Butterfly Marketing 2.0
aka J Love
Community Supporter ?
Bill Gates is my home boy
*****
Gender: Male
Posts: 886
1148 credits
Members referred : 4
« Reply #3 on: Apr 18, 2007, 11:30:43 pm »
thanks Nik, i  have learned most of it from you and Wineo working in private, as well as closely studying the syntax of fusion and other popular CMS software .. i owe many thanks and credit to Webdigity! greatest web community i have yet to come across
Elitix Internet Technologies - World Play Online - My Blog

Last blog : phpHaze 1.59.1 in Development
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 5779
46271 credits
Members referred : 3
« Reply #4 on: Apr 19, 2007, 12:10:38 pm »
Quote from: Meth0d on Apr 18, 2007, 11:30:43 pm
thanks Nik, i  have learned most of it from you and Wineo working in private, as well as closely studying the syntax of fusion and other popular CMS software .. i owe many thanks and credit to Webdigity! greatest web community i have yet to come across

Nice to hear that. And that's how the open source community works.

Because before I helped you, someone helped me who got help from another guy, etc. etc etc Smiley
Trial and Error my two best teachers Cool
Join us @ facebook or twitter

Last blog : Butterfly Marketing 2.0
Trackback URI for this entry : http://www.webdigity.com/trackback.php?topic=6406
Tags : rss Bookmark this thread : Digg Del.icio.us Dzone more....

Pages: [1] Print 
Webdigity Webmaster Forums  >  Web Development  >  PhP
Topic: on-the-fly RSS 		« previous next »
Jump to:
User Area
Welcome, Guest. Please login or register.
Did you miss your activation email?
Feb 14, 2012, 01:15:05 pm





Login with username, password and session length

Donate to our community, and get a permanent link back to your site!

Donate to our community, and get a permanent link back to your site!


Forum Statistics
Total Posts: 59.827
Total Topics: 10.614
Total Members: 19.620
Tutorials : 58
Resources : 929
Designs : 395
Latest Member: nuruzzaman

67 Guests, 1 User online :

43 users online today:

Recent topics
Re: Do You Do "FORUM&q...
Re: 10 ways to promote your...
Re: Free and paid advertisi...
Re: list of DOFOLLOW FORUMS...
Re: what brand is your cell...
Re: File4Sharing.com- 50$/1...
hello everyone!
Re: 4 Super Steps To Making...

HumanWorks Network
Technology news
Webmaster articles
Sublime web directory
RSS Feed directory and viewer


Web Design Gallery · Whois Lookup · Pagerank · Tag Browsing · Lo-fi version · Syndication · Webmaster forum history · Advertise
Developed by HumanWorks © 2005 - 2012 Webdigity webmaster community · sublime directory
Webdigity Webmaster Forums | Powered by SMF 1.0.12. © 2001-2005, Lewis Media. All Rights Reserved.