Previous? Top? Next

sql2rss v1.x Instructions

1) Unzip the contents of the sql2rss.zip file, and copy the extracted files to a folder on your webserver. The folder should be accessible from the Internet, like your regular webpages. In fact, the destination folder could be the same folder that you keep your webpages in.

2) In your browser, enter the full URL to the location of the sql2rss files, and run the install module (rss2sql_install.php).

Example: http://www.feedforall.com/sql2rss_install.php

This will bring up a page for the creation of the parameters needed to access your database. You will need the configuration file name later, you can keep the default of "sql2rss_DBconfig.inc.php".

3) In your browser, enter the full URL to the location of the sql2rss file, and use 'buildConfig' for a parameter.

Example: http://www.feedforall.com/sql2rss.php?buildConfig

This will bring up the configuration screen for sql2rss

4) On the configuration screen, enter the names of the two template files and a valid SQL query

5) Hit the 'Generate configuration data' button at the bottom of the screen.

6) The screen will refresh and display the contents of a new configuration file in your browser. You now need to highlight that data, and copy it to an editor on your local computer (like notepad).

7) Save the new configuration file locally, being sure to use .php for the extension.

8) Upload the configuration file, and put it into the same folder as your sql2rss.php file

9) Test sql2rss by entering its URL into your browser, and including your new config file as a parameter.
Example: http://www.feedforall.com/sql2rss.php?CONFIGFILE=mynewconfig.php

Channel Template:

The channel template file must be a valid RSS 2.0 feed with only the level tags, without and 's. It will be copied without doing any substitutions, with a and set to the current time.

Item Template:

The item template must contain a single valid RSS 2.0 . Any text between a pair of "~~~" will be substituted with the contents of the database field of that name, if any. There is one special tag "~~~RSSDATE(fieldname)~~~" which will take the contents of the database "fieldname", which must be a date, and convert it to a valid RFC 822 date format needed by RSS 2.0.