In php it is simple to create the rss feed. following one i create for my self and
sharing the code so that some one get benefit from it.
To create rss feed following are step by step code:
sharing the code so that some one get benefit from it.
To create rss feed following are step by step code:
DB table:
CREATE TABLE `data` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL, `description` text NOT NULL, `added_date` datetime NOT NULL, `image` varchar(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
Rss code(php):
<?php
error_reporting(E_ALL);
DEFINE ('USER', 'user name');
DEFINE ('PASSWORD', '');
DEFINE ('HOST', 'host name');
DEFINE ('DB_NAME', 'database name');
// Make the connnection and then select the database.
$link = @mysql_connect (HOST, USER, PASSWORD) OR die
('Could not connect to MySQL: ' . mysql_error() );
mysql_select_db (DB_NAME) OR die ('Could not select the database:
' . mysql_error() );
?>
<?php
header("Content-Type: application/xml; charset=utf-8");
$query = "SELECT * FROM data";
$result = mysql_query($query);
$items = '<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0"><channel>
<generator>FeedCreator 1.7.2</generator>
';
while($row = mysql_fetch_array($result))
{
// title
$title = htmlentities(strip_tags($row['title']));
//description
$description =htmlentities(strip_tags($row['description']));
//url
$link = 'http://localhost/detail.php?id='.$row['id'];
//image
$image='images/'.$row['image'];
$items .= '
<item>
<title>'. $title.'</title>
<link>'. $link .'</link>
<description><![CDATA[<img src=' . $image . ' hspace=0 vspace=0
border=0 align=left height="100" width="150" /> ' .
$description . ' ]]></description>
<pubDate>'.date("D, d M Y H:i:s O", strtotime($row['added_date']))
.'</pubDate>
</item>';
}
$items .= '</channel></rss>';
echo $items;
?>

