1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to create RSS feed from database automatically?

Discussion in 'XML & RSS' started by affiliates4seo, Sep 25, 2009.

  1. #1
    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.
    SEMrush
    Thanks in advance for the replies,
     
    affiliates4seo, Sep 25, 2009 IP
    SEMrush
  2. theapparatus

    theapparatus Peon

    Messages:
    2,925
    Likes Received:
    119
    Best Answers:
    0
    Trophy Points:
    0
    #2
    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.
     
    theapparatus, Oct 16, 2009 IP
  3. LOD

    LOD Member

    Messages:
    319
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    35
    #3
    it is possible using some bit of php coding..
     
    LOD, Oct 18, 2009 IP
  4. audoeyop

    audoeyop Guest

    Messages:
    19
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    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...
     
    audoeyop, Oct 22, 2009 IP
  5. theapparatus

    theapparatus Peon

    Messages:
    2,925
    Likes Received:
    119
    Best Answers:
    0
    Trophy Points:
    0
    #5
    You may have noted that the poster is trying to create a feed, not manage one.

    Damn spammers.
     
    theapparatus, Oct 22, 2009 IP
  6. LOD

    LOD Member

    Messages:
    319
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    35
    #6
    go look for a php freelancer. they can help u out...
     
    LOD, Oct 23, 2009 IP
  7. mokimofiki

    mokimofiki Active Member

    Messages:
    443
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    80
    #7
    mokimofiki, Nov 21, 2009 IP
  8. trashcan

    trashcan Guest

    Messages:
    60
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Hire some1 whose good with PHP - some coding and u'll get what u want
     
    trashcan, Dec 3, 2009 IP
  9. Guruparthi

    Guruparthi Greenhorn

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    #9
    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
     
    Guruparthi, Aug 19, 2014 IP