By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,831 Members | 2,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,831 IT Pros & Developers. It's quick & easy.

Automatically insert RSS feed into MySQL

P: 2
I am a new developer and am building an online store for a client. He currently downloads an XML document containing stock level information and i have written a script to update the database from this. To do this he must place the XML document onto the host server and run the script.

He has told me today that there is an RSS feed containting stock information and has asked if its possible to automatically update the database, daily, from this feed. I dont understand if this can be done directly from the feed or where to start if its possible. Any advice would be appreciated?
Feb 11 '08 #1
Share this Question
Share on Google+
4 Replies


jkmyoung
Expert 100+
P: 2,057
There's a variety of languages you can use. Please specify a preferred one.

1. Create an HTTP Request for the RSS feed.
2. Send the request to the RSS server, and get the rss feed back as a response.
3. Save the result to server.
4. Run the script.
Feb 11 '08 #2

P: 2
I would like to do this with PHP.
Feb 11 '08 #3

jkmyoung
Expert 100+
P: 2,057
Thread moved to php forum.
Feb 12 '08 #4

P: n/a
Its done here;

http://code.google.com/p/rssingest/

- its PHP code to parse RSS and insert into MySQL table - "just works" ;)
Oct 31 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.