PHP实现货币换算的方法

发布时间：2020-12-12 20:32:03 所属栏目：PHP教程来源：网络整理

导读：本篇章节讲解PHP实现货币换算的方法。供大家参考研究。具体实现代码如下：代码如下: mysql_host = $host; $this->mysql_user = $user; $this->mysql_pass = $pass; $this->mysql_db = $db; $this->mysql_table = $tb; $this->checkLastUpdated();

本篇章节讲解PHP实现货币换算的方法。分享给大家供大家参考。

具体实现代码如下：

代码如下:

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,$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,strpos($this->xml_file,"/")); 
 $currency_file = substr($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 = "{}is"; 
 preg_match_all($pattern,$buffer,$xml_rates); 
 array_shift($xml_rates); 
 for($i=0;$imysql_host,$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,$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(); 
 } 
} 
?>

上面的代码复制到一个新文件并将其保存为CurrencyConverter.php。当你需要转换包含类文件,称为“转换”功能。你需要输入自己的mysql数据库变量如登录详细信息。下面的例子将￡2.50英镑转换成美元(美元)。

代码如下:

convert(2.50,'GBP','USD'); 
?>

希望本文所述对大家的php程序设计有所帮助。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!