Data from XML to MYSQL using PHP
Posted: Tue May 31, 2005 11:16 pm
Hey, I've not seen this on the board but I need help to create a function that takes data from an XML file and inserts it into a mysql database using PHP.
The data looks like this (automatically created by MP3 Collector):
I hope someone can help me, I can't seem to figure this one out.
- Kevin
The data looks like this (automatically created by MP3 Collector):
Code: Select all
<?xml version="e;1.0"e;?>
<mp3info creationdate="e;6/2/2005 12:11:59 AM"e;><mp3metadata><field name="e;Index"e; label="e;Index"e;/><field name="e;Track Index"e; label="e;Track Index"e;/><field name="e;Disk Index"e; label="e;Disk Index"e;/><field name="e;Track Artist"e; label="e;Track Artist"e;/><field name="e;Album Artist"e; label="e;Album Artist"e;/><field name="e;Title"e; label="e;Title"e;/><field name="e;Title Sort"e; label="e;Title Sort"e;/><field name="e;Title The"e; label="e;Title The"e;/><field name="e;Year"e; label="e;Year"e;/><field name="e;Album"e; label="e;Album"e;/><field name="e;Album Title"e; label="e;Album Title"e;/><field name="e;Sub Title"e; label="e;Sub Title"e;/><field name="e;Genre"e; label="e;Genre"e;/><field name="e;Copyright"e; label="e;Copyright"e;/><field name="e;Label"e; label="e;Label"e;/><field name="e;Notes"e; label="e;Notes"e;/><field name="e;Track Artist"e; label="e;Track Artist"e;/><field name="e;Genre"e; label="e;Genre"e;/><field name="e;Label"e; label="e;Label"e;/><field name="e;Year"e; label="e;Year"e;/><field name="e;Album"e; label="e;Album"e;/><field name="e;Album Artist"e; label="e;Album Artist"e;/><field name="e;Playlist Index"e; label="e;Playlist Index"e;/><field name="e;Playlist Title"e; label="e;Playlist Title"e;/><field name="e;Original Artist"e; label="e;Original Artist"e;/><field name="e;Composer"e; label="e;Composer"e;/><field name="e;Lyricist"e; label="e;Lyricist"e;/><field name="e;Orchestra"e; label="e;Orchestra"e;/><field name="e;Conductor"e; label="e;Conductor"e;/><field name="e;Composer"e; label="e;Composer"e;/><field name="e;Lyricist"e; label="e;Lyricist"e;/><field name="e;Orchestra"e; label="e;Orchestra"e;/><field name="e;Conductor"e; label="e;Conductor"e;/><field name="e;Original Artist"e; label="e;Original Artist"e;/><field name="e;Encoded By"e; label="e;Encoded By"e;/><field name="e;BPM"e; label="e;BPM"e;/><field name="e;Lyrics"e; label="e;Lyrics"e;/><field name="e;Tempo"e; label="e;Tempo"e;/><field name="e;Mood"e; label="e;Mood"e;/><field name="e;Situation"e; label="e;Situation"e;/><field name="e;Preference"e; label="e;Preference"e;/><field name="e;Biography"e; label="e;Biography"e;/><field name="e;Tempo"e; label="e;Tempo"e;/><field name="e;Mood"e; label="e;Mood"e;/><field name="e;Situation"e; label="e;Situation"e;/><field name="e;Preference"e; label="e;Preference"e;/><field name="e;Audio URL"e; label="e;Audio URL"e;/><field name="e;Artist URL"e; label="e;Artist URL"e;/><field name="e;General URL"e; label="e;General URL"e;/><field name="e;Location"e; label="e;Location"e;/><field name="e;Filename"e; label="e;Filename"e;/><field name="e;Filepath"e; label="e;Filepath"e;/><field name="e;Size"e; label="e;Size"e;/><field name="e;Length"e; label="e;Length"e;/><field name="e;Channels"e; label="e;Channels"e;/><field name="e;Bitrate"e; label="e;Bitrate"e;/><field name="e;SampleRate"e; label="e;SampleRate"e;/><field name="e;VBR"e; label="e;VBR"e;/><field name="e;Filename Format"e; label="e;Filename Format"e;/><field name="e;Format"e; label="e;Format"e;/><field name="e;Tags"e; label="e;Tags"e;/><field name="e;New Filename"e; label="e;New Filename"e;/><field name="e;ID"e; label="e;ID"e;/></mp3metadata><mp3list><mp3><filepath>\Trinity_-_Wonderful-Promo-CDM-2005-TN\03-trinity-wonderful_original_mix-tn.mp3</filepath><filename>03-trinity-wonderful_original_mix-tn.mp3</filename><artist><displayname>Trinity</displayname></artist><title>Wonderful Original Mix</title><album><displayname>Wonderful</displayname></album><year><displayname>2005</displayname></year><genre><displayname>Dance</displayname></genre><notes>- TRANCE NATiON -</notes><size>4,947 KB</size><length>04:26</length><channels>Joint Stereo</channels><bitrate>152</bitrate><samplerate>44100</samplerate><vbr>Yes</vbr><tags>ID3v1</tags></mp3><mp3><filepath>Trinity_-_Wonderful-Promo-CDM-2005-TN\04-trinity-wonderful_alternative_mix-tn.mp3</filepath><filename>04-trinity-wonderful_alternative_mix-tn.mp3</filename><artist><displayname>Trinity</displayname></artist><title>Wonderful Alternative Mix</title><album><displayname>Wonderful</displayname></album><year><displayname>2005</displayname></year><genre><displayname>Dance</displayname></genre><notes>- TRANCE NATiON -</notes><size>5,688 KB</size><length>05:23</length><channels>Joint Stereo</channels><bitrate>144</bitrate><samplerate>44100</samplerate><vbr>Yes</vbr><tags>ID3v1</tags></mp3><mp3><filepath>\1-trinity-wonderful_radio_edit-tn.mp3</filepath><filename>01-trinity-wonderful_radio_edit-tn.mp3</filename><artist><displayname>Trinity</displayname></artist><title>Wonderful Radio Edit</title><album><displayname>Wonderful</displayname></album><year><displayname>2005</displayname></year><genre><displayname>Dance</displayname></genre><notes>- TRANCE NATiON -</notes><size>4,017 KB</size><length>03:37</length><channels>Joint Stereo</channels><bitrate>151</bitrate><samplerate>44100</samplerate><vbr>Yes</vbr><tags>ID3v1</tags></mp3><mp3><filepath>\02-trinity-wonderful_extended_mix-tn.mp3</filepath><filename>02-trinity-wonderful_extended_mix-tn.mp3</filename><artist><displayname>Trinity</displayname></artist><title>Wonderful Extended Mix</title><album><displayname>Wonderful</displayname></album><year><displayname>2005</displayname></year><genre><displayname>Dance</displayname></genre><notes>- TRANCE NATiON -</notes><size>5,356 KB</size><length>04:50</length><channels>Joint Stereo</channels><bitrate>151</bitrate><samplerate>44100</samplerate><vbr>Yes</vbr><tags>ID3v1</tags></mp3></mp3list></mp3info>- Kevin