// Calculate 3hr moving baro pressure
$moving_barom_press = 0.0;
find_barop_3hr_ave(toHpaBarom($conn, $_POST['baromrelin']), $moving_barom_press);
function find_barop_3hr_ave($curr_barom_press, &$moving_barom)
{
// calculate 3 hour moving ave for barometrix pressure
$hrsAgo = 3;;
$tStep = 15;
$minsAgo = $hrsAgo * 60;
$minStart = $minsAgo - $tStep;
$minEnd = $minsAgo + $tStep;
$sql = " SELECT AVG(baromrelhpa) AS av_val FROM weather_data_metric WHERE
dateacst BETWEEN DATE_ADD(NOW(), INTERVAL -190 MINUTE)
AND DATE_ADD(NOW(), INTERVAL -170 MINUTE) ";
// $sql = " SELECT (baromrelhpa) AS av_val FROM weather_data_metric WHERE
// dateacst BETWEEN DATE_ADD(NOW(), INTERVAL -" . $mE . " MINUTE)
// AND DATE_ADD(NOW(), INTERVAL -" . $mS . " MINUTE) ";
// $result = $conn->query($sql);
// $row = $result->fetch_assoc();
/*
if ($result == true) {
$moving_barom = 1.0;
}
else
{
$moving_barom = 2.0;
}
*/
/*
if ($result && $row = mysqli_fetch_assoc($result)) {
// Check if the result is not null (in case no rows matched the time range
if ($row['avg_val'] !== null) {
$moving_barom = $curr_barom_press - $row['avg_val'];
} else {
// no average found
$moving_barom = 0.0;
}
}
*/
$moving_barom = $curr_barom_press/100;
}
*/
Some changes ands requests.
Change "Feels Like" to apparent.
Added a function to get average rainfall current month - to be compared to current month:
function getMthAvg().
avg_visibility is already in kms, no need to /1000.
`ave_wind_sp` decimal(5,2) DEFAULT NULL, current wind speed.
`10min_max_wind` decimal(5,2) DEFAULT NULL, max gust for the same period as ave_wind_sp.
`winddir_cardinal` varchar(10) DEFAULT NULL, dirextion for the above.
`maxdailygustkmh` decimal(5,2) DEFAULT NULL, daily maximum, so far.
connect_error) { die("Connection failed"); }
// Fetch Latest Metric Data
$metric = $conn->query("SELECT * FROM weather_data_metric ORDER BY dateacst DESC LIMIT 1")->fetch_assoc();
// Fetch Latest BOM Observations
$bom_obs = $conn->query("SELECT * FROM bom_obs_readings ORDER BY created_at DESC LIMIT 1")->fetch_assoc();
// Fetch Latest Forecast
$forecast = $conn->query("SELECT * FROM weather_forecasts ORDER BY created_at DESC LIMIT 1")->fetch_assoc();
if (!$metric) { echo "No data found."; exit; }
// Get average rainfall current month
function getMthAvg()
{
$cMth = (int)date("m")-1;
$mthAvg = array(20.1, 20.5, 23.5, 43.7, 67.9, 71.6, 65.7, 61.5, 50.8, 44.3, 30.9, 25.9);
return $mthAvg[$cMth];
}
?>
Weather Dashboard
Weather Station
Last Update:
Current Conditions
Temperature
°C
Feels like °C
Rain (Today)
mm
Month: mm
Atmospheric & UV
Forecast
Today's Outlook
°C
rain ()
Tomorrow
°C / °C
Issued: