PHP get data from multilevel tag colon XML file DOM PHP

Question

I have question , how to parsing data from multilevel tag colon XML file with dom PHP. Below is my XML sample data. I want to get data inside < transfer > and return as an array data

<soapenv:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <soapenv:Body>
    <HostCustomerResponse xmlns="http://xx.xx.xx.xx">
      <ns1:output xmlns:ns1="http://xx.xx.xx" xmlns:ns2="some:url" xsi:type="ns2:Output">
       <ns2:statusCode>00</ns2:statusCode>
       <ns2:statusMsg/>
       <ns2:txnResponseDateTime>20190625164236</ns2:txnResponseDateTime>
       <ns2:txnData>
         <transferRequest>
           <transfer>
             <transferId>123456789</transferId>
             <txnDate>123456789</txnDate>
             <debitAcctNo>123456789</debitAcctNo>
             <benAcctNo>123456789</benAcctNo>
          </transfer>
        </transferRequest>
      </ns2:txnData>
    </ns1:output>
   </HostCustomerResponse>
  </soapenv:Body>
</soapenv:Envelope>

and this result i want.

array(
  [transferID] => 123456789,
  [txnDate] => 123456789, 
  .....
)

How to convert xml into array in php?

Death-is-the-real-truth
– Death-is-the-real-truth

2019-06-26 05:53:31 +00:00
Commented Jun 26, 2019 at 5:53 — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Jun 26, 2019 at 5:53
How to convert this XML request into array in php?

Death-is-the-real-truth
– Death-is-the-real-truth

2019-06-26 05:54:24 +00:00
Commented Jun 26, 2019 at 5:54 — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Jun 26, 2019 at 5:54

Nigel Ren · Accepted Answer · 2019-06-26 06:15:21Z

1

Not sure if http://xx.xx.xx.xx is the real namespace in

<HostCustomerResponse xmlns="http://xx.xx.xx.xx">

but as this defines the namespace for any default elements (i.e. the ones your after) then you need to load the source XML and then register this namespace. Then you can use XPath to find the <transfer> element. You then just iterate through the elements within that ( using children() and add them into the output array...

$xml = simplexml_load_string($source);
$xml->registerXPathNamespace("d", "http://xx.xx.xx.xx");
$transfer = $xml->xpath("//d:transfer")[0];
$output = [];
foreach ( $transfer->children() as $key=> $value )  {
    $output[$key] = (string)$value;
}

Your original XML is missing the definition of the soapenv namespace, so I added that to make the XML correct...

<soapenv:Envelope xmlns:soapenv="http://soapev.com" 
        xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <soapenv:Body>
    <HostCustomerResponse xmlns="http://xx.xx.xx.xx">
      <ns1:output xmlns:ns1="http://xx.xx.xx" xmlns:ns2="some:url" xsi:type="ns2:Output">
       <ns2:statusCode>00</ns2:statusCode>
       <ns2:statusMsg/>
       <ns2:txnResponseDateTime>20190625164236</ns2:txnResponseDateTime>
       <ns2:txnData>
         <transferRequest>
           <transfer>
             <transferId>123456789</transferId>
             <txnDate>123456789</txnDate>
             <debitAcctNo>123456789</debitAcctNo>
             <benAcctNo>123456789</benAcctNo>
          </transfer>
        </transferRequest>
      </ns2:txnData>
    </ns1:output>
   </HostCustomerResponse>
  </soapenv:Body>
</soapenv:Envelope>

answered Jun 26, 2019 at 6:15

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

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

2 Comments

Belly Brata Over a year ago

It's work. Thank you so much ! But if I want to get data like value of <ns2:statusCode> , <ns2:statusMsg> etc, what should I change from the code ?

Nigel Ren Over a year ago

You can do a similar thing - register the ns2 namespace $xml->registerXPathNamespace("ns2", "some:url"); and then $xml->xpath("//ns2:statusMsg")[0] etc.

Rakesh Jakhar · Accepted Answer · 2019-06-26 06:05:02Z

0

You can get the transfer node by using the following code snippet

$response = preg_replace("/(<\/?)(\w+):([^>]*>)/", "$1$2$3", $soapXMLResult);
$xml      = new SimpleXMLElement($response);
$body     = $xml->xpath('//soapenvBody')[0];
$array    = json_decode(json_encode((array)$body), TRUE); 
$transfer = $array['HostCustomerResponse']['ns1output']['ns2txnData']['transferRequest']['transfer'];

https://3v4l.org/UKnZs

answered Jun 26, 2019 at 6:05

Rakesh Jakhar

6,4082 gold badges13 silver badges20 bronze badges

2 Comments

Belly Brata Over a year ago

Thanks. But when I try to another XML response, I get some error because the XML tag colon response dynamically change. Thanks dude btw

Rakesh Jakhar Over a year ago

@BellyBrata you can use array till index $array['HostCustomerResponse']['ns1output']['ns2txnData']['transferRequest'] , may be that helps OR any other array index which is common in all the response.

Collectives™ on Stack Overflow

PHP get data from multilevel tag colon XML file DOM PHP

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related