iwa-panda1

commit af3d62cf07aaf94ad30ec7a3f69c35fdc8e8344f
parent 313d20b476179cb80d5c5eaad1bc7af9e6876fda
Author: Kninteman <[email protected]>
Date:   Sat, 25 Mar 2023 15:48:32 +0100

Update datavalidator.php

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

1 file changed, 5 insertions(+), 5 deletions(-)
diff --git a/datavalidator.php b/datavalidator.php
@@ -5,22 +5,22 @@
  * @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.
+ * @return int Returns 1 if the temperature is within 20% difference from the average temperature, or 0 if it is not.
  */
-function validate_temperature($sname, $temp, $conn) {
+function validate_temperature($station, $temperatuur, $conn) {
     // 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 = ? 
                                                ORDER BY datum_tijd 
                                                DESC LIMIT 30) AS last_30_rows";
     $stmt = $conn->prepare($sql);
-    $stmt->bind_param('s', $sname);
+    $stmt->bind_param('s', $station);
     $stmt->execute();
     $result = $stmt->get_result();
     $avg_temp = mysqli_fetch_assoc($result)['avg_temp'];
 
-    // Check if $temp is within 30% difference from average temperature in database
-    if(abs($temp - $avg_temp) / $avg_temp > 0.3) {
+    // Check if $temp is within 20% difference from average temperature in database
+    if(abs($temperatuur - $avg_temp) / $avg_temp > 0.2) {
         return 0;
     } else {
         return 1;