[RESOLVED] Dynamic Rss Feed Can't Populate data from database

polarexpress

I'm trying to automate my static xml feed using php. I'm following the script available at http://www.alihan.com.tr/blog/build-a-dynamic-rss-feed-using-phpmysql.html#comment-5103 to do the task but unfortunately the script can't populate data within the

<item> </item>

tag from the database.

<?php $db = new mysqli("localhost", "username", "password", "database"); ?>
<?php header('Content-type: text/xml'); ?>
<?php echo '<?xml version="1.0" encoding="iso-8859-1"?>';
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
<title>Your Website Title</title>
<description>A brief description about your website.</description>
<link>http://yourdomain.com/</link>  <copyright>Your Copyright Information</copyright>
<atom:link href="http://yourdomain.com/feed/" rel="self" type="application/rss+xml" />
<?php    $query = "SELECT * FROM `table` ORDER BY `delimiter` DESC LIMIT 0,15";
$results = $db->query($query);
$number = $results->num_rows;
for ($i = 1; $i <= $number; $i++) {
$row = $results->fetch_assoc();
$title = $row['title'];
$description = $row['description];
$link = $row['link'];
$date = date("r", $row['date']);
?>
<item>
<title><?php echo $title; ?></title>
<description><?php echo $description; ?></description>
<link><?php echo $link; ?></link>
<pubDate><?php echo $date; ?></pubDate>
</item>
<?php    }    ?>
</channel>
</rss><?php    $db->close();    ?>

My table has 5 columns filled with necessary data. These are id, title, description, link & date

Any idea?

polarexpress

I've just copied and pasted the code from the author's site. Yes, there is parse error there in the syntax but I'm using the correct syntax while uploading the script to the server.

The published page gives the right output. The exception is that it can't populate data from the database defined in the item tag.

<item>
<title><?php echo $title; ?></title>
<description><?php echo $description; ?></description>
<link><?php echo $link; ?></link>
<pubDate><?php echo $date; ?></pubDate>
</item>

polarexpress

At present data on the database server is available for two item nodes only as the script is still on trial but the published page doesn't print any dynamic data defined in the item node.

The feed page (site.com/rssfeed/index.php) at this moment is a plain one with proper channel output which visitors can subscribe if they want.

The prototype of the correct syntax is as following:

<?php $db = new mysqli("a", "b", "c", "d"); 
header('Content-type: text/xml'); 
echo '<?xml version="1.0" encoding="utf-8"?>'; ?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
<title>Test</title>
<description>Test Feed</description>
<link>http://site.com/rssfeed/</link>  

<copyright>Your Copyright Information</copyright>
<atom:link href="http://site.com/rssfeed/" rel="self" type="application/rss+xml" />
<?php    $query = "SELECT * FROM `table` ORDER BY `delimiter` DESC LIMIT 0,15";
$results = $db->query($query) or die(mysql_error());
$number = $results->num_rows;
for ($i = 1; $i <= $number; $i++) {
$row = $results->fetch_assoc();
$title = $row['title'];
$description = $row['description'];
$link = $row['link'];
$date = date("r", $row['date']);
?>
<item>
<title><?php echo $title; ?></title>
<description><?php echo $description; ?></description>
<link><?php echo $link; ?></link>
<pubDate><?php echo $date; ?></pubDate>
<?php /*?><guid><?php echo $link; ?></guid><?php */?>
</item>
<?php    }    ?>
</channel>
</rss>
<?php    $db->close();    ?>

To check sql syntax error I've used

or die(mysql_error());

statement in it but the syntax seems work fine.

Derokorian

Well considering you are connecting with the mysqli library it doesn't make any sense to use the mysql_error() function. Instead you should be using [man]mysqli_error[/man].

polarexpress

Yes, no error was generated by

or die(mysqli_error());

Derokorian

Not saying it should, I don't see any problem with the syntax of the query so unless the table name isn't really table and/or the column delimiter doesn't exist there is no reason the die statement would be reached. The correct usage in your situation would be

or die( $db->error() );

polarexpress

No error was even caused by

or die( $db->error() );

As I was trying several scripts on the same page I had forgotten to edit the sql syntax last time, but

this is really very strange that when I was attempting to publish the script by omitting the column delimiter (As it wasn't there in the database table) and column limit (both the columns id value 0,15 were absence in the database) last time from sql syntax I was encountering the same problem since I post it here.

Now surprisingly the problem has been resolved after I omitted column name & limit from the sql syntax.

Is the server ghosting?

Thanks for the reminder anyway.