You are here:  » Storing an XML Feed in a database


Storing an XML Feed in a database

Submitted by shawnwalters on Tue, 2007-07-17 07:10 in

Hi,

I have a news feed that I use magicparser with and I would like to store the news stories that it pulls from the feed into a database by day. Then just have a page of links that are months, then when you click on the month, it shows all the days and you can click on that day to see what news stories happened that day. Does that make sense? Then just being able to search by keyword. Is this something I can pay to have coded?

Thanks,
Shawn

Submitted by support on Tue, 2007-07-17 08:48

Hi Shawn,

Yes - that does make sense, although i'm afraid I don't have any availability for custom work at the moment (i'll certainly let you know if that changes though). Having said that, it does sound like a relatively straight forward coding job for someone familiar with PHP and MySQL - in particular if you already have the parsing code in place that they can simply bolt it on to.

There are several forum topics that cover inserting records from an XML feed into MySQL - so it might be worth checking through the results of the following query in case there are examples that could be brought together - go to the forum homepage and do a search on magicparser.com for MySQL as this brings up several examples!

Cheers,
David.