iwa-panda1

commit 037b8221e27a58c8e6312c1febced08cbc939a85
parent f356ec134cfd137c90a33de4ee43d6c265f6b1ef
Author: Kninteman <[email protected]>
Date:   Sat, 25 Mar 2023 15:32:24 +0100

Create datavalidator.php

Diffstat:
A
datavalidator.php
 | 
24
++++++++++++++++++++++++

1 file changed, 24 insertions(+), 0 deletions(-)
diff --git a/datavalidator.php b/datavalidator.php
@@ -0,0 +1,23 @@
+<?php
+/**
+ * @param $sname
+ * @param $temp
+ * @param $conn
+ * @return int
+ */
+function validate_temperature($sname, $temp, $conn) {
+    // Retrieve the average of the last 20 rows for the given station name
+    $sql = "SELECT AVG(temp) AS avg_temp FROM (SELECT temp FROM weerdata 
+                                               WHERE station_name = $sname 
+                                               ORDER BY datum_tijd 
+                                               DESC LIMIT 20) AS last_20_rows";
+    $result = mysqli_query($conn, $sql);
+    $avg_temp = mysqli_fetch_assoc($result)['avg_temp'];
+
+    // Check if $temp is within 20% difference from average temperature in database
+    if(abs($temp - $avg_temp) / $avg_temp > 0.2) {
+        return 0;
+    } else {
+        return 1;
+    }
+}
+\ No newline at end of file