Hi All,
I am struggling with the PHP/XML parsing functions.
I have the following XML file:
<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<viewentries toplevelentries=\"61\">
<viewentry position=\"1\" unid=\"EA2F149D4A3EC7A580256AD40023A352\" noteid=\"A9A\" siblings=\"61\">
<entrydata columnnumber=\"0\" name=\"DocTitle\">
<text>14-19 CONSULATION</text></entrydata>
<entrydata columnnumber=\"1\" name=\"DocSummary\">
<text>For too many young people, the 14-19 age range has been a period of falling engagement in learning and rising disaffection.</text></entrydata>
<entrydata columnnumber=\"2\" name=\"$1\">
<datetime dst=\"true\">20010927T073438,15+01</datetime></entrydata>
<entrydata columnnumber=\"3\" name=\"$2\">
<numberlist><number>61952</number><number>26624</number></numberlist></entrydata>
<entrydata columnnumber=\"4\" name=\"$3\">
<textlist><text>14-19consultation.doc</text><text>14-19+cons+response.doc</text></textlist></entrydata>
<entrydata columnnumber=\"5\" name=\"Dockeywords\">
<text>14-19</text></entrydata>
</viewentry>
<viewentry position=\"2\" unid=\"CC320B95DCE614BB80256A4200249844\" noteid=\"A5E\" siblings=\"61\">
<entrydata columnnumber=\"0\" name=\"DocTitle\">
<text>Action Planning: Guidance for LEAs and Schools</text></entrydata>
<entrydata columnnumber=\"1\" name=\"DocSummary\">
<text></text></entrydata>
<entrydata columnnumber=\"2\" name=\"$1\">
<datetime dst=\"true\">20010831T154513,60+01</datetime></entrydata>
<entrydata columnnumber=\"3\" name=\"$2\">
<number>172702</number></entrydata>
<entrydata columnnumber=\"4\" name=\"$3\">
<text>actionplanningOfsted.pdf</text></entrydata>
<entrydata columnnumber=\"5\" name=\"Dockeywords\">
<textlist><text>OFSTED</text><text>Raising standards</text><text>School improvement</text></textlist></entrydata>
</viewentry>
<viewentry position=\"3\" unid=\"852462FF725DA42E802569F3003ED3E5\" noteid=\"9DE\" siblings=\"61\">
<entrydata columnnumber=\"0\" name=\"DocTitle\">
<text>Becta report - Primary Schools of the Future</text></entrydata>
<entrydata columnnumber=\"1\" name=\"DocSummary\">
<text></text></entrydata>
<entrydata columnnumber=\"2\" name=\"$1\">
<datetime dst=\"true\">20010831T154919,72+01</datetime></entrydata>
<entrydata columnnumber=\"3\" name=\"$2\">
<number>233668</number></entrydata>
<entrydata columnnumber=\"4\" name=\"$3\">
<text>primaryfuture.pdf</text></entrydata>
<entrydata columnnumber=\"5\" name=\"Dockeywords\">
<textlist><text>Effective Schools</text><text>ICT</text><text>Improvement</text><text>primary</text></textlist></entrydata>
</viewentry>
<viewentry position=\"4\" unid=\"FACE74CCCDDEDA0D802569C900364E5B\" noteid=\"ABA\" siblings=\"61\">
<entrydata columnnumber=\"0\" name=\"DocTitle\">
<text>Best Value Education PIs for 2001/2002</text></entrydata>
<entrydata columnnumber=\"1\" name=\"DocSummary\">
<text></text></entrydata>
<entrydata columnnumber=\"2\" name=\"$1\">
<datetime dst=\"true\">20010831T155212,63+01</datetime></entrydata>
<entrydata columnnumber=\"3\" name=\"$2\">
<number>152695</number></entrydata>
<entrydata columnnumber=\"4\" name=\"$3\">
<text>Best+VPIs+Education.pdf</text></entrydata>
<entrydata columnnumber=\"5\" name=\"Dockeywords\">
<textlist><text>Best Value</text><text>Perfromance Indicators</text></textlist></entrydata>
</viewentry>
I need to add this information to a MySQL database in the format:
ID | DocTitle | DocSummary | datetime | DocURL
1 | 14-19 CONSULATION | For too many young people, the 14-19 age range has been a period of falling engagement in learning and rising disaffection. | 20010927 | 14-19consultation.doc;19+cons+response.doc
2 | Action Planning: Guidance for LEAs and Schools | | 20010831 | actionplanningOfsted.pdf
etc...
Anyone got any tips/hints on the best way to do this?
Any help would be much appreciated.
TIA
Mike
