Update daily USD to EUR exchange rate in PHP using openexchangerates.org
The process, loops for the last days and call the API of openexchangerates.org, storing in the database the daily conversion from USD to EUR.
require_once('./conf/config.php'); require_once('./models/exchanges.php'); $exchanges=new exchanges(); $days = array(); for($i = 1; $i < 10; $i++) { $days[] = date("Y-m-d", strtotime('-'. $i .' days')); } foreach ($days as $day) { $json = file_get_contents('http://openexchangerates.org/api/historical/'.$day.'.json?app_id=YOURAPIID'); $data = json_decode($json, TRUE); $conversion=$data['rates']['EUR']; if ($exchanges->exists($day)) { $ret=$exchanges->update($day, $conversion); } else { $ret=$exchanges->insert($day, $conversion); } echo($day.' '.$conversion.' '.$ret).SEP; }
Enjoy!!!