혹시 이 걸까요??
<?php
function exchange_currency(){
//$exchange_url = "http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22USDKRW,EURKRW,JPYKRW,CNYKRW%22)&format=json&env=store://datatables.org/alltableswithkeys&callback=";
$exchange_url = "http://api.manana.kr/exchange/rate/KRW/EUR,JPY,USD,CNY.json";
//http://data.fixer.io/api/latest?access_key=f5c328af24a323ce3e36bbd124c34d6b&base=EUR&symbols=KRW,USD,CNY,JPY
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $exchange_url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 1000);
$rt = curl_exec($ch);
curl_close($ch);
$obj = json_decode($rt);
$query = "INSERT INTO exchange_currency SET ";
foreach($obj as $key => $value){
$value->name = substr($value->name, 0, 3);
// echo($value->date." | ".$value->name." | ". $value->rate); // 환율 넣기...
$query .= $value->name."= '".$value->rate."', ";
echo "<br>";
}
// echo " CNY: 154.3, USD: 994, EUR: 1130, JPY: 898";
$query .= 'reg_date = now() ';
//1시간 이내의 업데이트가 없으면 환율 업데이트.
$sql = "select count(*) as cnt from exchange_currency WHERE reg_date > DATE_ADD( NOW() , INTERVAL -1 HOUR ) limit 1";
$result = sql_query($sql);
$chk_row = sql_fetch_array($result);
$ret_msg = 0;
// echo '업데이트 갯수:::'.$chk_row['cnt'];
if($chk_row['cnt'] == 0) {
sql_query($query);
$ret_msg =1;
}
return $ret_msg;
}
//환율정보 가져오기_
function getCurrency($basic_currency_field){
// echo "getCurreccy=".$basic_currency_field;
if(basic_currency_field !=''){
$sql = "select ".$basic_currency_field." from exchange_currency order by reg_date DESC limit 1";
$result = sql_query($sql);
$cData = sql_fetch_array($result);
return $cData[$basic_currency_field];
}else{
return $basic_currency_field;
}
}
//환율전체정보 가져오기
function getAllCurrtrency(){
$sql = "select CNY, EUR, JPY, USD from exchange_currency order by reg_date DESC limit 1";
$result = sql_query($sql);
$cData = sql_fetch_array($result);
return $cData;
}
?>