commit 34420555142c43d6b98f695e5d9aaa986ca2b8d5
parent e68c6aadbddf893a630b2810aa412a9aeec47c09
Author: Gerco van Woudenbergh <[email protected]>
Date: Wed, 28 Jun 2023 21:51:01 +0200
api
Diffstat:
1 file changed, 22 insertions(+), 4 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();
}
@@ -28,7 +46,7 @@ $get_windchill = function(&$vars){
$url = 'http://86.92.67.21/api/windchill/' . $since;
$connect = new Model\Connect($url, $token);
$response = $connect->connect();
- storeData($response);
+ //storeData($response);
};
$get_graph = function(&$vars){
$token = 'ae9c50dc5cd58c538a0d6aedb17fffedcaffd568d22381dab3ae72baaeb24684';
@@ -40,5 +58,5 @@ $get_graph = function(&$vars){
$url = 'http://86.92.67.21/api/graph/' . $since;
$connect = new Model\Connect($url, $token);
$response = $connect->connect();
- storeData($response);
+ //storeData($response);
};
\ No newline at end of file
