Skip to main content
A
Anonymous
November 19, 2009
Question

RSS PHP/MySQL not working

  • November 19, 2009
  • 2 replies
  • 1316 views

I cannot figure out why this rss document is not working!? Thankx for any further help:)

<?php
header("Content-type: text/xml");
echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";

// set RSS version.
echo "
<rss version=\"2.0\">";
  
  // start the XML
  echo "
  <channel>
    <title>CMD - Visual Interface Design</title>
    <descritpion>Inspiratie</description>
    <link>http://vakgroep.cmd.hro.nl/vid</link>";
    
    // create a connection to your database.
    require("myconnection.php");
    
    // query database and select the last 10 entries.
    $data = mysql_query("SELECT * FROM ul_posts ORDER BY post_id DESC");
    while($row = mysql_fetch_array($data))
    {
    // convert database images data into actual image link
    $row[post_foto01] = str_replace("images/", "http://vakgroep.cmd.hro.nl/vid/fotos/", $row[post_foto01]);
    
    // continue with the 10 items to be included in the <item> section of the XML
    echo " 
     <item>
    <link>http://www.vakgroep.cmd.hro.nl/vid/tag.php?id=".$row[post_id]."</link>
    <guid isPermaLink=\"true\">http://www.vakgroep.cmd.hro.nl/vid/tag.php?id=".$row[post_id]."</guid>
    <title>".$row[post_title]."</title>
    <description>".substr($row[post_content1],0,150)."</description>
    </item>";
    }
    echo " 
     </channel>
     </rss>";

?>
This topic has been closed for replies.

2 replies

Waleed Barakat
Waleed Barakat
Known Participant
December 8, 2009

Hello,

Since long time ago i made this tutorial

:: How to Create a Dynamic RSS Feeds ::
Hello everyone... RSS feeds are very useful within sites, as they allow integrating for you website...

Please check it and it may help

__
Best Regards
Waleed Barakat
Developer-Online Creator and programmer

A
Anonymous
November 19, 2009
<?php
header("Content-type: text/xml");
echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";

// set RSS version.
echo "
<rss version=\"2.0\">";
  
  // start the XML
  echo "
  <channel>
    <title>My Title</title>
    <descritpion>Inspiratie</description>
    <link>http://mysite.nl</link>";
    
    // create a connection to your database.
    require("myconnection.php");
    
    // query database and select the last 10 entries.
    $data = mysql_query("SELECT * FROM ul_posts ORDER BY post_id DESC");
    while($row = mysql_fetch_array($data))
    {
    // convert database images data into actual image link
    $row[post_foto01] = str_replace("images/", "http://mysite.nl/fotos/", $row[post_foto01]);
    
    // continue with the 10 items to be included in the <item> section of the XML
    echo " 
     <item>
    <link>http://www.mysite/tag.php?id=".$row[post_id]."</link>
    <guid isPermaLink=\"true\">http://www.mysite.nl/tag.php?id=".$row[post_id]."</guid>
    <title>".$row[post_title]."</title>
    <description>".substr($row[post_content1],0,150)."</description>
    </item>";
    }
    echo " 
     </channel>
     </rss>";

?>
A
Anonymous
December 4, 2009

I am looking for a good tutorial for this RSS feed (PHP/ MySQL) I tried so many but nothing is working..

This last one at least shows that something is happening. But there is no content.

<?PHP

header("Content-type: text/xml");

$host = "localhost";
$user = "user";
$pass = "password";
$database = "db";

$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host.");
mysql_select_db($database, $linkID) or die("Could not find database.");

$query = "SELECT * FROM ul_posts ORDER BY post_id DESC LIMIT 5";
$resultID = mysql_query($query, $linkID) or die("Data not found.");

$xml_output = "<?xml version=\"1.0\"?>\n";
$xml_output = "<rss version=\"2.0\">\n";
$xml_output .= "<channel>\n";

for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){
    $row = mysql_fetch_assoc($resultID);
    $xml_output .= "\t<item>\n";
    $xml_output .= "\t\t\t<title>".$query["post_title"]."</title>\n";
    $xml_output .= "\t\t\t<enclosure url='http://vakgroep.cmd.hro.nl/vid/fotos/".$query['post_foto01']."' />\n";
    $xml_output .= "\t\t\t<link>http://vakgroep.cmd.hro.nl/vid/tag.php?id=".$query['post_id']."</link>\n";
    $xml_output .= "\t\t\t<content>".$query['post_content1']."</content>\n";
    $xml_output .= "\t</item>\n";
}

$xml_output .= "</channel>";
$xml_output .= "</rss>";

echo $xml_output;

?>


David_Powers
David_Powers
Inspiring
December 7, 2009

Ullitasch wrote:

I am looking for a good tutorial for this RSS feed (PHP/ MySQL) I tried so many but nothing is working..

This last one at least shows that something is happening. But there is no content.

It's not surprising. But you'll kick yourself when you realize the simple error in your code. You're using $query to try to display the database results. It should be $row.


for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){
    $row = mysql_fetch_assoc($resultID);
    $xml_output .= "\t<item>\n";
    $xml_output .= "\t\t\t<title>".$query["post_title"]."</title>\n";
    $xml_output .= "\t\t\t<enclosure url='http://vakgroep.cmd.hro.nl/vid/fotos/".$query['post_foto01']."' />\n";
    $xml_output .= "\t\t\t<link>http://vakgroep.cmd.hro.nl/vid/tag.php?id=".$query['post_id']."</l ink>\n";
    $xml_output .= "\t\t\t<content>".$query['post_content1']."</content>\n";
    $xml_output .= "\t</item>\n";
}

$xml_output .= "</channel>";
$xml_output .= "</rss>";

echo $xml_output;

?>

$query["post_title"] should be $row["post_title"] and so on.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices