currency conversion

@bunny1Mar 21.2007

Is there a way of checking and displaying the currency conversion for price using php?
I want to connect to the database get the price in one currency and then check the rate and display the second curreny.

thanks

to post a comment

PHP

@MrCoderMar 21.2007 — #Oanda (http://www.oanda.com)

XE (http://www.xe.com)

These 2 sites offer live exchange rates, maybe they have an API?

@NightShift58Mar 22.2007 — #Or these guys:

http://finance.yahoo.com/

If you Google it, you'll find tons of scripts to scrape from Yahoo

@bunny1authorMar 22.2007 — #i got this script that uses yahoo

[code=php]<?php 
 $price = '100'; 
 $ticker= 'USDEUR=X'; 
 $open = fopen("http://quote.yahoo.com/d/quotes.csv?s=$ticker&f=sl1d1t1c1ohgv&e=.csv", "r"); 
 $exchange_rate = fread($open, 2000); 
 fclose($open); 
 $exchange_rate = str_replace(""", "", $exchange_rate); 
 $exchange_rate = explode(",", $exchange_rate); 
 $ca_price = ($us_price/$exchange_rate[1]); 
 $price = number_format ($ca_price, 2); 
 
 echo "$price Euro = $$price US dollars"; 
 ?> [/code]

when i upload the pg and try to open it, it takes ages and then i get "page cannot be displayed". I take it that it's slow because it must go to the yahoo page.

Is this a problem with my host. And how can i fix this.

Thank you

@NightShift58Mar 22.2007 — #Take a look at this page, where Yahoo is used and it's pretty fast.

http://www.costaricalaw.com/LEGALNET/real_estate_law/closecost.php

@NightShift58Mar 22.2007 — #Code used in previous example:

[code=php]<?php
 //Get the exchange rate from Yahoo
 $thisRATE    = file_get_contents("http://finance.yahoo.com/d/quotes.csv?s=USDCRC=X&f=sl1d1t1ba&e=.csv");
 if ($thisRATE === FALSE) :
 $EXCHrate    = 520;
 $EXCHinfo    = "Based on <b>$1.00</b> = <b>¢520.00</b>";
 else :
 $arrRATE     = split(",", $thisRATE);
 $EXCHrate    = $arrRATE[5];
 $EXCHdata    = str_replace('"', "", $arrRATE[2] . " at " . $arrRATE[3]);
 $EXCHinfo    = "Based on <b>$1.00</b> = <b>¢$EXCHrate</b> on $EXCHdata";
 if ($EXCHrate < 490 or $EXCHrate > 600) :
 $EXCHrate    = 520;
 $EXCHinfo    = "Based on <b>$1.00</b> = <b>¢520.00</b>";
 endif;
 endif;
 ?>[/code]

@bunny1authorMar 22.2007 — #thanks that works great!

currency conversion

6 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

currency conversion

6 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

6 Comments(s) _↴

Also in #PHP _↴