I can not find a script of tutorial on how to do this... can anyone help??
Break it down into separate parts and do each part separately.
Step 1: Read XML. Step 2: Add to MySQL.
That's the hard bit out of the way.
Weedpacket wrote:Break it down into separate parts and do each part separately. Step 1: Read XML. Step 2: Add to MySQL. That's the hard bit out of the way.
Wow thanks for all the wonderful help.
Have a read of XML Parser functions lots of code examples there.
Your main problem will be storing the xml in the db because there is not generally any easy mapping of xml to relational structures, certainly not in mysql as yet. If xml is critical to your app then I would suggest using a different db like mssql 2005 or Oracle or DB2 that does offer xml storage and support; they are all issuing free copies these days
