How to parse rss new feeds, using php and store in database

Question

I want to parse information in:

http://feeds.informationweek.com/infoweek/news http://feeds.news.com.au/public/rss/2.0/fs_breaking_news_13.xml http://rss.cnn.com/rss/cnn_topstories.rss

using php.

And save the info in my database as: Headline, time, Description, Category

Also category, is show when i click on the link, it shows me the category of article (say world, travel, sports etc)

Plz help me with this issue.

I have never done parsing before.

Zeeshan

Answer 1

If you do not know PHP + MySQL, please read about it first. As for the parsing you got plenty of options:

• MagPieRSS
• SimplePie
• PHP DOM

Answer 2

Use SimpleXML for the parsing. From there, it should be pretty straight forward to loop over the items and insert the values into your database.