Jump to content

inserting xml data to mqsql


designergav

Recommended Posts

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.
Thanks
Gav  :)
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.