PHP - Currency Format

hello everyone i am newbie to php just wanted to make a script for currency converter the problem i am facing is if i want to convert a value from $usd to $euro,$pond,$yen there are three possible values for usd kindly help me out with designing the values for tables and fetching data from them what will be structure of the table what will be the values kindly help me out it,s request thanks

I'm trying to develop a function to check to see if the value inputted was in a currency format. I'm checking for:
if the value is numeric
if the value is an integer
if not integer check the number of digits to the right of the decimal point

I can't tell how the php function is_int() works though. I want to accept integers and also numbers with two decimal places. So accepted values will be "123" and also "123.99".

The script tells me the value is not an integer no matter what.

Code: [Select]
<?php
$num = $_POST['number'];
$positionOfDecimalPoint = strpos($num, '.');
$numbersToLeft = substr($num,0,$positionOfDecimalPoint);
$numbersToRight = substr($num,$positionOfDecimalPoint + 1);//Add one so decimal point isn't included in output.

echo "You submitted ".$num."<br><br>";

if(!is_numeric($num))
{
 echo "Not Numeric";
}
else
{ 
   if(!is_int($num))
     {      
 $adecimal = strlen($numbersToRight);
 if($adecimal !== 2)
{
  echo "There needs to be exactly two numbers after the decimal.";
}
echo "<br><br>The number is not an integer.";
         }else
         {
       echo "The integer is ".$num;
         }
}



?>

Hey there,

I'm looking for some publicly available API that I can convert GPB to Dollars, that is updated often, can somebody show me how I could obtain such a API?.

Thanks,
Christopher.

Unfortunately, I have got nearly zero knowledge in PHP.
I'm just trying to add a drop-down menu on my website which will turn the prices in USD to other currencies.
I'm trying hard to learn but it's too difficult for me at the moment. Here are codes written by someone else which I want to modify and apply to my website.
I've tried the second PHP on my WAMP local server but it returns nothing. Both files were in the same folder. I don't know if these codes are correct.
I'd appreciate if someone could tell me if the codes are wrong or they just don't work on WAMP server.
Sorry the codes are quite long.

Thanks in advance.


Code: [Select]
<?php
/*

File: currencyexchange.php
Author: Gary White
Last modified: July 6, 2005

Copyright (C) 2005, Gary White

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
included GNU General Public License for more details. If you 
received this file without the gpl.txt file, you may view it at:
http://www.gnu.org/copyleft/gpl.html

See the readme.txt file for usage.

July 6, 2005 added the RON, Romania New Leu, to the currency list.

*/

// this simply gets an array of possible currency countries and names
$allCurrencies=getCurrencyNames();
class currencyExchange{
/////////////////////////////////////////////////////////////////////////////////////////
// Public Properties
// Note that these properties are public, but the values are all generated internally.
// You should consider them read only during normal usage.
// The only one you may want to access would be the $localFile property, if you wanted
// to change the name of the local file used to cache a copy of the data.
/////////////////////////////////////////////////////////////////////////////////////////

// $Supplier property will be the European Central Bank, assuming we get the data
var $Supplier="";
// $Date property is the date of the exchange rate publication
var $Date="";
// $Rates property is an associative array of rateobj objects with the three letter identifier as the array keys
var $Rates=array();
// $Source property will be either "Local" or "Remote" depending on where the data comes from
var $Source="";
// $Error property will contain any error messages generates along the way
var $Error="";
// $localFile property is the file name used to cache a local copy of the XML file
var $localFile="currencies_local.xml";
// $url property is the URL of the XML file at the European Central Bank
var $url="http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml";

/////////////////////////////////////////////////////////////////////////////////////////
// Public Methods
/////////////////////////////////////////////////////////////////////////////////////////
function getData(){
$olderr=error_reporting(0);
$this->Source="Local";
if(file_exists($this->localFile)){
// load it
$this->xml=@file_get_contents($this->localFile);
$this->parse();

// check if it's a weekend
// what day of the week is it?
$weekday=date("w");
// if it's a Sunday or Saturday
if($weekday==0 || $weekday==6){
// go back to last Friday
$date=date("Y-m-d",strtotime("last Friday"));
} else {
$date=date("Y-m-d");
}
// if the date in the local file is not the same
// as our current date, or last Friday for weekends
if($this->Date!=$date){

// clear the data
$this->clearData();

// get the remote file
$this->xml=$this->getRemoteFile($this->url);

if($this->parse()){
$this->Source="Remote";
// write the remote file data to a local copy of the file
$this->saveLocalCopy();
}
} // if we have a local copy
}else{
$this->xml=$this->getRemoteFile($this->url);

if($this->xml)
// write the remote file data to a local copy of the file
$this->saveLocalCopy();
}
if(!$this->xml)
$this->error="Failed to get data";
else{
$this->parse();
}
// sort our rates on the keys
ksort($this->Rates);
error_reporting($olderr);
return count($this->Rates);
}

function getRemoteFile($url){

$curl_handle = curl_init();
// Where should we get the data?
curl_setopt ($curl_handle, CURLOPT_URL, $url);
// This says not to dump it directly to the output stream, but instead
// have it return as a string.
curl_setopt ($curl_handle, CURLOPT_RETURNTRANSFER, 1);
// the following is optional, but you should consider setting it
// anyway. It prevents your page from hanging if the remote site is
// down.
curl_setopt ($curl_handle, CURLOPT_CONNECTTIMEOUT, 1);
// Now, YOU make the call.
$buffer = curl_exec($curl_handle);
// And tell it to shut down (when your done. You can always make more
// calls if you want.)
curl_close($curl_handle);
// This is where i&#65533;d probably do some extra checks on what i just got.
// Paranoia pays dividends.

return $buffer;
}

function Convert($from, $to, $amount=1){
// Converts from one currency to another. The method expects at least two
// parameters. The first param , $from, it the three letter identifier for
// the currency you are converting from. The second param, $to, is the 
// three letter identifier for the currency you are converting to. The final
// param, $amount, is the amount of the $from currency to convert. If omitted
// the amount defaults to 1 and the function will return the amount of $to
// currency that corresponds with 1 unit of the $from currency.
if(array_key_exists($from, $this->Rates) && array_key_exists($to, $this->Rates)){
return ($amount * (($this->Rates[$to]->rate)/($this->Rates[$from]->rate)));
}else{
$this->Error->Error = "";
if (!array_key_exists($from, $this->Rates))
$this->Error.="$from is not a recognized currency identifier ";
if (!array_key_exists($from, $this->Rates))
$this->Error.="$to is not a recognized currency identifier";
return false;
}
}

function setBaseCurrency($currency){
// This function converts all currencies to be based on one unit of
// $base currency. It's only really useful if you want to output a 
// table of conversion factors.

// get a factor to do our conversion based on our base currency
$factor=$this->Rates[$currency]->rate;
// modify the rates based on the base currency
foreach(array_keys($this->Rates) as $k){
$rate=$this->Rates[$k]->rate / $factor;
$this->Rates[$k]->rate=$rate;
}
return (count($this->Rates)>0);
}

/////////////////////////////////////////////////////////////////////////////////////////
// Private Methods
// You should not need to call any of the following methods.
/////////////////////////////////////////////////////////////////////////////////////////
function clearData(){
$this->Supplier="";
$this->Date="";
$this->Rates=array();
$this->Source="";
$this->xml="";
}

function saveLocalCopy(){
$fp=fopen($_SERVER['DOCUMENT_ROOT'].$this->localFile,"w") or die("failed to write file");
fwrite($fp,$this->xml);
fclose($fp);
$this->parse();
$this->Source="Remote";
}

function parse(){
if($this->xml){
$this->parser = xml_parser_create();
@xml_set_object($this->parser, $this);
@xml_set_element_handler($this->parser, "startElement", "endElement");
@xml_set_character_data_handler($this->parser, "characterData");
$this->Rates['EUR']=new rateobj();
$this->Rates['EUR']->rate=1.00;
$this->Rates['EUR']->currency="Euro";
xml_parse($this->parser, $this->xml, true)
or die(sprintf("XML error: %s at line %d", 
xml_error_string(xml_get_error_code($parser)), 
xml_get_current_line_number($parser)));
xml_parser_free($this->parser);
}
}

function currencyExchange(){
$dir=pathinfo($_SERVER['PHP_SELF']);
$dir=$dir['dirname'];
$this->localFile="$dir/$this->localFile";
}

function startElement($parser, $name, $attrs) {
global $allCurrencies;
$this->temp="";
$gwCurrencyExch=&$GLOBALS['gwCurrencyExch'];
if($name=="CUBE"){
if(array_key_exists("TIME",$attrs)){
$this->Date=$attrs["TIME"];
}
if(array_key_exists("CURRENCY",$attrs)){
$this->Rates[$attrs["CURRENCY"]]=new rateobj();
$this->Rates[$attrs["CURRENCY"]]->rate=$attrs["RATE"];
$this->Rates[$attrs["CURRENCY"]]->currency=$allCurrencies[$attrs["CURRENCY"]];
}
}
}

function characterData($parser, $data){
$this->temp.=$data;
}

function endElement($parser, $name) {
switch($name){
case "GESMES:NAME":
$this->Supplier=$this->temp;
break;
case "GESMES:SUBJECT":
$this->Report=$this->temp;
break;
}
$temp="";
}

} // end of ratelist class

class gwSocket{
var $ClassName="gwSocket";
var $Version="0.6";

var $error="";
var $headers;
var $maxRedirects=3;
var $page="";
var $result="";
var $redirects=0;
var $userAgent="Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)";

function getUrl( $url ) {
$retVal="";
$url_parsed = parse_url($url);
$scheme = $url_parsed["scheme"];
$host = $url_parsed["host"];
$port = $url_parsed["port"]?$url_parsed["port"]:"80";
$user = $url_parsed["user"];
$pass = $url_parsed["pass"];
$path = $url_parsed["path"]?$url_parsed["path"]:"/";
$query = $url_parsed["query"];
$anchor = $url_parsed["fragment"];

if (!empty($host)){

// attempt to open the socket
if($fp = fsockopen($host, $port, $errno, $errstr, 2)){

$path .= $query?"?$query":"";
$path .= $anchor?"$anchor":"";

// this is the request we send to the host
$out = "GET $path ".
"HTTP/1.0\r\n".
"Host: $host\r\n".
"Connection: Close\r\n".
"User-Agent: $this->userAgent\r\n";
if($user)
$out .= "Authorization: Basic ".
base64_encode("$user:$pass")."\r\n";
$out .= "\r\n";

fputs($fp, $out);
while (!feof($fp)) {
$retVal.=fgets($fp, 128);
}
fclose($fp);
} else {
$this->error=$errstr;
}
$this->result=$retVal;
$this->headers=$this->parseHeaders(trim(substr($retVal,0,strpos($retVal,"\r\n\r\n"))));
$this->page=trim(stristr($retVal,"\r\n\r\n"))."\n";
if(isset($this->headers['Location'])){
$this->redirects++;
if($this->redirects<$this->maxRedirects){
$location=$this->headers['Location'];
$this->headers=array();
$this->result="";
$this->page="";
$this->getUrl($location);
}
}
}
return (!$retVal="");
}

function parseHeaders($s){
$h=preg_split("/[\r\n]/",$s);
foreach($h as $i){
$i=trim($i);
if(strstr($i,":")){
list($k,$v)=explode(":",$i);
$hdr[$k]=substr(stristr($i,":"),2);
}else{
if(strlen($i)>3)
$hdr[]=$i;
}
}
if(isset($hdr[0])){
$hdr['Status']=$hdr[0];
unset($hdr[0]);
}
return $hdr;
}

} // end of gwSocket class

class rateobj{
var $currency="";
var $rate=0;
}

function getCurrencyNames(){
$retVal['AED']="United Arab Emirates Dirham";
$retVal['AFA']="Afghanistan Afghani";
$retVal['ALL']="Albania Leke";
$retVal['ARS']="Argentina Peso";
$retVal['ATS']="Austria Schilling*";
$retVal['AUD']="Australia Dollar";
$retVal['BBD']="Barbados Dollar";
$retVal['BDT']="Bangladesh Taka";
$retVal['BEF']="Belgium Franc*";
$retVal['BGN']="Bulgaria Leva";
$retVal['BHD']="Bahrain Dinar";
$retVal['BMD']="Bermuda Dollar";
$retVal['BRL']="Brazil Reai";
$retVal['BSD']="Bahamas Dollar";
$retVal['CAD']="Canada Dollar";
$retVal['CHF']="Switzerland Franc";
$retVal['CLP']="Chile Peso";
$retVal['CNY']="China Yuan Renminbi";
$retVal['COP']="Colombia Peso";
$retVal['CRC']="Costa Rica Colone";
$retVal['CYP']="Cyprus Pound";
$retVal['CZK']="Czech Republic Koruny";
$retVal['DEM']="Germany Deutsche Mark*";
$retVal['DKK']="Denmark Kroner";
$retVal['DOP']="Dominican Republic Peso";
$retVal['DZD']="Algeria Dinar";
$retVal['EEK']="Estonia Krooni";
$retVal['EGP']="Egypt Pound";
$retVal['ESP']="Spain Peseta*";
$retVal['EUR']="Euro";
$retVal['FIM']="Finland Markkaa*";
$retVal['FJD']="Fiji Dollar";
$retVal['FRF']="France Franc*";
$retVal['GBP']="United Kingdom Pound";
$retVal['GRD']="Greece Drachmae*";
$retVal['HKD']="Hong Kong Dollar";
$retVal['HRK']="Croatia Kuna";
$retVal['HUF']="Hungary Forint";
$retVal['IDR']="Indonesia Rupiahs";
$retVal['IEP']="Ireland Pounds*";
$retVal['ILS']="Israel New Shekel";
$retVal['INR']="India Rupee";
$retVal['IQD']="Iraq Dinar";
$retVal['IRR']="Iran Rial";
$retVal['ISK']="Iceland Kronur";
$retVal['ITL']="Italy Lire*";
$retVal['JMD']="Jamaica Dollar";
$retVal['JOD']="Jordan Dinar";
$retVal['JPY']="Japan Yen";
$retVal['KES']="Kenya Shilling";
$retVal['KRW']="South Korea Won";
$retVal['KWD']="Kuwait Dinar";
$retVal['LBP']="Lebanon Pound";
$retVal['LKR']="Sri Lanka Rupee";
$retVal['LTL']="Lithuanian Lita";
$retVal['LVL']="Latvian Lat";
$retVal['LUF']="Luxembourg Franc*";
$retVal['MAD']="Morocco Dirham";
$retVal['MTL']="Malta Liri";
$retVal['MUR']="Mauritius Rupee";
$retVal['MXN']="Mexico Peso";
$retVal['MYR']="Malaysia Ringgit";
$retVal['NLG']="Dutch (Netherlands) Guilder*";
$retVal['NOK']="Norway Kroner";
$retVal['NZD']="New Zealand Dollar";
$retVal['OMR']="Oman Rial";
$retVal['PEN']="Peru Nuevos Sole";
$retVal['PHP']="Philippines Peso";
$retVal['PKR']="Pakistan Rupee";
$retVal['PLN']="Poland Zlotych";
$retVal['PTE']="Portugal Escudo*";
$retVal['QAR']="Qatar Riyal";
$retVal['ROL']="Romania Lei";
$retVal['RON']="Romania New Leu";
$retVal['RUB']="Russia Ruble";
$retVal['SAR']="Saudi Arabia Riyal";
$retVal['SDD']="Sudan Dinar";
$retVal['SEK']="Sweden Kronor";
$retVal['SGD']="Singapore Dollar";
$retVal['SIT']="Slovenia Tolar";
$retVal['SKK']="Slovakia Koruny";
$retVal['THB']="Thailand Baht";
$retVal['TND']="Tunisia Dinar";
$retVal['TRL']="Turkey Lira*";
$retVal['TRY']="Turkey New Lira";
$retVal['TTD']="Trinidad and Tobago Dollar";
$retVal['TWD']="Taiwan New Dollar";
$retVal['USD']="United States Dollar";
$retVal['VEB']="Venezuela Bolivare";
$retVal['VND']="Vietnam Dong";
$retVal['XAF']="CFA BEAC Franc";
$retVal['XAG']="Silver Ounce";
$retVal['XAU']="Gold Ounce";
$retVal['XCD']="Eastern Caribbean Dollar";
$retVal['XDR']="IMF Special Drawing Right";
$retVal['XOF']="CFA BCEAO Franc";
$retVal['XPD']="Palladium Ounce";
$retVal['XPF']="CFP Franc";
$retVal['XPT']="Platinum Ounce";
$retVal['ZAR']="South Africa Rand";
$retVal['ZMK']="Zambia Kwacha";
return $retVal;
}
?>

Code: [Select]
<?php
/*
This is a sample file that demonstrates the usage of the currencyExchange class.
For purposes of this example, make certain that currencyexchange_class.php is 
saved in the same directory as this file.
*/
//error_reporting(0);
$path=pathinfo($_SERVER['PHP_SELF']);
$path=$_SERVER['DOCUMENT_ROOT'].$path['dirname'];
require_once("$path/currencyexchange_class.php");
$cx=new currencyExchange();
$cx->getData();
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
   "http://www.w3.org/TR/html4/strict.dtd">
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="imagetoolbar" content="no">
<meta name="mssmarttagspreventparsing" content="true">
<meta http-equiv="MSThemeCompatible" content="No">
<title>Currency Conversion Example</title>
<style type="text/css">
body{
background-color: #eee;
color: #333;
font: small Verdana, Arial, Helvetica, sans-serif
}
#pricebox{
background-color: #f7f7f7;
border:1px solid #000;
margin: 50px auto;
padding: 10px;
width: 300px;
}
#pricebox h1, #pricebox h2, #pricebox p{
margin: 0;
padding: 0;
text-align: center;
}
h1{font-size: 160%;}
h2{font-size: 140%;}
</style>
</head>
<body>
<div id="pricebox">
<h1>Get the New Widget</h1>
<h2>Price $250.00 U.S. dollars</h2>
<p><?php
if ($euro=$cx->Convert("USD","EUR",250)){
$euro=number_format($euro,2);
echo "&euro;$euro Euros ";
}
if ($pound=$cx->Convert("USD","GBP",250)){
$pound=number_format($pound,2);
echo "<br>\n&pound;$pound British Pounds</p>\n"
."<p style=\"font-size:smaller;border-top: 1px solid #666;\">Non U.S. pricing based on exchange rates<br>\nin effect as of $cx->Date";
}
?></p></div>
</body>
</html>

I am looking into sotring values in the sql database as "29824478.15" for example,

now i use the number_format function to display as: 29,824,478

is it possible to get it to display as: 29.8m if its a million number and 0.29m if its less than a million for example?

Hi,
i have 2 currencies in my mysql and when user add new article, he choose currency and price.
Now i need search engine for searching articles, and i have problem in part when user choose to show only articles between 100 and 200 euros, so i need help to convert all currencies to euro(all in mysql query) and show from 100 to 200 dollars, so if article price is 100 euros, then to show it too.
Can someone help me ?
1 euro = 0.70 $ (example for values)

When I post the data to mysql I want to submit the value as an integer.  How can I make this $12,000 be 12000?

Hi all,

I am using some code i wrote for www.tingifts.com and although it works fine on that site, it has problems on http://www.regalosdehojalata.es/ The code relates to passing a currency symbol to a variable for inclusion on a page hosted by the payment gateway.

Before I get into code, does anyone else have any experience with foreign languages interfering with php code, and if so, is there an easy way of getting around the issue? I have added slashes to all variables, so I wouldn't think that this would be the problem.

Suggestions?

Neil

Hello all, I'm looking for some assistance with some code.  I'm trying to put this to bed as it's driving me nuts.  The Psuedo code for this would be to

1) Download the rates from the Yahoo API and declare my base rate to my foreign exchange.
2) Store an array of currencies to choose from to compare against the base currency.
3) I then GET the chosen currency and register it in a SESSION to be used on other pages. (I'm unsure if this is correct?)
4) I then calculate the Price of my product which is in GBP to the selected foreign currency.
5) Output the converted price anywhere on the page.

My script takes GET values from the URL like so..

.com?c=EUR

My code is like so..

1) First I get the rates from the Yahoo API
Code: [Select]
session_start();

$from   = 'GBP';
$to     = '$c';
$url = 'http://finance.yahoo.com/d/quotes.csv?e=.csv&f=sl1d1t1&s='. $from . $to .'=X';
$handle = @fopen($url, 'r');

if ($handle) {
    $result = fgets($handle, 4096);
    fclose($handle);
}
$allData = explode(',',$result); /* Get all the contents to an array */
$PoundValue = $allData[1];

2) Then I store an array of the currencies.
Code: [Select]
$currency_array = array ('USD','EUR','RMB','JPY','AUD','CHF')

3) Then I get the chosen currency.
Code: [Select]
if(isset($_GET['c'])) { 
$c = $_GET['c'];

    if(array($currency_array)) {
        $_SESSION['currency_array'] = $c;
    }
}

4) I then calculate the product price.
Code: [Select]
$Total = $Price * $currency_array;

$outprice = number_format($Total, 2, '.', ',');

5) Then I output on the page
Code: [Select]
<?php echo .$outprice; ?>

So is all my coding logically in the right order?

Any help would be greatly appreciated.  Thank you.

Does anyone know how I can validate US currency using php that is entered into a textbox? The textbox is setup as a decimal in mysql and i'm trying to make sure only decimals are entered so when php calculates the values entered I don't receive errors.

Hi All,

Its been a while since i've posted, its good to be back.

I am currently trying to pull two exchange rates against the $ using YQL's restful url. Unfortunately I am having a huge problem returning the results correct.... currently my array will only output  a single rate (instead of two) and the hash array returns with the base rate name rather than the expected currency code.

I hope someone can help me sort this as it's given me quite a headache!

Please see the code below:

Code: [Select]
<?php
require_once('uwe_proxy.php');

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

# use the yahoo YQL rest service to return any number of rates in a hash 
function get_yahoo_rest_rate ($base, $curr_arr) { 
    
    $params = ''; 
    $rates = array(); 
     
    # define the YQL rest url head & tail 
    $yql_base_uri = "http://query.yahooapis.com/v1/public/yql"; 
    $yql_tail_uri = '&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys'; 
     
    # build up the $params value 
    foreach($curr_arr as $curr) { 
        $params .= $curr.$base.','; 
    } 
         
    #strip last comma 
    $params = substr($params, 0, -1); 
     
    # build the query with the params as comma sep. string eg. USDGBP,USDBOB,.. 
    $yql_query = "select * from yahoo.finance.xchange where pair IN ('{$params}')"; 
     
    # build the the complete YQL query 
    $yql_query_url = $yql_base_uri . "?q=" . urlencode($yql_query) . $yql_tail_uri; 
     
    # send the query via proxy and get as string and load as simplexml object 
    $yql_response = @simplexml_load_string(file_get_contents_proxy($yql_query_url)); 
    Print_r($yql_query_url); //- debugging only
    # process simplexml object and return a sorted hash of rates or FALSE on error 
    if ($yql_response) {
        
        foreach($yql_response->results->rate as $rate) { 
            if ((float)$rate->Rate>0) { 
                $rates[substr((string)$rate->attributes()->id, -3)] = (float)$rate->Rate; 
             
        } }
        ksort($rates); 
        return $rates; 
    } 
    else { 
        return FALSE; 
    }// print_r($yql_response); - debugging only
}


/////// - debugging only
$curr_arr = array('GBP','GBP');
$rates = get_yahoo_rest_rate ('USD', $curr_arr);
   //PRINT_R($yql_response);
print_r($rates);

?>
Sorry about dumping the whole lot - but I really don't know where this is going wrong!

Thanks in Advance for any help or pointers in the right direction!

Hi all

Would like to ask for help .

Generally I would like to run a webpage which will display actual price + price movements of selected cryptocurrencies.

I´m recieving data from extrernal API. (JSON)
.
I already integrated currency function (usd), but I need to add also function for showing percent (%) change . (at "24 hour change" section)

This is how code looks like:

<?php 
$json = file_get_contents('https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd&amp;include_market_cap=true;include_24hr_vol=true;include_24hr_change=true'); 
$bitcoinPrice = json_decode($json);
 
$json = file_get_contents('https://api.coingecko.com/api/v3/simple/price?ids=dash&vs_currencies=usd&amp;include_market_cap=true;include_24hr_vol=true;include_24hr_change=true'); 
$dashPrice = json_decode($json);

$json = file_get_contents('https://api.coingecko.com/api/v3/simple/price?ids=netchain&vs_currencies=usd&amp;include_market_cap=true;include_24hr_vol=true;include_24hr_change=true');
$netchainPrice = json_decode($json);

$json = file_get_contents('https://api.coingecko.com/api/v3/simple/price?ids=pivx&vs_currencies=usd&amp;include_market_cap=true;include_24hr_vol=true;include_24hr_change=true');
$pivxPrice = json_decode($json);

function formatter($amount) {
  // $formatter = new NumberFormatter('en_US',  NumberFormatter::CURRENCY);
  return '$'.number_format($amount, 2);;
}
 ?>
<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <meta http-equiv="x-ua-compatible" content="ie=edge">
  <title>Masternodes monitor</title>
  <!-- Font Awesome -->
  <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.8.2/css/all.css">
  <!-- Bootstrap core CSS -->
  <link href="css/bootstrap.min.css" rel="stylesheet">
  <!-- Material Design Bootstrap -->
  <link href="css/mdb.min.css" rel="stylesheet">
  <!-- Your custom styles (optional) -->
  <link href="css/style.css" rel="stylesheet">
  <!-- MDBootstrap Datatables  -->
<link href="css/addons/datatables.min.css" rel="stylesheet">
</head>

<body>

  <table id="dtBasicExample" class="table table-striped table-bordered table-sm" cellspacing="0" width="100%">
  <thead>
    <tr>
      <th class="th-sm">Coin name
      </th>
      <th class="th-sm">ROI
      </th>
      <th class="th-sm">Daily income
      </th>
      <th class="th-sm">Price 
      </th>
      <th class="th-sm">24 change 
      </th>
      <th class="th-sm">Volume
      </th>
      <th class="th-sm">Marketcap
      </th>
      <th class="th-sm">Node price
      </th>
      <th class="th-sm">Coins for MN
      </th>
      <th class="th-sm">Nodes
      </th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><img src="/img/btc.png" width="15" height="15" title="Bitcoin logo" alt="Bitcoin logo" />    Bitcoin (BTC)
</td>
      <td>Unknown</td>
      <td>Unknown</td>
      <td><?=formatter($bitcoinPrice->bitcoin->usd) ?></td>
      <td><?=formatter($bitcoinPrice->bitcoin->usd_24h_change) ?></td>
      <td><?=formatter($bitcoinPrice->bitcoin->usd_24h_vol) ?></td>
      <td><?=formatter($bitcoinPrice->bitcoin->usd_market_cap) ?></td>
       <td>Unknown</td>
       <td>Unknown</td>
       <td>Unknown</td>
    </tr>
     <tr>
      <td><img src="/img/pivx.png" width="15" height="15" title="Pivx logo" alt="Pivx logo" />   Pivx (PIVX)</td>
      <td>Unknown</td>
      <td>Unknown</td>
      <td><?=formatter($pivxPrice->pivx->usd) ?></td>
      <td><?=formatter($pivxPrice->pivx->usd_24h_change) ?></td>
      <td><?=formatter($pivxPrice->pivx->usd_24h_vol) ?></td>
      <td><?=formatter($pivxPrice->pivx->usd_market_cap) ?></td>
       <td>Unknown</td>
       <td>10,000</td>
       <td>1,536</td>
    </tr>
    <tr>
      <td><img src="/img/dash.png" width="15" height="15" title="Dash logo" alt="Dash logo" />    Dash (DASH)</td>
      <td>7.5%</td>
      <td>14,40 $</td>
      <td><?=formatter($dashPrice->dash->usd) ?></td>
      <td><?=formatter($dashPrice->dash->usd_24h_change) ?></td>
      <td><?=formatter($dashPrice->dash->usd_24h_vol) ?></td>
      <td><?=formatter($dashPrice->dash->usd_market_cap) ?></td>
      <td>$69,696.22</td>
      <td>1000</td>
      <td>4001</td>
    </tr>
    <tr>
      <td><img src="/img/ntx.png" width="15" height="15" title="Netchain logo" alt="Netchain logo" />    Netchain (NTX) </td>
      <td>350%</td>
      <td>0,12 $</td>
      <td>$0.00004</td>
      <td><?=formatter($netchainPrice->netchain->usd_24h_change) ?></td>
      <td><?=formatter($netchainPrice->netchain->usd_24h_vol) ?></td>
      <td><?=formatter($netchainPrice->netchain->usd_market_cap) ?></td>
      <td>$7</td>
      <td>100.000</td>
      <td>55</td>
    </tr>
      </tbody>
  <tfoot>
    <tr>
      <th>Coin name
      </th>
      <th>ROI
      </th>
      <th>Daily income
      </th>
      <th>Price 
      </th>
      <th>24 change 
      </th>
      <th>Volume
      </th>
      <th>Marketcap
      </th>
      <th>Node price
      </th>
      <th>Coins for MN
      </th>
      <th>Nodes
      </th>
    </tr>
  </tfoot>
</table>

  <!-- SCRIPTS -->
  <!-- JQuery -->
  <script type="text/javascript" src="js/jquery-3.4.1.min.js"></script>
  <!-- Bootstrap tooltips -->
  <script type="text/javascript" src="js/popper.min.js"></script>
  <!-- Bootstrap core JavaScript -->
  <script type="text/javascript" src="js/bootstrap.min.js"></script>
  <!-- MDB core JavaScript -->
  <script type="text/javascript" src="js/mdb.min.js"></script>
  <!-- MDBootstrap Datatables  -->
<script type="text/javascript" src="js/addons/datatables.min.js"></script>
<script>
$(document).ready(function () {
$('#dtBasicExample').DataTable();
$('.dataTables_length').addClass('bs-select');
setTimeout(function() {
    location.reload();
}, 900000);
});
</script>
</body>

</html>

 

I need section usd_24h_change in percent %.
How to do that?

I tryed :

<td><($bitcoinPrice->dash->usd_24h_change) ? % ></td> 
<td><($dashPrice->dash->usd_24h_change) ? % ></td> 
<td><($netchainPrice->dash->usd_24h_change) ? % ></td> 
<td><($pivxPrice->dash->usd_24h_change) ? % ></td> 

But it doesn´t work… Please help

Edited October 26, 2019 by Netchain

echo "<font color='000000'>No Service Found At<br /></font>"<font color='000000'> .long2ip($ip)</font>;

Hi im desperately in need of some help here..
Im exporting my html page data to csv but i am unable to get the data onto a new column the code is as follows

HTML FORM
Code: [Select]
<form id="form1" name="form1" method="post" action="index.php">
    <table class="formatTblClass">
    <tr>
    <th colspan="6"><?=$message;?></th>
    </tr>
    <tr>
    <td width="68"><span>First Name</span></td>
    <td width="215"><input class="Name" type="text" name="fn" id="fn" /></td>
    <td width="62"><span>Last Name</span></td>
    <td colspan="3"><input class="Name" name="ln" type="text" id="ln" size="50" /></td>
    </tr>
    <tr>
    <td colspan="6"><table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
    <td width="71">Address</td>
    <td width="721"><input class="Address" name="address" type="text" id="address" size="100" /></td>
    </tr>
    </table></td>
    </tr>
    <tr>
    <td><span>City</span></td>
    <td><input class="City" type="text" name="city" id="city" /></td>
    <td><span>State</span></td>
    <td width="148"><input class="State" type="text" name="state" id="state" /></td>
    <td width="24"><span>ZIP</span></td>
    <td width="255"><input class="ZIP" type="text" name="zip" id="zip" /></td>
    </tr>
    <tr>
    <td><span>Phone</span></td>
    <td><input class="Phone" type="text" name="phone" id="phone" /></td>
    <td><span>Email</span></td>
    <td><input class="Email" type="text" name="email" id="email" /></td>
    <td><input name="emailMe" type="checkbox" id="emailMe" value="Yes" checked="checked" /></td>
    <td>Please send me email</td>
    </tr>
    <tr>
    <td colspan="6"><span>Comments
    <textarea name="comments" id="comments" cols="45" rows="5"></textarea>
    </span>
    <div align="center">
    <input type="submit" name="Submit" id="Submit" value="Submit" />
    <input type="reset" name="Reset" id="button" value="Reset" />
    </div></td>
    </tr>
    </table>
    </form>
<?php
     
    // Receiving variables
    @$pfw_ip= $_SERVER['REMOTE_ADDR'];
    @$fn = addslashes($_POST['fn']);
    @$ln = addslashes($_POST['ln']);
    @$address = addslashes($_POST['address']);
    @$city = addslashes($_POST['city']);
    @$state = addslashes($_POST['state']);
    @$zip = addslashes($_POST['zip']);
    @$phone = addslashes($_POST['phone']);
    @$email = addslashes($_POST['email']);
    @$emailMe = addslashes($_POST['emailMe']);
    @$comments = addslashes($_POST['comments']);
     
    // Validation
    //saving record in a text file
    $pfw_file_name = "formtest.csv";
    $pfw_first_raw = "fn,\rln,\raddress,\rcity,\rstate,\rzip,\rphone,\remail,\remailMe,\rcomments\r\n";
    $pfw_values = "$fn,\r$ln,\r$address,\r$city,\r$state,\r$zip,\r$phone,\r$email,\r$emailMe,\r".str_replace ("\r\n","<BR>",$comments )."\r\n";
    $pfw_is_first_row = false;
    if(!file_exists($pfw_file_name))
    {
    $pfw_is_first_row = true ;
    }
    if (!$pfw_handle = fopen($pfw_file_name, 'a+')) {
    die("Cannot open file ($pfw_file_name)");
    exit;
    }
    if ($pfw_is_first_row)
    {
    if (fwrite($pfw_handle, $pfw_first_raw ) === FALSE) {
    die("Cannot write to file ($pfw_filename)");
    exit;
    }
    }
    if (fwrite($pfw_handle, $pfw_values) === FALSE) {
    die("Cannot write to file ($pfw_filename)");
    exit;
    }
    fclose($pfw_handle);
     
    echo("<p align='center'><font face='Arial' size='3' color='#FF0000'>thanx</font></p>");
    ?>

THIS IS THE OUTPUT I GET

fn
ln
address
city
state
zip
phone
email
emailMe
comments
Tom
Sawyer
shady lane
new york
new york
NY124
123456789
tom@sawyer.com
Yes
comments



THIS IS THE OUTPUT I AM LOOKING FOR
fn Tom Harry
ln Sawyer Potter
address shady lane magic lane
city new york xyz
state new york xyz
zip NY124 12343
phone 123456789 987654321
email tom@sawyer.com harry@magic.co.uk
emailMe Yes Yes
comments comments this is the comment


please help me on this one.. unable to get the script export the data in top to bottom columnwise format