Geek asks and answers

Php read xml loop file over @attributes?

My exrate.xml look like

 <!--For reference only. Only one request every 5 minutes!-->
    <ExrateList>
    <DateTime>5/29/2011 8:54:12 PM</DateTime>
    <Exrate CurrencyCode="AUD" CurrencyName="AUST.DOLLAR" Buy="21688.77" Transfer="21819.69" Sell="22201.6"/>    
    <Source>source name </Source>
    </ExrateList>

Does anyone know how I can read xml and output data.

currency | buy | sale

I have

            <?php
              = simplexml_load_file("Service/Forex_Content.xml");
            echo '<pre>';
            print_r($xml);
            echo '</pre>';

        ?>


SimpleXMLElement Object
(
    [DateTime] => 5/29/2011 8:54:12 PM
    [Exrate] => Array
        (
            [0] => SimpleXMLElement Object
                (
                    [@attributes] => Array
                        (
                            [CurrencyCode] => AUD
                            [CurrencyName] => AUST.DOLLAR
                            [Buy] => 21688.77
                            [Transfer] => 21819.69
                            [Sell] => 22201.6
                        )

                )

How can I encode @ attributes to display data?

foreach ($xml as $value){
    foreach ($value->@attributes as $key=>$val){ // I have problem here @attributes

        }

}
+3
source share
4 answers

With SimpleXML, attributes are accessed using the method attributes():

foreach ($value->attributes() as $key=>$val){
    // do something
}
+6
source

Try the following:

<?php
$xml = simplexml_load_file( "Service/Forex_Content.xml" );
foreach( $xml->Exrate[0]->attributes() as $a => $b ) {
    echo $a . '="' . $b ."\"\n";
}

EDIT: case fixed.

+2
source

Replace $value->@attributeswith $value->attributes(). You may have to go further down the tree to get to the desired node, but you can call attributes()for any element.

+1
source 
function recurseXML($xml, $step)
{
    echo "<table cellpadding=\"2\" cellspacing=\"2\" width=\"100%\" border=\"1\">";
    $step++;
    foreach($xml as $key0 => $value)
    {
        if($key0=='Exrate')
        {           
            echo "\n<tr>\n";                   
            foreach($value->attributes() as $attributeskey0 => $attributesvalue1)
            {    
                echo " <td> [$attributeskey0] = $attributesvalue1</td>\n";  
            }
            echo "</tr>\n\n";
        }
        else
        {
           echo "\n<tr><td colspan=\"5\">$value</td></tr>";
        }           
    }
    echo "</table>\n";
}
$xml = simplexml_load_file("http://www.vietcombank.com.vn/ExchangeRates/ExrateXML.aspx");
recurseXML($xml, 0);
0
source

More articles:


All Articles