Using PHP to parse an XML feed and commit to MySQL DB
My situation is this:
I am using a CMS to create a classifieds website.
A third party has created a web interface which users can use to create listings. That third party takes the listing information, and spits it out as an XML feed to various auction and classifieds websites.
As a person trying to take advantage of this tool, I need to find a way to take this XML feed, and parse it in such a way that it can be committed to a MySQL database.
I was thinking the best way of doing this would be to create a PHP script which pulls the feed, does some magic, and commits it to a MySQL DB.
I would sincerely appreciate any assistance which can be provided.