X-Git-Url: https://git.rvb.name/weathermon.git/blobdiff_plain/e4e1557426f8e5ca10ca616140528939d86426cd..97f7c41a685adb43850c799f9f5ae3a9b38efd96:/web/index.php?ds=sidebyside
diff --git a/web/index.php b/web/index.php
index dfc7450..37251e6 100644
--- a/web/index.php
+++ b/web/index.php
@@ -2,6 +2,7 @@
false)))) {
die($err);
@@ -38,16 +47,57 @@ $q -> execute();
while ($row = $q -> fetch(PDO::FETCH_ASSOC)) {
- echo '
'.$row['s_description'].'/'.$row['st_description'].'
';
+ echo '
';
+ echo '';
+
+$ql = $db -> prepare(
+ '
+ SELECT unix_timestamp(timestamp) timestamp,DATE_FORMAT(timestamp,"%H:%i") printable,value
+ FROM
+ meteo.sensor_values
+ WHERE
+ sensor_id='.$row['sensor_id'].' and parameter_id='.$row['param_id'].' and timestamp>addtime(now(), -3600)
+ ORDER BY
+ timestamp desc
+ '
+ );
+
+$ql -> execute();
+
+$printable_ts = "?";
+$value = "?";
+
+if ($rowl = $ql -> fetch(PDO::FETCH_ASSOC)) {
+
+ $timestamp = $rowl['timestamp'];
+ $printable_ts = $rowl['printable'];
+ $value = $rowl['value'];
+
+ $units = get_unit($db,$row['param_id']);
+ $from_unit = $units['from'];
+ $to_unit = $units['to'];
+ $param_unit = $units['name'];
+
+ $val = convert_unit($db,$value,$from_unit,$to_unit);
+
+}
+
+echo '
'.$printable_ts.'
';
+echo '
'.$val.' '.$param_unit.'
';
?>
-
+
";
+
}
?>
+
+
\ No newline at end of file