StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POUpdate table with correct currency rate
primarykey
Id
14127967
data
AcceptedAnswerId
14131874
AnswerCount
1
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2013-01-02T19:30:31.767
FavoriteCount
0
LastActivityDate
2013-01-03T01:27:08.103
LastEditDate
2013-01-02T19:36:53.627
LastEditorUserId
1875917
OwnerUserId
1875917
ParentId
0
PostTypeId
1
Score
0
ViewCount
709
LastEditorDisplayName
text
Body
I am trying to get the exchange of 1 Pound to other currencies, at the moment I am getting Eur 1 to other currencies. for example 1 Eur = 0.81400 GBP, I can reverse this and get 1 GBP to Eur by dividing with each giving me exchange rate of 1.228501228501229. I want this for all the currencies, currently I am using php script to fetch the exchange rate. how can I alter my Stock_currency table and divide GBP to all the currencies and store them back in to Stock_currency table here is my PHPscript <pre><code><?php class CurrencyConverter { var $xml_file = "www.ecb.int/stats/eurofxref/eurofxref-daily.xml"; var $localhost, $sirnur, $abc123, $mohamed, $stock_currency; var $exchange_rates = array(); //Load Currency Rates function CurrencyConverter($host,$user,$pass,$db,$tb) { $this->localhost = $host; $this->sirnur = $user; $this->abc123 = $pass; $this->mohamed = $db; $this->stock_currency = $tb; $this->checkLastUpdated(); $conn = mysql_connect($this->localhost,$this->sirnur,$this->abc123); $rs = mysql_select_db($this->mohamed,$conn); $sql = "SELECT * FROM ".$this->stock_currency; $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="USD",$to="GBP",$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->localhost,$this->sirnur,$this->abc123); $rs = mysql_select_db($this->mohamed,$conn); $sql = "SHOW TABLE STATUS FROM ".$this->mohamed." LIKE '".$this->stock_currency."'"; $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 = "{<Cube\s*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->localhost,$this->sirnur,$this->abc123); $rs = mysql_select_db($this->mohamed,$conn); foreach($exchange_rate as $currency=>$rate) { if((is_numeric($rate)) && ($rate != 0)) { $sql = "SELECT * FROM ".$this->stock_currency." WHERE currency='".$currency."'"; $rs = mysql_query($sql,$conn) or die(mysql_error()); if(mysql_num_rows($rs) > 0) { $sql = "UPDATE ".$this->stock_currency." SET rate=".$rate." WHERE currency='".$currency."'"; } else { $sql = "INSERT INTO ".$this->stock_currency." VALUES('".$currency."',".$rate.")"; } $rs = mysql_query($sql,$conn) or die(mysql_error()); } } } } /* Create the currency exchange table */ function createTable() { $conn = mysql_connect($this->localhost,$this->sirnur,$this->abc123); $rs = mysql_select_db($this->mohamed,$conn); $sql = "CREATE TABLE ".$this->stock_currency." ( 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->stock_currency." VALUES('EUR',1)"; $rs = mysql_query($sql,$conn) or die(mysql_error()); $this->downloadExchangeRates(); } } </code></pre> the include file <pre><code><?php include('CurrencyConverter.php'); $x = new CurrencyConverter('localhost','root','root','mohamed','Stock_Currency'); // mysql_query("ALTER TABLE Stock_currency add column We_sell varchar (20) ; ") or die(mysql_error()); // mysql_query("ALTER TABLE Stock_currency add column We_buy varchar (20) ; ") or die(mysql_error()); ?> </code></pre>
Tags
<php><mysql><sql>
Title
Update table with correct currency rate
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USmohamed nur
UserOwnerUserId
1. USmohamed nur
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.