Menu

Adding rss feeds to a MySQL database!

2010-04-11
2013-04-15
  • Ricardo Concha

    Ricardo Concha - 2010-04-11

    Hi

    I'm wondering if its possible to add the capabilty od Add/Modify - Delete rss (feedname and url) feeds from a CMS … adding feeds into a MySQL file … I created one with a table named rss and this structure:

    CREATE TABLE `rss` (
      `id` int(11) NOT NULL auto_increment,
      `feedname` varchar(200) NOT NULL,
      `url` varchar(150) NOT NULL,
      PRIMARY KEY  (`id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

    Now the goal of this is create a php file to generate automatically the feeds.xml file

    Can you help me with this, please?

    Thanks in advance!

    Ricardo

     
  • guywmustang

    guywmustang - 2010-07-02

    I've added a new version of the software which allows you to generate the feeds file from a database.  You'll have to recreate the database as it is different in my structure than yours, I've added a "category" column, and the types are different (all text).

    Let me know if this'll work for you.

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.