cant get values from xml with php

Question

I must be missing something simple here and it's driving me crazy.

I'm making a call to a web services api and getting back some xml:

<?xml version="1.0" encoding="utf-16"?>
<MTSMember xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <LastName>Smith</LastName>
  <FirstName>john</FirstName>
  <MemberNo>xxxxxxxx</MemberNo>
  <Club>None</Club>
  <JoinDate>2013-05-14</JoinDate> 
  <Email>[email protected]</Email>
</MTSMember>

I then need to process this xml to get the email address. but I'm just getting an empty result using the code below:

$xml_result = simplexml_load_string($xml_string_above);
echo $xml_result->MTSMember[0]->Email;

Can someone point me in the right direction. I've read through several other answers trying out various solutions, but can't seem to get it to work.

Edit: This was the last tutorial i tried out http://blog.teamtreehouse.com/how-to-parse-xml-with-php5

Mihai Iorga · Accepted Answer · 2013-09-06 08:31:13Z

2

That should be:

echo $xml_result->Email;

Because simplexml_load_string() is loading MTSMember as main SimpleXMLElement.

Codepad Example

answered Sep 6, 2013 at 8:31

Mihai Iorga

39.8k17 gold badges109 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

rmmoul Over a year ago

Hmmm. Seems to run fine on there, but still doesn't run on my local machine. I'm tailing the php error log, and it's not throwing any errors, it's just not giving me anything in the $xml_result.

Mihai Iorga Over a year ago

Make sure the xml is loaded.

rmmoul Over a year ago

the simplexml_load_string is returning 0; I'm walking through the run with xdebug. Do you mean loaded into the string, it is?

internals-in · Accepted Answer · 2013-09-06 09:15:15Z

0

Try this

$xml=new SimpleXMLElement($str);
$result=$xml->xpath('//Email');
foreach ($result as $Email)
  echo $Email . "<br>";

simply

$xml=new SimpleXMLElement($str);
echo $xml[0]->Email;

update:

The below just for your comment , the whole what i tried

$str='<?xml version="1.0" encoding="utf-8"?>
<MTSMember xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <LastName>Smith</LastName>
  <FirstName>john</FirstName>
  <MemberNo>xxxxxxxx</MemberNo>
  <Club>None</Club>
  <JoinDate>2013-05-14</JoinDate> 
  <Email>[email protected]</Email>
</MTSMember>';

$xml=new SimpleXMLElement($str);
echo $xml[0]->Email;
 //OR
$xml=new SimpleXMLElement($str);
$result=$xml->xpath('//Email');
foreach ($result as $Email)
  echo $Email . "<br>";

Be happy :)

edited Sep 6, 2013 at 9:15

answered Sep 6, 2013 at 8:46

internals-in

5,0762 gold badges23 silver badges38 bronze badges

4 Comments

rmmoul Over a year ago

When I pass the xml string to it, I get an error saying that 'String could not be parsed as XML'. Looks like xml to me, I'm at a loss for what is going on here.

rmmoul Over a year ago

Your update doesn't throw an error but nothing echo's for me. I run an echo 'xx'; before your script and an echo 'yy'; after and all i get is xxyy.

rmmoul Over a year ago

The update worked that time when I copied it. I'm going to try to run the xml from the api through. Thanks for you help!

rmmoul Over a year ago

your comment got me moving in the right direction. I had to do a search and replace on the xml to change the utf-16 to utf 8, and then I did a uft-8 function on it to be sure: $str = str_replace('encoding="utf-16"', 'encoding="utf-8"', $str); $xml=new SimpleXMLElement(utf8_encode($str));

LefterisL · Accepted Answer · 2013-09-06 09:22:57Z

0

This should work fine

$xml = new SimpleXMLElement($xml_string_above);

$dc = $xml->email;
echo $dc;

answered Sep 6, 2013 at 9:22

LefterisL

1,1534 gold badges18 silver badges37 bronze badges

Collectives™ on Stack Overflow

cant get values from xml with php

3 Answers 3

3 Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related