Hello, I have looked at the tutorial for parsing xml on Kirupa, which is suffice at printing out contents held within an xml file, however, I need to be able to extract records in an xml and input them into a database. The data structure of my XML file is as follows:
<?xml version="1.0" encoding="UTF-8"?>
<load date="2/25/2008 2:54:01 PM">
<Data_Xchange name="BAG">
<record>
<parameter_list>
<parameter name="RO">1571358</parameter>
<parameter name="Status">IN PROCESS</parameter>
<parameter name="Tag">RFAN</parameter>
<parameter name="Year">2005</parameter>
</parameter_list>
</record>
</Data_Xchange>
</load>
What I’d like to do is be able to extract each record’s attributes and dump them into a corresponding MySQL table. Now, I know how to write the MySQL query to do that, but I don’t know how to use PHP to extract each attribute one record at a time. Can someone help me out on this please? Thanks!:hugegrin:
