<?php 
/* 
* File: CurrencyConverter.php 
* Author: Simon Jarvis 
* Copyright: 2005 Simon Jarvis 
* Date: 10/12/05 
* Link: http://www.white-hat-web-design.co.uk/articles/php-currency-conversion.php 
* 
* This program is free software; you can redistribute it and/or 
* modify it under the terms of the GNU General Public License 
* as published by the Free Software Foundation; either version 2 
* of the License, or (at your option) any later version. 
* 
* This program is distributed in the hope that it will be useful, 
* but WITHOUT ANY WARRANTY; without even the implied warranty of 
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 
* GNU General Public License for more details: 
* http://www.gnu.org/licenses/gpl.html 
* 
*/ 
class CurrencyConverter { 
   var $xml_file = "www.ecb.int/stats/eurofxref/eurofxref-daily.xml"; 
   var $mysql_host, $mysql_user, $mysql_pass, $mysql_db, $mysql_table; 
   var $exchange_rates = array(); 
   //Load Currency Rates 
   function CurrencyConverter($host,$user,$pass,$db,$tb) { 
      $this->mysql_host = $host; 
      $this->mysql_user = $user; 
      $this->mysql_pass = $pass; 
      $this->mysql_db = $db; 
      $this->mysql_table = $tb; 
      $this->checkLastUpdated(); 
      $conn = mysql_connect($this->mysql_host,$this->mysql_user,$this->mysql_pass); 
      $rs = mysql_select_db($this->mysql_db,$conn); 
      $sql = "SELECT * FROM ".$this->mysql_table; 
      $rs =  mysql_query($sql,$conn); 
      while($row = mysql_fetch_array($rs)) { 
         $this->exchange_rates[$row['currency']] = $row['rate']; 
      } 
   } 
   /* Perform the actual conversion, defaults to £1.00 GBP to USD */ 
   function convert($amount=1,$from="GBP",$to="USD",$decimals=2) { 
      return(number_format(($amount/$this->exchange_rates[$from])*$this->exchange_rates[$to],$decimals)); 
   } 
   /* Check to see how long since the data was last updated */ 
   function checkLastUpdated() { 
      $conn = mysql_connect($this->mysql_host,$this->mysql_user,$this->mysql_pass); 
      $rs = mysql_select_db($this->mysql_db,$conn); 
      $sql = "SHOW TABLE STATUS FROM ".$this->mysql_db." LIKE '".$this->mysql_table."'"; 
      $rs =  mysql_query($sql,$conn); 
      if(mysql_num_rows($rs) == 0 ) { 
         $this->createTable(); 
      } else { 
         $row = mysql_fetch_array($rs); 
         if(time() > (strtotime($row["Update_time"])+(12*60*60)) ) { 
            $this->downloadExchangeRates(); 
         } 
      } 
   } 
   /* Download xml file, extract exchange rates and store values in database */ 
   function downloadExchangeRates() { 
      $currency_domain = substr($this->xml_file,0,strpos($this->xml_file,"/")); 
      $currency_file = substr($this->xml_file,strpos($this->xml_file,"/")); 
      $fp = @fsockopen($currency_domain, 80, $errno, $errstr, 10); 
      if($fp) { 
         $out = "GET ".$currency_file." HTTP/1.1rn"; 
         $out .= "Host: ".$currency_domain."rn"; 
         $out .= "User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5rn"; 
         $out .= "Connection: Closernrn"; 
         fwrite($fp, $out); 
         while (!feof($fp)) { 
            $buffer .= fgets($fp, 128); 
         } 
         fclose($fp); 
         $pattern = "{<Cubes*currency='(w*)'s*rate='([d.]*)'/>}is"; 
         preg_match_all($pattern,$buffer,$xml_rates); 
         array_shift($xml_rates); 
         for($i=0;$i<count($xml_rates[0]);$i++) { 
            $exchange_rate[$xml_rates[0][$i]] = $xml_rates[1][$i]; 
         } 
         $conn = mysql_connect($this->mysql_host,$this->mysql_user,$this->mysql_pass); 
         $rs = mysql_select_db($this->mysql_db,$conn); 
         foreach($exchange_rate as $currency=>$rate) { 
            if((is_numeric($rate)) && ($rate != 0)) { 
               $sql = "SELECT * FROM ".$this->mysql_table." WHERE currency='".$currency."'"; 
               $rs =  mysql_query($sql,$conn) or die(mysql_error()); 
               if(mysql_num_rows($rs) > 0) { 
                  $sql = "UPDATE ".$this->mysql_table." SET rate=".$rate." WHERE currency='".$currency."'"; 
               } else { 
                  $sql = "INSERT INTO ".$this->mysql_table." VALUES('".$currency."',".$rate.")"; 
               } 
               $rs =  mysql_query($sql,$conn) or die(mysql_error()); 
            } 
         } 
      } 
   } 
   /* Create the currency exchange table */ 
   function createTable() { 
      $conn = mysql_connect($this->mysql_host,$this->mysql_user,$this->mysql_pass); 
      $rs = mysql_select_db($this->mysql_db,$conn); 
      $sql = "CREATE TABLE ".$this->mysql_table." ( currency char(3) NOT NULL default '', rate float NOT NULL default '0', PRIMARY KEY(currency) ) ENGINE=MyISAM"; 
      $rs =  mysql_query($sql,$conn) or die(mysql_error()); 
      $sql = "INSERT INTO ".$this->mysql_table." VALUES('EUR',1)"; 
      $rs =  mysql_query($sql,$conn) or die(mysql_error()); 
      $this->downloadExchangeRates(); 
   } 
} 
?>

<?php 
   include('CurrencyConverter.php'); 
   $x = new CurrencyConverter('your_host','your_username','your_password','your_database_name','your_table_name');
   echo $x->convert(2.50,'GBP','USD'); 
?>