Hi! > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > they have implemented a > reasonably complex > XML layout and I was wondering if your script could be > tweaked to work with > it. 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. > Look at http://www.kzar.net/testxml.php for a working exwemple. You can insert datas in a db instead of displaying them. The script can be found at http://www.kzar.net/source.php?p=/testxml.php Regards, Florent Gilles. > Sent: Thursday, August 16, 2001 5:17 AM > To: [EMAIL PROTECTED] > Subject: [phpXML] XML parsing > > > Hi, > 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:[EMAIL PROTECTED]/ > -- This message has been sent through the <phpXML/> user discussion list. To unsubscribe, please visit https:[EMAIL PROTECTED]/
