{'current_observation'}->{'weather'};
$CC_temp = $conditionsphp->{'current_observation'}->{'temp_c'};
$CC_humid = $conditionsphp->{'current_observation'}->{'relative_humidity'};
$CC_winddir = $conditionsphp->{'current_observation'}->{'wind_dir'};
$CC_windkm = $conditionsphp->{'current_observation'}->{'wind_kph'};
$CC_windrafkm = $conditionsphp->{'current_observation'}->{'wind_gust_kph'};
$CC_press = $conditionsphp->{'current_observation'}->{'pressure_mb'};
$CC_tempr = $conditionsphp->{'current_observation'}->{'feelslike_c'};
$CC_precipq = $conditionsphp->{'current_observation'}->{'precip_today_metric'};
$CC_icon = $conditionsphp->{'current_observation'}->{'icon'};
$idmhnow=time();
$suncomp = date_sun_info($idmhnow, 49.3167, -0.005978099999992992);
//echo date("d/m/Y - H",$idmh).'-'.$idmh.' / '.date("d/m/Y H:i",$suncomp['sunrise']).'-'.$suncomp['sunrise'].' / '.date("d/m/Y H:i",$suncomp['sunset']).'-'.$suncomp['sunset'].' : ';
if(date("H",$idmhnow)<12){
if($idmhnow>=abs($suncomp['sunrise'])){$CC_icon=$Dtabiconmean[$CC_icon];}
else {$CC_icon=$Ntabiconmean[$CC_icon];}
}
else{
if($idmhnow>=abs($suncomp['sunset'])){$CC_icon=$Ntabiconmean[$CC_icon];}
else {$CC_icon=$Dtabiconmean[$CC_icon];}
}
echo $CC_lib.' '.$CC_temp.' '.$CC_humid.' '.$CC_winddir.' '.$CC_windkm.' '.$CC_windrafkm.' '.$CC_press.' '.$CC_tempr.' '.$CC_precipq.' '.$CC_icon.'
';
$update="INSERT INTO $db31 (id, CC_lib, CC_temp, CC_humid, CC_winddir, CC_windkm, CC_windrafkm, CC_press, CC_tempr, CC_precipq, CC_icon) VALUES ($tstd, '$CC_lib', '$CC_temp', '$CC_humid', '$CC_winddir', '$CC_windkm', '$CC_windrafkm', '$CC_press', '$CC_tempr', '$CC_precipq', '$CC_icon') ON DUPLICATE KEY UPDATE CC_lib='$CC_lib', CC_temp='$CC_temp', CC_humid='$CC_humid',CC_winddir='$CC_winddir', CC_windkm='$CC_windkm', CC_windrafkm='$CC_windrafkm', CC_press='$CC_press', CC_tempr='$CC_tempr', CC_precipq='$CC_precipq', CC_icon='$CC_icon'";
$result = mysql_query($update) or die(mysql_error());
$urlforecast="forecast.json";
$forecastjson = file_get_contents($urlforecast);
$forecastphp = json_decode($forecastjson,true);
$indjn=0;
$indJ=0;
foreach($forecastphp['forecast']['txt_forecast']['forecastday'] as $key => $value){
$valid=($indJ*86400)+$tstd;
$fcttext_metric=explode('.',$value['fcttext_metric']);
$condition=addslashes($fcttext_metric[0]);
if(substr($fcttext_metric[1],1,4)=="Mini" || substr($fcttext_metric[1],1,4)=="Maxi"){
$temp=substr($fcttext_metric[1],13);
$wind=addslashes($fcttext_metric[2]);
}
else{
$condition.='. '.addslashes($fcttext_metric[1]);
$temp=substr($fcttext_metric[2],13);
$wind=addslashes($fcttext_metric[3]);
}
$pop=$value['pop'];
if($indjn==0){
$indjn=1;
$today6=mktime(6,0,0,date('n',$valid),date('j',$valid),date('Y',$valid));
$sun_info = date_sun_info($today6, 49.3167, -0.005978099999992992);
$sunrise=date("H:i",$sun_info['sunrise']);
$sunset=date("H:i",$sun_info['sunset']);
}
else if($indjn==1){
$indjn=0;
$indJ++;
}
if($indjn==0)$icon=$Ntabiconmean[$value['icon']];
else if($indjn==1)$icon=$Dtabiconmean[$value['icon']];
echo date('d m Y',$valid).'/'.$indjn.'/'.$condition.'/'.$temp.'/'.$wind.'/'.$pop.'/'.$sunrise.'/'.$sunset.'/'.$icon.'--'.$value['fcttext_metric'].'
';
if($indjn==1) $update="INSERT INTO $db31 (id, D_icon, D_condition, D_temp, D_wind, D_pop, s_set, s_rise) VALUES ($valid, '$icon', '$condition', '$temp', '$wind', '$pop', '$sunset', '$sunrise') ON DUPLICATE KEY UPDATE D_icon='$icon', D_condition='$condition', D_temp='$temp',D_wind='$wind', D_pop='$pop', s_set='$sunset', s_rise='$sunrise'";
if($indjn==0) $update="INSERT INTO $db31 (id, N_icon, N_condition, N_temp, N_wind, N_pop) VALUES ($valid, '$icon', '$condition', '$temp', '$wind', '$pop') ON DUPLICATE KEY UPDATE N_icon='$icon', N_condition='$condition', N_temp='$temp',N_wind='$wind', N_pop='$pop'";
$result = mysql_query($update) or die(mysql_error());
}
$urlhourly="hourly.json";
$hourlyjson = file_get_contents($urlhourly);
$hourlyphp = json_decode($hourlyjson,true);
foreach($hourlyphp['hourly_forecast'] as $key => $value){
$idmh=abs($value['FCTTIME']['epoch']);
$suncomp = date_sun_info($idmh, 49.3167, -0.005978099999992992);
//echo date("d/m/Y - H",$idmh).'-'.$idmh.' / '.date("d/m/Y H:i",$suncomp['sunrise']).'-'.$suncomp['sunrise'].' / '.date("d/m/Y H:i",$suncomp['sunset']).'-'.$suncomp['sunset'].' : ';
if(date("H",$idmh)<12){
if($idmh>=abs($suncomp['sunrise'])){$icon=$Dtabiconmean[$value['icon']];}
else {$icon=$Ntabiconmean[$value['icon']];}
}
else{
if($idmh>=abs($suncomp['sunset'])){$icon=$Ntabiconmean[$value['icon']];}
else {$icon=$Dtabiconmean[$value['icon']];}
}
$temp=$value['temp']['metric'];
$condition=addslashes($value['condition']);
//$icon=$value['icon'];
$update="INSERT INTO $db30 (id, mtemp, mcondition, micon) VALUES ($idmh, '$temp', '$condition', '$icon') ON DUPLICATE KEY UPDATE mtemp='$temp', mcondition='$condition', micon='$icon'";
$result = mysql_query($update) or die(mysql_error());
}
?>