PHP - Free Currency Conversion Api?

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;
         }
}



?>

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>

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,
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)

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 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

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.

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.

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

I need free php chat module or script.
Please tell me any known or good script.
thanks

This topic has been moved to PHP Freelancing.

http://www.phpfreaks.com/forums/index.php?topic=308040.0

Good morning,

First, I want to thank this forum for all the help provided to me. I am new to Php programming, and honestly, I am still not good at reading codes. I am somehow able to understand how the code is written, but I am still learning, and I know myself, I still have lots to learn. I was able to finish now my very php project, again, thanks to this site and to other forum sites I have visited, and for my friends who helped as well. The web application I made is working fine now, but as I look into it, I know that once the database is populated with information, I will be required to put up pagination on my search page. And so, I looked online for pagination tutorials. I have found some, but I have to admit, it is still hard for me to comprehend the scripts I found. Just today, I found a script that I think would be a very good implementation to the web application I made. The problem is, I am not well familiar with adopting pre-made codes to the one I did, plus the fact that I can't well understand how the code is written. Can anyone help me implement the code, and somehow provide comments on the pre-made code I found in the web? Thank you in advanced for your responses.

Here's my code:


<link href="add_client.css" rel="stylesheet" type="text/css">

<?PHP
include("dbconnection.php");



$query = "SELECT * FROM records";
$result = array();

if(isset($_POST["btnSearch"]))

{
$query .= " WHERE last_name LIKE '%".$_POST["search"]."%' OR first_name LIKE '%".$_POST["search"]."%'OR territory LIKE '%".$_POST["search"]."%'OR job_title LIKE '%".$_POST["search"]."%'OR title LIKE '%".$_POST["search"]."%'OR employer LIKE '%".$_POST["search"]."%' ORDER BY territory ASC"  ;

$result = mysql_query($query, $connection) or die(mysql_error());

} 

?>

<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><table width="760" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="199" align="center" valign="top"><a href="login.html"><img src="invent-asia.gif" alt="" width="152" height="58" border="0" /></a>        <script type="text/javascript" src="menu.js"></script></td>
        <td width="176" align="right" valign="bottom"><a href="main.php"><img src="Home.jpg" width="104" height="20" border="0"/></a></td>
        <td width="130" align="right" valign="bottom"><img src="View.jpg" width="104" height="20" border="0"/></td>
        <td width="146" align="right" valign="bottom"><a href="add_client.php"><img src="Add.jpg" width="104" height="20" border="0"/></a></td>
        <td width="109" align="right" valign="bottom">&nbsp;</td>
        </tr>

    </table></td>
  </tr>
  <tr>
    <td><table width="760" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="200" height="3"  bgcolor="#1B1C78"><img src="images/topspacerblue.gif" alt="" width="1" height="3" /></td>
        <td width="560"  bgcolor="#0076CC"><img src="images/topspacerlblue.gif" alt="" width="1" height="3" /></td>

      </tr>
    </table></td>

  </tr>
  <tr>
    <td height="553" align="center" valign="top" bgcolor="#F3FAFE"><br />

      <form name="form" action="view_client.php" method="post">
        <br />
      <table width="351" border="0">
          <tr>
            <td width="137" align="left" valign="middle">SEARCH RECORD:</td>
            <td width="144" align="center" valign="middle"><input type="text" name="search" /></td>
            <td width="56" align="left" valign="middle"><input type="submit" name="btnSearch" value="Search" /></td>
          </tr>
        </table>
        <br />
        <table border="0" cellpadding="3" cellspacing="1" bordercolor="38619E" >
          <tr>
            <th width="80" align="center" bgcolor="#E0E8F3">Territory</th>
            <th width="330" align="center" bgcolor="#E0E8F3">Employer</th>
             <th width="160" align="center" bgcolor="#E0E8F3">Name</th>
            <th width="80" align="center" valign="middle" bgcolor="#E0E8F3">&nbsp;</th>
          </tr>
  <?php
  if($result)
  {
  for($i=0; $i<mysql_num_rows($result); $i++)
  {
  $id = trim(mysql_result($result, $i, "id"));
  $territory = trim(mysql_result($result, $i, "territory"));
  $employer = trim(mysql_result($result, $i, "employer"));
  $first_name = trim(mysql_result($result, $i, "first_name"));
  $last_name = trim(mysql_result($result, $i, "last_name"));
  
  echo "<tr>";
     echo "<td>".$territory."</td>";
  echo "<td>".$employer."</td>";
  echo "<td>".$last_name.", ".$first_name."</td>";
  echo "<td><a href='edit_client.php?id=".$id."'>edit</a> | <a href='delete_client.php?id=".$id."'>delete</a> </td>";
  echo "</tr>";
  }
  }
  
  ?>
  
        </table>
        <p><br />
        </p>
      </form>
    <p>&nbsp;</p></td>

  </tr>
  <tr>
    <td height="38"><table width="760" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="200" height="35" align="center"  bgcolor="#1B1C78" class=white><img src="images/topspacerblue.gif" alt="" width="1" height="3" />&nbsp;<a href="disclaimer.html"><font color="#FFFFFF">Legal Disclaimer</font></a> </td>

        <td width="560" align="center"  bgcolor="#0076CC"  class=white><img src="images/topspacerlblue.gif" alt="" width="1" height="3" />&nbsp;Copyright &copy; 2006 - 2010 InventAsia Limited. All rights reserved.
</td>
      </tr>

    </table></td>
  </tr>
</table>


And here is the link of the pagination script I found:

http://www.phpeasycode.com/pagination/

I'd rather have the pagination style of the first one.

Note:

I am not trying to be spoon fed here, but really in this case, I have tried what I think should work, but Sorry guys.

(The way my code is written, you should see that I am a noob xD)

 I am trying to get around the login on one page on my server that my developer did but, now has decided to disappear. I know a little C++ but hardly no PHP.
Any one may view the thumbs but, when you click on the thumbnail you will be prompted to login. Which is fine what, I want, except for one page. I separated out the videos that I wanted to be free, created a new database table for them and wrote a function to lay out the thumbs to the screen but, you still get prompted to login.

I thought there was a way to do it using $_SESSION or $_SERVER but, I just can't seem to get it to work.

Any help would be appreciated. I've just spent to much time on this problem and I've got so any more to fix.

Thanks grggfks