$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']); //---------------------------------------------------