PHP - Get value from xml file

Question

Using the following xml: http://www.bnr.ro/nbrfxrates.xml

How can I get the EUR value?

Been trying like this ... but no luck.

            $xmlDoc = new DOMDocument();
            $xmlDoc->load('http://www.bnr.ro/nbrfxrates.xml');

            $searchNode = $xmlDoc->getElementsByTagName("Cube");

            var_dump($searchNode);

            foreach ($searchNode as $searchNode) {
                $valueID = $searchNode->getAttribute('Rate');

                echo $valueID;

            }

Cube tag hasn't Rate attribute. Do you mean date attribute or Rate child? — Mohammad
– Mohammad, Commented Oct 12, 2016 at 9:18

Gayan · Accepted Answer · 2016-10-12 09:29:21Z

1

Check this

<?php
$xmlDoc = new DOMDocument();
$xmlDoc->load('http://www.bnr.ro/nbrfxrates.xml');


foreach ($xmlDoc->getElementsByTagName('Rate') as $searchNode) {
    if($searchNode->getAttribute('currency') === 'EUR') {
        echo $searchNode->nodeValue;
    }
}

?>

answered Oct 12, 2016 at 9:29

Gayan

2,9458 gold badges36 silver badges62 bronze badges

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

Comments

ThW · Accepted Answer · 2016-10-12 12:21:40Z

1

First Rate is not an attribute but an element. So you would need another getElementsByTagName('Rate') and loop over it. However the XML uses a default namespace so getElementByTagNameNS('http://www.bnr.ro/xsd', 'Rate') would be the correct way.

An easier way is to use Xpath to fetch the value directly:

$document = new DOMDocument();
$document->load('http://www.bnr.ro/nbrfxrates.xml');
$xpath = new DOMXpath($document);
$xpath->registerNamespace('r', 'http://www.bnr.ro/xsd');

var_dump(
  $xpath->evaluate('number(//r:Cube/r:Rate[@currency="EUR"])')
);

Output:

float(4.4961)

Xpath does not have a default namespace, so you have to register your own alias for it (I used r in the example.).

The Xpath expression

fetch any {http://www.bnr.ro/nbrfxrates.xml}Cube
//r:Cube
fetch all {http://www.bnr.ro/nbrfxrates.xml}Rate children
//r:Cube/r:Rate
filter by the currency attribute
//r:Cube/r:Rate[@currency="EUR"]
cast the first found node into a number
number(//r:Cube/r:Rate[@currency="EUR"])

edited Oct 12, 2016 at 12:21

answered Oct 12, 2016 at 11:21

ThW

19.5k3 gold badges25 silver badges47 bronze badges

1 Comment

Ciprian Over a year ago

Thank you for the explanation. I ll give it a try.

Veshraj Joshi · Accepted Answer · 2016-10-12 09:44:20Z

0

<?php
    $xmlDoc = new DOMDocument();
    $xmlDoc->load('http://www.bnr.ro/nbrfxrates.xml');

    foreach($xmlDoc->getElementsByTagName("Rate")  as $node)
    {
        $currency = $node->getAttribute('currency');
        if($currency == 'EUR')
        {
             $value = $node->nodeValue;
        }
    }
    echo 'value for EUR is - '. $value;

?>

answered Oct 12, 2016 at 9:44

Veshraj Joshi

3,5874 gold badges32 silver badges51 bronze badges

Collectives™ on Stack Overflow

PHP - Get value from xml file

3 Answers 3

Comments

The Xpath expression

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

The Xpath expression

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related