designergav Posted January 4, 2007 Share Posted January 4, 2007 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.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.ThanksGav :) Link to comment https://forums.phpfreaks.com/topic/32851-inserting-xml-data-to-mqsql/ Share on other sites More sharing options...
fenway Posted January 5, 2007 Share Posted January 5, 2007 I think the newer versions support some sort of XML format... Link to comment https://forums.phpfreaks.com/topic/32851-inserting-xml-data-to-mqsql/#findComment-153286 Share on other sites More sharing options...
effigy Posted January 5, 2007 Share Posted January 5, 2007 [url=http://us3.php.net/manual/en/function.xpath-eval.php]This[/url] seems promising--look at the User Contributed Notes. Link to comment https://forums.phpfreaks.com/topic/32851-inserting-xml-data-to-mqsql/#findComment-153588 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.