PHP > XML into MySQL

[condoug]

Hi all,

I have done some hunting around and I am having trouble trying to find a solution to my problem.

I need to be able to parse and insert data into MySQL from an XML file via PHP. My XML File (or a snippet of it is below)

<?xml version="1.0" encoding="iso-8859-1"?>
<assessment>
	<candidatedetails>
		<candidateid>126790</candidateid>
		<candidatenumber>123456789</candidatenumber>
		<firstname>Joe</firstname>
		<lastname>Bloggs</lastname>
	</candidatedetails>
	<headerdetails>
		<examname>Level 1 Driving School</examname>
		<scheduleid>1234</scheduleid>
	</headerdetails>
	<question>
		<number>1</number>
		<answer>A</answer>
		<timecheck>1234</timecheck>
	</question>
	<question>
		<number>2</number>
		<answer>B</answer>
		<timecheck>1235</timecheck>
	</question>
	<question>
		<number>3</number>
		<answer>C</answer>
		<timecheck>1236</timecheck>
	</question>
	<question>
		<number>4</number>
		<answer>D</answer>
		<timecheck>1237</timecheck>
	</question>
	<question>
		<number>5</number>
		<answer>C</answer>
		<timecheck>1238</timecheck>
	</question>
</assessment>

Basically i need to be able read and insert the data found within the <question></question> nodes into a mysql table once the XML file is uploaded.

I have seen exmaples for SimpleXML but my server is only running PHP4. Doe someone have any good examples or explanation of how the above can be achieved?

Many Thanks

[NogDog]

DOM XML Functions are probably the way to go with PHP 4.

[condoug]

Hi NogDog

I have just managed to put the following together to get my XML document into PHP:

	$data 		= 	implode("", file("rcsfile.xml"));
	$parser 	= 	xml_parser_create();
	xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 0);
	xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1);
	$result		=	xml_parse_into_struct($parser, $data, $values, $tags);
	xml_parser_free($parser);

And I can reference the values as such:

$firstname			=	$values[4][value];

However, the questions bit is a bit tricky and would like to know how i could loop through each question node and retrieve the <number>, <answer> and <timecheck> values so I could insert them into a MYSQL table.

How would this be achieved?

Thanks for reading.