Retrieve XML data using PHP...

[roosteroo]

Good day all,

I'm trying to use PHP to retrieve data from an XML feed.
The feed URL: http://dgcsc.org/goldprices2.xml

I'm trying to fetch gold price (ask and bid) per gram in USD.

<GoldPrice per="gram" date="2011-01-18 17:30:47">
<Price currencyname="United States Dollar" currencycode="USD">
<Ask>43.9724</Ask>
<Bid>43.9403</Bid>
</Price>

Please help, thanks!
marc

[Dormilich]

look into SimpleXML

[roosteroo]

I've tried this with simplexml, doesn't work out quite as i wanted...

PHP Code:

<?php

$xml = new SimpleXMLElement('http://dgcsc.org/goldprices2.xml',null,true);
$xpath = new DOMXPath($xml);

/*
foreach($xml as $Price) {
if ($Price['currencycode'] = "USD")
  echo "Number: {$Price['currencycode']}: {$Price->Bid} - {$Price->Ask}\r\n";
}
*/
    $names = $xml->xpath('/GoldPrice/Price/Ask[]');
    foreach($names as $name) {
        echo "Found $name<br />";
    }




$arts = $xpath->query("/GoldPrice/Price/Ask");

foreach ($arts as $art)
{
    echo $art->nodeValue."";
}

/*
foreach($xml as $url) {
  echo "{$Goldprice->Price[currencycode->USD]->Ask}\n";
}
*/

/*
<GoldPrice per="gram" date="2011-01-18 17:30:47">
<Price currencyname="United States Dollar" currencycode="USD">
<Ask>43.9724</Ask>
<Bid>43.9403</Bid>
</Price>

*/
//var_dump($xml);

//echo $xml->movie[0]->plot;

?>

[Dormilich]

this worked for me:

PHP Code:

<?php
$xml = new SimpleXMLElement('http://dgcsc.org/goldprices2.xml',null,true);
    $names = $xml->xpath('/GoldPrice/Price/Ask');
    foreach($names as $name) {
        echo "Found $name<br />";
    }

[roosteroo]

thanks Dormilich, yes it works well.

Would it be possible to output only the currencycode called "USD" ?
And with the Bid and Ask?


see

<GoldPrice per="gram" date="2011-01-18 17:30:47">
<Price currencyname="United States Dollar" currencycode="USD">
<Ask>43.9724</Ask>
<Bid>43.9403</Bid>
</Price>

[Dormilich]

Originally Posted by roosteroo

Would it be possible to output only the currencycode called "USD" ?
And with the Bid and Ask?

sure: /GoldPrice/Price[@currencycode = 'USD']/*

[roosteroo]

I got "Parse error: syntax error, unexpected T_STRING" when I tried the following;

PHP Code:

<?php
$xml = new SimpleXMLElement('http://dgcsc.org/goldprices2.xml',null,true);
    $names = $xml->xpath('/GoldPrice/Price[@currencycode = 'USD']/*');
    foreach($names as $name) {
        echo "Found $name<br />";
    } 
?>

and

PHP Code:

<?php
$xml = new SimpleXMLElement('http://dgcsc.org/goldprices2.xml',null,true);
echo '/GoldPrice/Price[@currencycode = 'USD']/*';
?>

[Fou-Lu]

You cannot use single quotes within single quotes, or double within double without escaping them. PHP doesn't understand where the end of the instruction is otherwise. You can however use double in single and single in double.
Options are:

PHP Code:

'/GoldPrices/Price[@currencycode=\'USD\']/*'
OR 
"/GoldPrices/Price[@currencycode='USD']/*" 


You may also use double within the single. The easiest is the latter of the two to change.

[roosteroo]

Fou-lu and Dormilich
thank you so much!

[roosteroo]

I'm trying to convert grams to troy ounces. See code below;

Why does php output only 1337.45 ? Answer should be 1352.89.

1352.89 = 43.4966 * 31.1034768

Output:

Gold per gram Ask: 43.4966
Gold per t oz Ask: 1337.45

Code:

PHP Code:

<?php

$xml = new SimpleXMLElement('http://dgcsc.org/goldprices2.xml',null,true);

    $names = $xml->xpath("/GoldPrice/Price[@currencycode = 'USD']/*");

echo "Gold per gram Ask: $names[0]<BR/><BR/>";

$gramspertoz    =  31.1034768;

$ask= round($names[0]*$gramspertoz,2);

echo "Gold per t oz Ask: $ask";
?>

[roosteroo]

okay I tried using BCMUL() to multiply and that fixed the problem. thanks all

[GGG]

Originally Posted by roosteroo

Good day all,

I'm trying to use PHP to retrieve data from an XML feed.
The feed URL: http://dgcsc.org/goldprices2.xml

I'm trying to fetch gold price (ask and bid) per gram in USD.

<GoldPrice per="gram" date="2011-01-18 17:30:47">
<Price currencyname="United States Dollar" currencycode="USD">
<Ask>43.9724</Ask>
<Bid>43.9403</Bid>
</Price>

Please help, thanks!
marc

Yes SimpleXML would be the answer. Unfortunetaly the service has discontinued but i found an alternative: Precious Metals XML Feed http://www.xmlcharts.com/precious-metals.html


(Dear mods, this is no spam. It's topic related and i spent hours and hours to find a similiar one. Now that i found one - i let all participate. Thanks in advance!)

[GoldGunsGod]

Well this has the simple reason that your xpath query is completely false.

<message>
  <subject>Sorry, this service is closed.</subject>
		<body>For more information or to subscribe to the rates, please see http://xml.dgcsc.org</body>
</message>

You have to apply it to this gold xml price feed at http://www.xmlcharts.com/precious-metals.html with xpath via:

PHP Code:

list($price) = $tree->xpath('/prices/pricelist[@currency="usd"]/price[@commodity="gold"]'); 


greets.