xml to mysql database

[bimeldip]

is there any tutorial to insert xml data into mysql database?

[jkmyoung]

It depends on how your xml is formatted. Here's one example:
http://www.kitebird.com/articles/mysql-xml.html#TOC_5

[bimeldip]

hi,
sorry for being vague...but i was hoping someone could guide me to export xml data into mysql database using php
there aren't any tutorial that focus on exporting xml data into mysql using php
i jus need the someone to guide me...please do help...
i am getting more and more desperate as my assignment requires me to do so...but all i can do so far is display the xml files data onto a html page...i dunno how to continue on from there.
Please help

[jkmyoung]

Generally you'd need to write a PHP script to parse the XMLinto an array, generate SQL, and execute it on the database. Unfortunately, this isn't too simple a process for a beginner.

ITunes has a better tutorial for parsing with php:
http://developer.apple.com/internet/opensource/php.html

Link to xml parser functions: (this link would be confusing to start with)
http://us3.php.net/manual/en/ref.xml.php

I've heard Amazon also has a php, xml -> mySQL tutorial, although I can't find the link at the moment.