Hey Guys... i very new to parsing XML with php and i'm looking for the best way to do some simple parsing.
I have the following xml code (this is actually just held in a string, not an actual xml file)..
and what i need to do with this code is loop through it and update a database...
are there any suggestions to the best way to go about doing this?
Thanks,
~Jamie
**EDIT: if it helps any i'm using php 4.4.4
I have the following xml code (this is actually just held in a string, not an actual xml file)..
Code:
<?xml version="1.0" encoding="iso-8859-1"?> <List> <ListOrder num="1"> <Id>546</Id> <Value>1</Value> </ListOrder> <ListOrder num="1"> <Id>105</Id> <Value>2</Value> </ListOrder> <ListOrder num="2"> <Id>754</Id> <Value>3</Value> </ListOrder> </List>
Code:
Update tblApplications SET ListOrder = ***XML VALUE *** WHERE ApplicationID = ***XML ID ***
Thanks,
~Jamie
**EDIT: if it helps any i'm using php 4.4.4
Comment