Parse XML file with PHP - Pls help!

Anon

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 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.

I have tried XMLPHP.org but it is a little beyond my XML knowledge I think....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>BBBBBBC1808</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>----------------------------------------------------------------ThanksJason
IT ManagerAustralia

Anon

here is how i did it to get the stock price for an intranet site.

<?php
$furl=fopen("http://quotes.nasdaq.com/quote.dll?page=xml&mode=stock&symbol=SSTI",'r');
$stock_info = stripslashes(fread($furl,200000));

	eregi("<todays-high-price>(.*)</todays-high-price>",$stock_info,$todays_high_price);
	eregi("<todays-low-price>(.*)</todays-low-price>",$stock_info,$todays_low_price);
	eregi("<last-sale-price>(.*)</last-sale-price>",$stock_info,$last_sale_price);
	eregi("<net-change-price>(.*)</net-change-price>",$stock_info,$net_change_price);
	eregi("<share-volume-qty>(.*)</share-volume-qty>",$stock_info,$share_volume_qty);

	if($todays_high_price[1] != "") {
		$stock_file = fopen('./stock_info.xhtml', 'w');
		fwrite($stock_file, "last:&nbsp;".$last_sale_price[1]."&nbsp;");
		if(substr($net_change_price[1], 0, 1) == "-") {
			fwrite($stock_file, "<font color='red'>");
		} else {
			fwrite($stock_file, "<font color='green'>+");
		}
		fwrite($stock_file, $net_change_price[1]."</font>&nbsp;&nbsp;");
		fwrite($stock_file, "high:&nbsp;".$todays_high_price[1]."&nbsp; low:&nbsp;".$todays_low_price[1]." &nbsp;vol:&nbsp;".$share_volume_qty[1]);
	}
	echo "done\n";

Anon

HI Michael,
Thanks for the example. The only problem with that sort of thing is that it is not really using the XML parsing capabilities of PHP and if something changes in the file you have to change the script to fix it. Whereas the stuff at phpxml.org actually runs over the XML file and pulls out the nodes from the file and uses that to create the script on the fly. You way will work and probably work very well but is a little backdoor.

Thanks heaps for the help..I may end up going that way in the end anyway 😉

Jason