How to parse this XML file from http://www.newyorkfed.org/xml/data/fx/ATSNoon.xml

Question

I have the following xml file http://www.newyorkfed.org/xml/data/fx/ATSNoon.xml and I have to parse it using PHP. In fact I need to parse all the and to an array. The array I need will be something like:

$rates = (array('date' => '1994-01-06', 'value' => '12.2430'), 
      array('date' => '1994-01-07', 'value' => '13.2430'),
      array(...)
);

Having a poor experience with parsing XML files, I can't succeed with this task no matter what I tried. May I ask for some help guys? Thank you

Could use an xml parser or for this specific case [see a regex idea](https://eval.in/464925). — bobble bubble, Nov 08 '15 at 15:35
Thanks bobble bubble...it works perfectly with your solution. — Mihai, Nov 09 '15 at 07:46

score 1 · Accepted Answer · answered Nov 09 '15 at 08:07

If you register a prefix for the namespace of the elements you can fetch them with Xpath:

$document = new DOMDocument();
$document->load($xmlFile);
$xpath = new DOMXpath($document);
$xpath->registerNamespace('f', 'http://www.newyorkfed.org/xml/schemas/FX/utility');

$result =[];
foreach ($xpath->evaluate('//f:Obs') as $obs) {
  $result[] = [
    'date' => $xpath->evaluate('string(f:TIME_PERIOD)', $obs),
    'value' => $xpath->evaluate('string(f:OBS_VALUE)', $obs)
  ]; 
}
var_dump($result);

Output:

array(??) {
  [0]=>
  array(2) {
    ["date"]=>
    string(10) "1994-01-06"
    ["value"]=>
    string(7) "12.2430"
  }
  [1]=>
  array(2) {
    ["date"]=>
    string(10) "1994-01-07"
    ["value"]=>
    string(7) "12.2190"
  }
  [2]=>
  array(2) {
    ["date"]=>
    string(10) "1994-01-10"
    ["value"]=>
    string(7) "12.20
  ...

Thanks. This technique is quite nice. Thank you very much. – Mihai Nov 09 '15 at 18:46 — Mihai, Nov 09 '15 at 18:46

Professor Abronsius · Answer 2 · 2015-11-08T09:53:34.387

with the below code you should be able to manipulate the output to your requirements..

/* utility class to simplify working with DOMDocument & XML */
class xmldom{
    private $xml;
    private $parse_errs;
    public function __construct( $data, $options=array() ){
        try{

            $opts=(object)array_merge(array(
                'encoding'      =>  'utf-8',
                'validate'      =>  false,
                'standalone'    =>  true,
                'preserve'      =>  true,
                'strict'        =>  false,
                'substitute'    =>  false,
                'recover'       =>  true,
                'format'        =>  false
            ),$options);

            libxml_use_internal_errors( TRUE );
            $this->xml = new DOMDocument('1.0',$opts->encoding);
            $this->xml->validateOnParse=$opts->validate;
            $this->xml->standalone=$opts->standalone;
            $this->xml->preserveWhiteSpace=$opts->preserve;
            $this->xml->strictErrorChecking=$opts->strict;
            $this->xml->substituteEntities=$opts->substitute;
            $this->xml->recover=$opts->recover;
            $this->xml->formatOutput=$opts->format;
            $this->xml->loadXML( mb_convert_encoding( $data, $opts->encoding ) );
            $this->parse_errs=serialize( libxml_get_last_error() );
            libxml_clear_errors();

        }catch( Exception $e ){
            die( $e->getMessage() );    
        }
    }
    public function getdom(){
        return $this->xml;
    }
    public function geterrors(){
        return $this->parse_errs;   
    }
}

/* Utility class to iterate nodes in the DOM */
class RecursiveDOMIterator implements RecursiveIterator {
    private $index;
    private $list;

    public function __construct(DOMNode $domNode){
        $this->index = 0;
        $this->list = $domNode->childNodes;
    }
    public function current(){
        return $this->list->item($this->index);
    }
    public function getChildren(){
        return new self( $this->current() );
    }
    public function hasChildren(){
        return $this->current()->hasChildNodes();
    }
    public function key(){
        return $this->index;
    }
    public function next(){
        $this->index++;
    }
    public function rewind(){
        $this->index = 0;
    }
    public function valid(){
        return $this->index < $this->list->length;
    }
}

/* Get the xml data */
$url=file_get_contents( 'http://www.newyorkfed.org/xml/data/fx/ATSNoon.xml' );

/* Construct DOMDocument object using xml data as source */
$dom=new xmldom(  $url );
$xml=$dom->getdom();

/* Find the Root node in the DOMDocument */
$rootnode=$xml->getElementsByTagName('UtilityData')->item(0);

/* Create the Domnode iterator object */
$nodeItr=new RecursiveDOMIterator( $rootnode );

/* Create standard recursive Iterator */
$itr=new RecursiveIteratorIterator( $nodeItr, RecursiveIteratorIterator::SELF_FIRST );

/* Iterate through the DOM and echo out tagname & value */
foreach( $itr as $node ) {
    if( $node->nodeType === XML_ELEMENT_NODE ) {
        /*
            Here you can add to an array or manipulate however you see fit.
        */
        echo $node->nodeName . ' ' . $node->nodeValue. '<br />';
    }
}
/* clean up */
$dom=$rootnode=$itr=$nodeItr=null;

How to parse this XML file from http://www.newyorkfed.org/xml/data/fx/ATSNoon.xml

2 Answers2