I have a large "xml" file and I need some PHP code to parse it so I can test the input and put it in a mysql database.
The file is about 1.5Mb
The format, to me, seems to be a non-standard xml. A small sample follows:
<CTLocations xmlns="[login to view URL]">
<Country code="AL">
<Location Id="52400" Name="Sheraton Italia Square" Address="Square Italia Hotel Sheraton , Tirana" CityName="Tirana" CountryCode="AL" Airport="false"/>
<Location Id="7188" Name="Tirana Airport" Address="Tirana" CityName="Tirana" CountryCode="AL" Airport="true" AirportCode="TIA"/>
<Location Id="30768" Name="Tirana Downtown" Address="Piaza Circus, Tirana, 00000" CityName="Tirana" CountryCode="AL" Airport="false"/>
</Country>
<Country code="AD">
<Location Id="4650" Name="Escaldes" Address="AVDA. MIQUEL MATEU, 25, Andorra" CityName="Andorra" CountryCode="AD" Airport="false"/>
</Country>
<Country code="AO">
<Location Id="50460" Name="Luanda" Address="RUA TENENTE VALADIM 11, 1ST FL , Luanda" CityName="Luanda" CountryCode="AO" Airport="false"/>
<Location Id="50996" Name="Luanda - Airport" Address="4 de Fevereiro , Luanda" CityName="Luanda" CountryCode="AO" Airport="true" AirportCode="LAD"/>
</Country>
<Country code="AG">
<Location Id="6672" Name="Allegro Grand Pineapple Resort" Address="Allegro Grand Pineapple Resort, Long bay" CityName="Long bay" CountryCode="AG" Airport="false"/>
<Location Id="26536" Name="Jolly Beach Resort" Address="Jolly Beach Resort, Jolly Beach" CityName="Jolly Beach" CountryCode="AG" Airport="false"/>
<Location Id="4017" Name="[login to view URL] International Airport" Address="Golden Grove, St. John's, Leeword Islands" CityName="Leeword Islands" CountryCode="AG" Airport="true" AirportCode="ANU"/>
</Country>