View Full Version : extracting xml data to put in mysql table

01-04-2007, 04:00 PM
Hi all. Just when I think I've learnt enough to cope another comes something else. I'm just a designer but everyone seems to think I can develop. Which is ok. Mostly. This though is causing me to go a bit doolally.:confused:

I've got an xml file that contains amongst others the element <currency> which contains these childs. <cname><csymbol><crate>. There are nearly 200 <currency>. I need to use XPath (although I've no idea how ) to extract those values so that I can insert the whole lot into a mysql db. I will then call the relevant data back to my webpages when required.

The xml file will be purchased as a licensed file so I can't touch it in any way or move it so I need to refer to it where it is. I'll need to run cron job or windows scheduler to run my script on a daily basis.

Any help would be great as I'm currently having to manually update my fields.
Oh and my web server is only running php4.*:eek:

01-04-2007, 06:53 PM
This can be done with php version 4.x using the libxml-2.4.14 library. I'm in class right now, so I will post later an example of how to do this, but you can feel free to take a look at the DOM XML (http://ca3.php.net/manual/en/ref.domxml.php) functions in the meantime.