How to get value from Xml attributes using php

Question

I am trying to get value from xml attributes. But it returns only 3 values "resCode,message,Pid" not able to get "orderno,orderdate". This is my xml value which is coming in $data variable.

 <ns2:orderresponse xmlns="http://vo.services.order.com/base"  xmlns:ns2="http://vo.services.order.com/createorder/response">
 <rescode>111</rescode>
 <messages><message>Success</message></messages>
 <Pid>4555544</Pid>
  <ns2:orderno>A2131589</ns2:orderno>
 <ns2:orderdate>20171109</ns2:orderdate>
 </ns2:orderresponse>

I am using this to get xml attributes value.

 $xmlData = new SimpleXMLElement($data);    
 print_r(xml2array($xmlData));

Have you ever taken a look at the docs of SimpleXMLElement to see how it works? — B001ᛦ
– B001ᛦ, Commented Nov 9, 2017 at 10:12

Ravi Sharma · Accepted Answer · 2017-11-09 10:15:40Z

1

yes here is another way to get xml content look below example :-

<?php
    $mystring=' <ns2:orderresponse xmlns="http://vo.services.order.com/base"  xmlns:ns2="http://vo.services.order.com/createorder/response">
     <rescode>111</rescode>
     <messages><message>Success</message></messages>
     <Pid>4555544</Pid>
      <ns2:orderno>A2131589</ns2:orderno>
     <ns2:orderdate>20171109</ns2:orderdate>
     </ns2:orderresponse>';

    $xml = simplexml_load_string($mystring, "SimpleXMLElement", LIBXML_NOCDATA);
    $json = json_encode($xml);
    $final_array = json_decode($json,TRUE);
    print_r($array);
?>

answered Nov 9, 2017 at 10:15

Ravi Sharma

4872 silver badges18 bronze badges

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

1 Comment

testingexpert Over a year ago

It's also returns only 3 parameters in array Array ( [resCode] => 000 [messages] => Array ( [message] => Success ) [pId] => 27231042 )

Nigel Ren · Accepted Answer · 2017-11-14 09:32:17Z

0

As some elements include namespaces, they don't work well with the simple json encode bit. As a quick way of just adding in those extra values, I've done...

<?php
error_reporting ( E_ALL );
ini_set ( 'display_errors', 1 );

$data  = <<<XML
 <ns2:orderresponse xmlns="http://vo.services.order.com/base"  xmlns:ns2="http://vo.services.order.com/createorder/response">
 <rescode>111</rescode>
 <messages><message>Success</message></messages>
 <Pid>4555544</Pid>
  <ns2:orderno>A2131589</ns2:orderno>
 <ns2:orderdate>20171109</ns2:orderdate>
 </ns2:orderresponse>
XML;

$xmlData = new SimpleXMLElement($data);
$json = json_encode($xmlData);
$final = json_decode($json,TRUE);

foreach ( $xmlData->children("http://vo.services.order.com/createorder/response") as $ns)    {
    $final[$ns->getName()] = (string)$ns;
}

print_r($final);

This gives...

Array
(
    [rescode] => 111
    [messages] => Array
        (
            [message] => Success
        )

    [Pid] => 4555544
    [orderno] => A2131589
    [orderdate] => 20171109
)

edited Nov 14, 2017 at 9:32

answered Nov 9, 2017 at 13:26

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

2 Comments

testingexpert Over a year ago

I have tried this also but it's not working. Returns only 3 parameters in array

Nigel Ren Over a year ago

I've just added the output and it shows all the data I would expect.

Collectives™ on Stack Overflow

How to get value from Xml attributes using php

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related