Hello guys,
hope you can help me to finalize my problem. I have a Joomla website with a real estate extension. This extension only shows one currency but need to show 3 more. I found a script which converts the value to another currency, but this script can be used only one time on each page, if it is used several times then the script breaks down and the webpage is not shown properly.
1st Example :
We are on the item page, which shows the selling price GBP.
The script is embedded with auto convert to EUR = Works great!
The script is embedded SECOND time with auto convert to USD = script breaks down.
2nd Example :
We are on the catalog page, which shows many items as preview. Each item shows its own price. (Like an online shop catalog page). The script is embedded even only with one currency, but the script breaks down and the whole page is not shown properly.
To convert any value I have this code:
<?php include('CurrencyConverter.php'); $x = new CurrencyConverter('localhost','USERNAME','PASSWORD','DATABASENAME','LISTNAME'); echo $x->convert(floatval($this->row->price) ,'GBP','EUR'); ?>(‘USERNAME’,‘PASSWORD’,‘DATABASENAME’,‘LISTNAME’ is changed at my side to suit MySQL database.)
Actually I need to show also GBP to USD and this is what I did:
<?php include('CurrencyConverter.php'); $x = new CurrencyConverter('localhost','USERNAME','PASSWORD','DATABASENAME','LISTNAME'); echo $x->convert(floatval($this->row->price) ,'GBP','USD'); ?>Now the error occurs! But please keep in mind that GBP to USD works also good if GBP to EUR is not used.
To use the currency converter there is one separated php file, here is the code. I appreciate if you can help me with this, I am struggeling with this now for 2 weeks. Thank you very much and kind regards!!
<?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.1\r\n"; $out .= "Host: ".$currency_domain."\r\n"; $out .= "User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5\r\n"; $out .= "Connection: Close\r\n\r\n"; fwrite($fp, $out); while (!feof($fp)) { $buffer .= fgets($fp, 128); } fclose($fp); $pattern = "{}is"; preg_match_all($pattern,$buffer,$xml_rates); array_shift($xml_rates); for($i=0;$imysql_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(); } } ?>