[RESOLVED] Can't read this xml back

[mikeschroeder]

Right now I'm trying to integrate with a 3rd party API at this point everything is working great. Except i'm having alot of trouble reading this XML back into an array.

The XML looks like this:

<system>
<status>success</status>
<resultlist>
<resultlist id='1'>
	<result id='URL'>http://www.osha.gov/Publications/influenza_pandemic.html</result>
	<result id='Last Click Date'>2007-08-03 09:02:03</result>
	<result id='Number of Click'>7</result>
	<result id='Number of Unique Click'>7</result>
</resultlist>
<resultlist id='2'>
	<result id='URL'>http://www.gain.net/eweb/DynamicPage.aspx?webcode=lower35&amp;wps_key=C48C7D6E-2EA0-44D8-B7AE-81CCC3770080</result>
	<result id='Last Click Date'>2007-08-03 09:43:21</result>
	<result id='Number of Click'>5</result>
	<result id='Number of Unique Click'>4</result>
</resultlist>
<resultlist id='3'>
	<result id='URL'>http://www.senate.gov/~govt-aff/index.cfm?Fuseaction=Hearings.Detail</result>
	<result id='Last Click Date'>2007-08-03 15:51:03</result>
	<result id='Number of Click'>4</result>
	<result id='Number of Unique Click'>2</result>
</resultlist>
<resultlist id='4'>
	<result id='URL'>http://capwiz.com/printing/issues/bills/?billtype=H.R.&amp;billnumb=1127&amp;congress=110</result>'
	<result id='Last Click Date'>2007-08-03 09:11:48</result>
	<result id='Number of Click'>2</result>
	<result id='Number of Unique Click'>2</result>
</resultlist>
<resultlist id='5'>
	<result id='URL'>http://www.printpaconline.org</result>
	<result id='Last Click Date'>2007-08-03 11:01:38</result>
	<result id='Number of Click'>2</result>
	<result id='Number of Unique Click'>2</result>
</resultlist>
<resultlist id='6'>
	<result id='URL'>http://www.treas.gov/press/releases/reports/otptaxgapstrategy final.pdf</result>
	<result id='Last Click Date'>2007-08-06 07:17:22</result>
	<result id='Number of Click'>1</result>
	<result id='Number of Unique Click'>1</result>
</resultlist>
<resultlist id='7'>
	<result id='URL'>http://www.gain.net</result>
	<result id='Last Click Date'>2007-08-03 10:53:41</result>
	<result id='Number of Click'>1</result>
	<result id='Number of Unique Click'>1</result>
</resultlist>
<resultlist id='8'>
	<result id='URL'>http://www.senate.gov/~govt-aff/index.cfm?Fuseaction=Hearings.Detail&amp;HearingID=476</result>
	<result id='Last Click Date'>2007-08-03 09:03:32</result>
	<result id='Number of Click'>1</result>
	<result id='Number of Unique Click'>1</result>
</resultlist>
</resultlist>
</system>

I'm in a php5 environment so I have DOM and SimpleXML at my disposal. I've tried both in the ways I "thought" it should work but have failed miserably to this point. It has to be easier then this.

the result I'm looking for is

$array[1][1] = resultlist 1, result URL
$array[1][2] = resultlist 1, result Last click Date
$array[1][3] = resultlist 1, result Number of Clicks
$array[1][4] = resultlist 1, result Number of Unique Clicks


$array[2][1]
$array[2][2]
$array[2][3]
$array[2][4]

or something like that.

Hopefully someone else can shed some light on this as I'm stumped.

Thanks,
Mike

[mikeschroeder]

well low and behold i put my head back to the grindstone and answered this myself.

//$response = xml string

	$xml = new DOMDocument('1.0','utf-8');
	$xml->loadXML($response);

	$xpath = new DOMXPath($xml);
	$resultlist = $xpath->evaluate('/system/resultlist/resultlist');

	for($i=1; $i<=$resultlist->length; $i++){

		$result = $xpath->evaluate('/system/resultlist/resultlist[@id='.$i.']/result');

		for($a=0; $a<$result->length; $a++){

			$clicks[$i][$a] = $result->item($a)->nodeValue;

		}
	}