Page 1 of 1

Need help XML parsing not working

Posted: Thu Jun 09, 2016 1:49 pm
by Tin
Hi Everyone,

Today, we found some issue with XML parsing can't parsing the text.

XML information for other system
[text]<response status="success"><result><entry><ip>200.33.255.60</ip><vsys>vsys1</vsys><type>Unknown</type><user>unknown</user><idle_timeout>2</idle_timeout><timeout>5</timeout></entry>
<entry><ip>200.33.0.205</ip><vsys>vsys1</vsys><type>AD</type><user>meepanda\itadmin</user><idle_timeout>453</idle_timeout><timeout>453</timeout></entry>
<entry><ip>200.33.0.210</ip><vsys>vsys1</vsys><type>AD</type><user>meepanda\itadmin</user><idle_timeout>1359</idle_timeout><timeout>1359</timeout></entry>
<entry><ip>200.33.0.211</ip><vsys>vsys1</vsys><type>AD</type><user>meepanda\hehajula</user><idle_timeout>2126</idle_timeout><timeout>2126</timeout></entry>
<entry><ip>200.33.0.64</ip><vsys>vsys1</vsys><type>AD</type><user>meepanda\itadmin</user><idle_timeout>454</idle_timeout><timeout>454</timeout></entry>
<entry><ip>200.33.0.47</ip><vsys>vsys1</vsys><type>AD</type><user>meepanda\itadmin</user><idle_timeout>1729</idle_timeout><timeout>1729</timeout></entry>
<entry><ip>200.33.4.167</ip><vsys>vsys1</vsys><type>Unknown</type><user>unknown</user><idle_timeout>1</idle_timeout><timeout>4</timeout></entry>
<entry><ip>200.33.0.232</ip><vsys>vsys1</vsys><type>AD</type><user>meepanda\itadmin</user><idle_timeout>2074</idle_timeout><timeout>2074</timeout></entry>
<entry><ip>200.33.0.16</ip><vsys>vsys1</vsys><type>AD</type><user>meepanda\itadmin</user><idle_timeout>2615</idle_timeout><timeout>2615</timeout></entry>
<entry><ip>200.33.0.8</ip><vsys>vsys1</vsys><type>AD</type><user>meepanda\geona</user><idle_timeout>624</idle_timeout><timeout>624</timeout></entry>
<entry><ip>200.33.0.49</ip><vsys>vsys1</vsys><type>AD</type><user>meepanda\ha007</user><idle_timeout>2658</idle_timeout><timeout>2658</timeout></entry>
<entry><ip>200.33.0.235</ip><vsys>vsys1</vsys><type>AD</type><user>meepanda\itadmin</user><idle_timeout>1222</idle_timeout><timeout>1222</timeout></entry>
<entry><ip>200.33.24.181</ip><vsys>vsys1</vsys><type>Unknown</type><user>unknown</user><idle_timeout>2</idle_timeout><timeout>5</timeout></entry>
<entry><ip>200.33.0.39</ip><vsys>vsys1</vsys><type>AD</type><user>meepanda\itguy</user><idle_timeout>1023</idle_timeout><timeout>1023</timeout></entry>
<count>14</count>
</result></response>[/text]

My php code

Code: Select all

<?php
			$loginxml_cmd = "<show><user><ip-user-mapping><all/></ip-user-mapping></user></show>&key=";
			$loginxml = "/api/?type=op&cmd=".$loginxml_cmd.$key_of_fw;
			$send_to_fw = $url.$loginxml;
			$send_to_fw = myreplace($send_to_fw);
			mycurl($send_to_fw);
			$xmlinfo = simplexml_load_file($send_to_fw);
			foreach ($xmlinfo->entry as $element) {
			echo 'IP:' $element->IP, ' Username: ', $element->user;
}
?>
Expect result
[text]IP:200.33.255.60 Username:Unknown
IP:200.33.0.205 Username:meepanda\itadmin
IP:200.33.0.210 Username:meepanda\itadmin
IP:200.33.0.211 Username:meepanda\hehajula
IP:200.33.0.64 Username:meepanda\itadmin
IP:200.33.0.47 Username:meepanda\itadmin
IP:200.33.4.167 Username:Unknown
IP:200.33.0.232 Username:meepanda\itadmin
IP:200.33.0.16 Username:meepanda\itadmin
IP:200.33.0.8 Username:meepanda\geona
IP:200.33.0.49 Username:meepanda\ha007
IP:200.33.0.235 Username:meepanda\itadmin
IP:200.33.24.181 Username:Unknown
IP:200.33.0.39 Username:meepanda\itguy[/text]

I am a newbie with PHP language.

Best regards,
Tin

Re: Need help XML parsing not working

Posted: Thu Jun 09, 2016 7:13 pm
by requinix
There's a <result> you have to go into before you can get <entry>s.

Code: Select all

foreach ($xmlinfo->result->entry as $element) {
I imagine you should be checking the status before doing anything, though?

Re: Need help XML parsing not working

Posted: Sat Jun 11, 2016 8:30 am
by Tin
Hi requinix,

Yes, You got that straight.

Thanks for your help.

I've solve my problem according to your assistance. :)