[phpXML] XML parsing

[nigel s. on b. of <it...@on...>]

Hi,
The Australian Music Database has just changed over to an XML based system
(PHP/MYSQL) which is great but they have implemented a reasonably complex
XML layout and I was wondering if your script could be tweaked to work with
it. I can run the script on it and it highlights all the TAGS as it should
but I want to be able to run a script over the XML file and have it pull the
data out and insert the data into a MYSQL db...all in one go.

A part of the XML file is below. I would like to pull out every entitiy into
a db so I need to parse the file and probably include some INSERT statements
etc so that it can throw everything into a db.


-----------------------------------------------------------
<AMROC>
<Version>1.0</Version>
<TITLES>
<CompanyCode>BBB</CompanyCode>
<TitleXref>BIGKBOST</TitleXref>
<CountryCode>AUS</CountryCode>
<Title>BIG KAHUNAS</Title>
<Artist>BOSTON BUN MUNCHERS, THE</Artist>
<GENRES>
<GenreCode>8</GenreCode>
</GENRES>
<Compilation>NO</Compilation>
<LabelCode>BLA</LabelCode>
<ProductTypeCode>A</ProductTypeCode>
<OriginalReleaseDate>28/07/1997</OriginalReleaseDate>
<PRODUCTS>
<CatalogNo>BBB</CatalogNo>
<ProductCountryCode>AUS</ProductCountryCode>
<MediaCode>21</MediaCode>
<PackageCode>49</PackageCode>
<ReleaseDate>28/07/1997</ReleaseDate>
<apn>9323190000188</apn>
<PRICES>
<PriceCode>BBB*BBB*C1808</PriceCode>
</PRICES>
<TRACKS>
<TrackXref>BUSTBOST</TrackXref>
<TrackNo>1</TrackNo>
<TrackLabelCode>BLA</TrackLabelCode>
<TrackTitle>BUS TRUCKIN </TrackTitle>
<TrackArtist>BOSTON BUN MUNCHERS, THE</TrackArtist>
<isrc></isrc>
</TRACKS>
<TRACKS>
<TrackXref>DESTBOST</TrackXref>
<TrackNo>2</TrackNo>
<TrackLabelCode>BLA</TrackLabelCode>
<TrackTitle>DESTINY</TrackTitle>
<TrackArtist>BOSTON BUN MUNCHERS, THE</TrackArtist>
<isrc></isrc>
</TRACKS>
<TRACKS>
<TrackXref>ITSABOST:1</TrackXref>
<TrackNo>3</TrackNo>
<TrackLabelCode>BLA</TrackLabelCode>
<TrackTitle>IT S A REAL THING</TrackTitle>
<TrackArtist>BOSTON BUN MUNCHERS, THE</TrackArtist>
<isrc></isrc>
</TRACKS>
<TRACKS>
<TrackXref>PRETBOST:1</TrackXref>
<TrackNo>4</TrackNo>
<TrackLabelCode>BLA</TrackLabelCode>
<TrackTitle>PRETTY BOY</TrackTitle>
<TrackArtist>BOSTON BUN MUNCHERS, THE</TrackArtist>
<isrc></isrc>
</TRACKS>
<TRACKS>
<TrackXref>STILBOST:2</TrackXref>
<TrackNo>5</TrackNo>
<TrackLabelCode>BLA</TrackLabelCode>
<TrackTitle>STILL RUNNIN</TrackTitle>
<TrackArtist>BOSTON BUN MUNCHERS, THE</TrackArtist>
<isrc></isrc>
</TRACKS>
<TRACKS>
<TrackXref>MOOCBOST</TrackXref>
<TrackNo>6</TrackNo>
<TrackLabelCode>BLA</TrackLabelCode>
<TrackTitle>MOO COW</TrackTitle>
<TrackArtist>BOSTON BUN MUNCHERS, THE</TrackArtist>
<isrc></isrc>
</TRACKS>
<TRACKS>
<TrackXref>BUSTBOST:1</TrackXref>
<TrackNo>7</TrackNo>
<TrackLabelCode>BLA</TrackLabelCode>
<TrackTitle>BUS TRUCKIN  REHEARSAL</TrackTitle>
<TrackArtist>BOSTON BUN MUNCHERS, THE</TrackArtist>
<isrc></isrc>
</TRACKS>
<TRACKS>
<TrackXref>MYDRBOST</TrackXref>
<TrackNo>8</TrackNo>
<TrackLabelCode>BLA</TrackLabelCode>
<TrackTitle>MY DREAM S OBSCENE</TrackTitle>
<TrackArtist>BOSTON BUN MUNCHERS, THE</TrackArtist>
<isrc></isrc>
</TRACKS>
<TRACKS>
<TrackXref>BOBSBOST</TrackXref>
<TrackNo>9</TrackNo>
<TrackLabelCode>BLA</TrackLabelCode>
<TrackTitle>BOB S RHAPSODY NO. 1</TrackTitle>
<TrackArtist>BOSTON BUN MUNCHERS, THE</TrackArtist>
<isrc></isrc>
</TRACKS>
<TRACKS>
<TrackXref>TAKEBOST:1</TrackXref>
<TrackNo>10</TrackNo>
<TrackLabelCode>BLA</TrackLabelCode>
<TrackTitle>TAKE THIS PILL</TrackTitle>
<TrackArtist>BOSTON BUN MUNCHERS, THE</TrackArtist>
<isrc></isrc>
</TRACKS>
<TRACKS>
<TrackXref>BENNBOST</TrackXref>
<TrackNo>11</TrackNo>
<TrackLabelCode>BLA</TrackLabelCode>
<TrackTitle>BENNY S BACKDOOR BONANZA</TrackTitle>
<TrackArtist>BOSTON BUN MUNCHERS, THE</TrackArtist>
<isrc></isrc>
</TRACKS>
<TRACKS>
<TrackXref>WEREBOST:1</TrackXref>
<TrackNo>12</TrackNo>
<TrackLabelCode>BLA</TrackLabelCode>
<TrackTitle>WE RE HERE FOREVER</TrackTitle>
<TrackArtist>BOSTON BUN MUNCHERS, THE</TrackArtist>
<isrc></isrc>
</TRACKS>
<TRACKS>
<TrackXref>BOBSBOST:1</TrackXref>
<TrackNo>13</TrackNo>
<TrackLabelCode>BLA</TrackLabelCode>
<TrackTitle>BOB S REPRISE</TrackTitle>
<TrackArtist>BOSTON BUN MUNCHERS, THE</TrackArtist>
<isrc></isrc>
</TRACKS>
<TRACKS>
<TrackXref>ATHEBOST</TrackXref>
<TrackNo>14</TrackNo>
<TrackLabelCode>BLA</TrackLabelCode>
<TrackTitle>A THEORY ON THE COLLECTIVE UNCONSCIOUS</TrackTitle>
<TrackArtist>BOSTON BUN MUNCHERS, THE</TrackArtist>
<isrc></isrc>
</TRACKS>
</PRODUCTS>
</TITLES>
</AMROC>

----------------------------------------------------------------


Kind Regards
Jason Savidge
IT Manager
One Stop Entertainment
Australia

--
This message has been sent through the <phpXML/> user discussion list. To unsubscribe, please visit https://sslsites.de/mailinglisten/user/us...@li.../