$curl = curl_init();
curl_setopt_array($curl, array(CURLOPT_RETURNTRANSFER => 1, CURLOPT_URL => $config['url'], CURLOPT_SSL_VERIFYPEER => false, CURLOPT_SSL_VERIFYHOST => false));
$resp = curl_exec($curl);
curl_close($curl);
}
//current data in array
$data = json_decode($resp, true);
//---------------------------------------------------
//getting the datetime & converting to to UT & setting it in the array
$datetime = explode('T', $data['query']['created']);
$date = $datetime[0];
$time = explode('Z', $datetime[1]);
$time = $time[0];
$created = $data['query']['created'];
$data = $data['query']['results']['rate'];
for ($i = 0; $i < count($data); $i++) {
$data[$i]['Date'] = $date;
$data[$i]['Time'] = $time;
$data[$i]['Datetime'] = $date . ' ' . $time;
}
//---------------------------------------------------
// _print_r($data);
//---------------------------------------------------
// insert into db
$db = new Database($config);
$db->insert_minute($config['db']['minute_table'], $data);
//---------------------------------------------------
//---------------------------------------------------
// delete data from the minute table according to the settings
$db->del($config['db']['minute_table'], $config['minute_table_range']);
//---------------------------------------------------
