iwa-panda1

commit c9cf09f6d632e8fb9a3a3276771b52761d08f27b
parent 5d5c7a01fed719b370f4b45721a3c1cc11d699f9
Author: Johs <[email protected]>
Date:   Sun, 26 Mar 2023 16:03:44 +0200

Paar kolommen eruitgehaald, valid en data_id

Diffstat:
M
datainserter.php
 | 
7
+++----

1 file changed, 3 insertions(+), 4 deletions(-)
diff --git a/datainserter.php b/datainserter.php
@@ -82,12 +82,11 @@ if ($_SERVER['REQUEST_METHOD'] == 'POST') {
             $row = $result->fetch_assoc();
             $data_id = $row['data_id'];
 
-            $sql3 = "INSERT INTO weerdata_gecorrigeerd (station_name, origin_data_id, datum_tijd,gevalideerd,temp,dauwpunt,ldrk_znv,ldrk_station,zichtbaarheid,
+            $sql3 = "INSERT INTO weerdata_gecorrigeerd (station_name, origin_data_id, datum_tijd,temp,dauwpunt,ldrk_znv,ldrk_station,zichtbaarheid,
             windsnelheid,neerslag,sneeuwdpt,gebeurtenissen, vorst,regen,sneeuw,hagel,onweer,tornado, bewolking,windrichting) 
-            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
+            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
             $stmt3 = mysqli_prepare($db_connection, $sql3);
-            $falsevalid = 1;
-            mysqli_stmt_bind_param($stmt3, "iisiddddddddsiiiiiidi", $stn, $data_id, $datetime, $falsevalid, $temp, $dewp, $stp, $slp, $visib, $wdsp, $prcp, $sndp, $frshtt, $vorst,$regen,$sneeuw,$hagel,$onweer,$tornado, $cldc, $wnddir);
+            mysqli_stmt_bind_param($stmt3, "iisddddddddsiiiiiidi", $stn, $data_id, $datetime, $temp, $dewp, $stp, $slp, $visib, $wdsp, $prcp, $sndp, $frshtt, $vorst,$regen,$sneeuw,$hagel,$onweer,$tornado, $cldc, $wnddir);
             $result = mysqli_stmt_execute($stmt3);
 
         }