hanze/iwa-panda2

commit 234be51daa232525e11bf619c11e4882bf6ebbc9
parent fad453ab019313c1999581365033fbd551cb0b8d
Author: LennartSchroot <[email protected]>
Date:   Wed, 28 Jun 2023 21:13:14 +0200

data stores

Diffstat:
M
Controller/api/api.php
29
++++++++++++++++++++++-------

1 file changed, 22 insertions(+), 7 deletions(-)
diff --git a/Controller/api/api.php b/Controller/api/api.php
@@ -1,6 +1,6 @@

 <?php
 
-function storeData($dataArray): void{
+function storeZooData($dataArray): void{
     $db = new mysqli("86.92.67.21", "friedel", "hailiwa", "panda");
     $query = "INSERT INTO retrieve_zoos (city, wind_chill, date) VALUES (?, ?, ?)";
     $stmt = mysqli_prepare($db, $query);
@@ -10,7 +10,25 @@ function storeData($dataArray): void{

         $windchill = $data->windchill;
         $date = $data->date;
 
-        $stmt->bind_param("sdss", $city, $windchill, $date);
+        $stmt->bind_param("sds", $city, $windchill, $date);
+        $stmt->execute();
+    }
+
+    $stmt->close();
+    $db->close();
+}
+
+function storeFacData($dataArray): void{
+    $db = new mysqli("86.92.67.21", "friedel", "hailiwa", "panda");
+    $query = "INSERT INTO retrieve_facilities (city, date_time, humidity) VALUES (?, ?, ?)";
+    $stmt = mysqli_prepare($db, $query);
+
+    foreach ($dataArray as $data) {
+        $city = $data->city;
+        $humidity = $data->humidity;
+        $date_time = $data->date_time;
+
+        $stmt->bind_param("sds", $city, $humidity, $date_time);
         $stmt->execute();
     }
 
@@ -23,9 +41,6 @@ $test = function(&$vars){

   $url = 'http://86.92.67.21/api/windchill';
   $connect = new Model\Connect($url, $token);
   $response = $connect->connect();
-  var_dump($response);
-  foreach($response as $obj){
-    echo "city " . $obj->city . " windchill corrected:" . $obj->windchill . "<br>";
-  }
-  storeData($response);
+  storeZooData($response);
+  storeFacData($response);
 };
 \ No newline at end of file

Generated by gitin!