Search Tabular Weather Data Select a date range to view hourly weather statistics for that time period All Times are UTC/GMT (+8 Hours from PST) “; $month = gmdate(‘m’, strtotime(‘-1 month’)); $monthcount = 1; while ($monthcount <= 12) { $monthname = date('F', mktime(00,01,00,$monthcount,1,gmdate('Y'))); $monthcount = date('m', mktime(00,01,00,$monthcount,1,gmdate('Y'))); if ($monthcount == $month) { echo "$monthname“; } else { echo “$monthname“; } $monthcount++; } echo ““; echo ““; $day = gmdate(‘d’); $newdate = date(‘d’, strtotime(“-1 day”, strtotime(date(‘d.m.Y’, mktime(00,01,00,gmdate(‘m’, strtotime(“+1 month”)),1,gmdate(‘Y’)))))); while ($newdate <= 31 && $newdate >= $day ) { if ($newdate == $day) { echo “$newdate“; } else { echo “$newdate“; } $newdate = date(‘d’, strtotime(“-1 day”, strtotime(date(‘d.m.Y’, mktime(00,01,00,gmdate(‘m’),$newdate,gmdate(‘Y’)))))); } while ($newdate < $day && $newdate > 0 ) { echo “$newdate“; $newdate = date(‘d’, strtotime(“-1 day”, strtotime(date(‘d.m.Y’, mktime(00,01,00,gmdate(‘m’),$newdate,gmdate(‘Y’)))))); } echo ““; //Create the year pull-down menu. echo ““; while ($Year >= 2005) { echo “$Year“; $Year–; } echo ““; echo ““; $hour = gmdate(‘H’); $hourcount = 0; while ($hourcount <= 23) { //$hourcount = date('H', mktime(01,01,00,01,1,gmdate('Y'))); if ($hourcount < 10) { $hourcount = '0' . $hourcount; } if ($hourcount == $hour) { echo "$hourcount“; } else { echo “$hourcount“; } $hourcount++; } echo ““; echo “”; ?>Ending:“; $month = gmdate(‘m’); $monthcount = 1; while ($monthcount <= 12) { $monthname = date('F', mktime(00,01,00,$monthcount,1,gmdate('Y'))); $monthcount = date('m', mktime(00,01,00,$monthcount,1,gmdate('Y'))); if ($monthcount == $month) { echo "$monthname“; } else { echo “$monthname“; } $monthcount++; } echo ““; echo ““; $day = gmdate(‘d’); $newdate = date(‘d’, strtotime(“-1 day”, strtotime(date(‘d.m.Y’, mktime(00,01,00,gmdate(‘m’, strtotime(“+1 month”)),1,gmdate(‘Y’)))))); while ($newdate <= 31 && $newdate >= $day ) { if ($newdate == $day) { echo “$newdate“; } else { echo “$newdate“; } $newdate = date(‘d’, strtotime(“-1 day”, strtotime(date(‘d.m.Y’, mktime(00,01,00,gmdate(‘m’),$newdate,gmdate(‘Y’)))))); } while ($newdate < $day && $newdate > 0 ) { echo “$newdate“; $newdate = date(‘d’, strtotime(“-1 day”, strtotime(date(‘d.m.Y’, mktime(00,01,00,gmdate(‘m’),$newdate,gmdate(‘Y’)))))); } echo ““; //Create the year pull-down menu. echo ““; while ($Year >= 2005) { echo “$Year“; $Year–; } echo ““; echo ““; $hour = gmdate(‘H’); $hourcount = 0; while ($hourcount <= 23) { //$hourcount = date('H', mktime(01,01,00,01,1,gmdate('Y'))); if ($hourcount < 10) { $hourcount = $hourcount; } if ($hourcount == $hour) { echo "$hourcount“; } else { echo “$hourcount“; } $hourcount++; } echo ““; echo “”; ?> ‘; echo $weatherperiod[endtime]; echo ‘‘; $weatherArray = unitConverter($weatherperiod); //echo $weatherperiod[Custom]; $i = 1; ?> UTCTime ‘; echo ‘ Temp ‘; echo ‘ Barom ‘; echo ‘ Humid ‘; echo ‘ Rain ‘; echo ‘ HiRainRate ‘; echo ‘ Wind ‘; echo ‘ HiWind ‘; echo ‘ WdDir ‘; echo ‘ HiWdDir ‘; echo ‘ Dew ‘; echo ‘ Chill ‘; echo ‘ HeatIdx ‘; echo ‘ SolRad ‘; echo ‘ UV ‘; echo ‘ Evap ‘; echo ‘ ‘; //echo $weatherArray[SQLData][RecordTime][3]; $countresult = count($weatherArray[SQLData][RecordTime]); $j = 0; $HiRainRate = 0; $HiWindSpeed = 0; while ($i <= $countresult) { if ($j == 12) { echo ' ‘; echo ‘ ‘; echo $weatherArray[SQLData][RecordTime][$i]; echo ‘ ‘; echo ‘ ‘; echo $weatherArray[SQLData][OutTemp][$i]; echo $weatherArray[tempUnit]; echo ‘ ‘; echo ‘ ‘; echo $weatherArray[SQLData][Barometer][$i]; echo ‘hPa’; echo ‘ ‘; echo ‘ ‘; echo $weatherArray[SQLData][OutHumid][$i]; echo $weatherArray[humUnit]; echo ‘ ‘; echo ‘ ‘; echo $rainSum; echo $weatherArray[rainUnit]; echo ‘ ‘; echo ‘ ‘; echo $HiRainRate; echo $weatherArray[rainUnit]; echo ‘ ‘; echo ‘ ‘; echo $weatherArray[SQLData][WindSpeed][$i]; echo $weatherArray[windUnit]; echo ‘ ‘; echo ‘ ‘; echo $HiWindSpeed; echo $weatherArray[windUnit]; echo ‘ ‘; echo ‘ ‘; echo $weatherArray[SQLData][WindDir][$i]; echo ‘ ‘; echo ‘ ‘; echo $HiWindDir; echo ‘ ‘; echo ‘ ‘; echo $weatherArray[SQLData][Dewpoint][$i]; echo $weatherArray[tempUnit]; echo ‘ ‘; echo ‘ ‘; echo $weatherArray[SQLData][WindChill][$i]; echo $weatherArray[tempUnit]; echo ‘ ‘; echo ‘ ‘; echo $weatherArray[SQLData][HeatIndex][$i]; echo $weatherArray[tempUnit]; echo ‘ ‘; echo ‘ ‘; echo $weatherArray[SQLData][SolarRadSQL][$i]; echo $weatherArray[solarUnit]; echo ‘ ‘; echo ‘ ‘; echo $weatherArray[SQLData][UVSQL][$i]; echo ‘ ‘; echo ‘ ‘; echo $etSum; echo $weatherArray[rainUnit]; echo ‘ ‘; echo ‘ ‘; $i++; $j = 1; $rainSum = $weatherArray[SQLData][Rain][$i]*10; $etSum = $weatherArray[SQLData][ET][$i]*10; $HiRainRate = $weatherArray[SQLData][HiRainRate][$i]; $HiWindSpeed = $weatherArray[SQLData][HiWindSpeed][$i]; } else { $j++; $i++; $rainSum = $rainSum + ($weatherArray[SQLData][Rain][$i]*10); $etSum = $etSum + ($weatherArray[SQLData][ET][$i]*10); if ($HiRainRate < $weatherArray[SQLData][HiRainRate][$i]) { $HiRainRate = $weatherArray[SQLData][HiRainRate][$i]; } if ($HiWindSpeed < $weatherArray[SQLData][HiWindSpeed][$i]) { $HiWindSpeed = $weatherArray[SQLData][HiWindSpeed][$i]; $HiWindDir = $weatherArray[SQLData][HiWindDir][$i]; } } } echo ' ‘; } else { echo ‘ Waiting for Your Selection ‘; } ?>