iwa-panda1

commit 313d20b476179cb80d5c5eaad1bc7af9e6876fda
parent fa5cd27719dbd1554c6b5e06dbe693a5e3e7c7c4
Author: Kninteman <[email protected]>
Date:   Sat, 25 Mar 2023 15:46:55 +0100

Update datavalidator.php

Diffstat:
M
datavalidator.php
 | 
25
+++++++++++++++----------

1 file changed, 15 insertions(+), 10 deletions(-)
diff --git a/datavalidator.php b/datavalidator.php
@@ -1,21 +1,26 @@
 <?php
 /**
- * @param $sname
- * @param $temp
- * @param $conn
- * @return int
+ * Validates the temperature against the average of the last 30 rows for the given station name.
+ *
+ * @param string $sname The station name to validate against.
+ * @param float $temp The temperature value to validate.
+ * @param mysqli $conn The mysqli connection object.
+ * @return int Returns 1 if the temperature is within 30% difference from the average temperature, or 0 if it is not.
  */
 function validate_temperature($sname, $temp, $conn) {
-    // Retrieve the average of the last 20 rows for the given station name
+    // Retrieve the average of the last 30 rows for the given station name
     $sql = "SELECT AVG(temp) AS avg_temp FROM (SELECT temp FROM weerdata 
-                                               WHERE station_name = $sname 
+                                               WHERE station_name = ? 
                                                ORDER BY datum_tijd 
-                                               DESC LIMIT 20) AS last_20_rows";
-    $result = mysqli_query($conn, $sql);
+                                               DESC LIMIT 30) AS last_30_rows";
+    $stmt = $conn->prepare($sql);
+    $stmt->bind_param('s', $sname);
+    $stmt->execute();
+    $result = $stmt->get_result();
     $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) {
+    // Check if $temp is within 30% difference from average temperature in database
+    if(abs($temp - $avg_temp) / $avg_temp > 0.3) {
         return 0;
     } else {
         return 1;