How to create RSS feed from database automatically?

Hi,

We have online store. You know, it is very hard to create and maintain a rss feed for online stores. So, we are looking to created a dynamic rss feed which retrieves the all product information from the database.

And the feed must be update automatically, along with the products.

Thanks in advance for the replies,

 

Does the online store run on any sort of software currently? There may already be a solution to provide an RSS feed. If yes, the specific software would be helpful.

 

it is possible using some bit of php coding..

 

If you had somebody to simultaneously manage this feed... you could use the web service on pulssr.com to host an RSS feed for your store...

 

You may have noted that the poster is trying to create a feed, not manage one.

Damn spammers.

 

go look for a php freelancer. they can help u out...

 

You can look at the following thread to learn how to create an rss feed I had the same problem but after alot of frusteation I figured it out.

Example:
http://www.mofikiworldwide.com/rssfeed.php

How to do it can be found in this thread
http://forums.digitalpoint.com/showthread.php?t=1576447

 

Hire some1 whose good with PHP - some coding and u'll get what u want

 

Yes you can done it using PHP and MySQL
The Sample PHP code is below

<?php
header("Content-Type: application/rss+xml; charset=ISO-8859-1");
echo '<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?>
<?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?>
<rss
xmlns:content="http://purl.org/rss/1.0/modules/content/"
xmlns:wfw="http://wellformedweb.org/CommentAPI/"
xmlns:dc="http://purl.org/dc/elements/1.1/"
xmlns:atom="http://www.w3.org/2005/Atom"
xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
    xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0"
version="2.0">
<channel>
<title>Phponwebsites</title>
<link>http://www.phponwebsites.com</link>
<description>Phponwebsites about php related topics like .htaccess, robots.txt, mysql, jquery, ajax, js and also php for php developers</description>';
       $connection = @mysql_connect('localhost', 'root', '') or die(mysql_error());
       mysql_select_db('new')  or die (mysql_error());
       $query = "SELECT * FROM links order by id desc";
       $rss = mysql_query($query) or die (mysql_error());
       $ImgPath='http://2.bp.blogspot.com/-vwl4cGyoDPM/UqKklyTGE-I/AAAAAAAAALI/iOipE7-PhAM/s1600/logo5.png';
       while($row=mysql_fetch_array($rss)){
       echo '
      <item>
      <title>'.$row['name'].'</title>
      <link>'.$row['link'].'</link> 
      <content:encoded>
      <![CDATA[<p align="left">
          <a href="'.$row['link'].'"><img style="background-image: none; " border="0" src="'.$ImgPath.'" />    </a></p>]]>
       </content:encoded>
       <description>'.$row['description'].'</description></item>';
      }
      echo '</channel>
</rss>';
?>

Code (markup):

Reference: http://www.phponwebsites.com/2014/08/php-mysql-create-rss-feed-dynamically.html