CODEWITHSUNDEEP
phpxml
user1054080
user1054080

Reputation:

How to get a xml tag with attribute name

I am trying to get the value (number 21.48) from the field "NMONTHLYINSTALMENT" with PHP simple_xml.

This is my PHP code and XML:

$xml->data->struct("var[@name='NMONTHLYINSTALMENT']")->number

<wddxPacket version='1.0'><header/>
    <data>
      <struct>
        <var name='UWEBSHOPID'><string>6FF1633B-6AE0-4AB6-A19E-D934B7DF783F</string></var>
        <var name='NMONTHLYINSTALMENT'><number>21.48</number></var>
        <var name='CCOMMAND'><string>GetMonthlyInstalment</string></var>
        <var name='NDURATION'><string>48</string></var>
        <var name='NPRICE'><string>825.89</string></var>
        <var name='COUTPUTTYPE'><string>XML</string></var>
      </struct>
    </data>
</wddxPacket>

I can not get it to work! Any help is much appriciated! Thanks!

Upvotes: 0

Views: 44

Answers (2)

MCHAppy
MCHAppy

Reputation: 1002

use DomDocument and xml path

$doc = new DomDocument;
$doc->Load("xmlfileName.xml");
$xpath = new DOMXPath($doc);
$path=$xpath->query("//data/struct/var[@name="NMONTHLYINSTALMENT"]/number")->item(0);
$doc->saveXML();

Upvotes: 0

H&#252;seyin BABAL
H&#252;seyin BABAL

Reputation: 15550

DEMO

You can use following;

<?php

$xml_str = <<< EOT
<wddxPacket version='1.0'><header/>
    <data>
      <struct>
        <var name='UWEBSHOPID'><string>6FF1633B-6AE0-4AB6-A19E-D934B7DF783F</string></var>
        <var name='NMONTHLYINSTALMENT'><number>21.48</number></var>
        <var name='CCOMMAND'><string>GetMonthlyInstalment</string></var>
        <var name='NDURATION'><string>48</string></var>
        <var name='NPRICE'><string>825.89</string></var>
        <var name='COUTPUTTYPE'><string>XML</string></var>
      </struct>
    </data>
</wddxPacket>
EOT;

$xml = simplexml_load_string($xml_str);
$result = $xml->xpath('//data/struct/var[@name="NMONTHLYINSTALMENT"]/number');

echo $result[0][0];

Upvotes: 1

Related Questions