commit 2885258eb990d6fa17996967fd8e833c4bcc2843
parent 8df0af86eb1b437db5f57fa4634df91a16f1fa55
Author: LennartSchroot <[email protected]>
Date: Thu, 29 Jun 2023 16:33:42 +0200
backup push
Diffstat:
4 files changed, 96 insertions(+), 14 deletions(-)
diff --git a/.idea/php.xml b/.idea/php.xml
@@ -0,0 +1,22 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<project version="4">
+ <component name="MessDetectorOptionsConfiguration">
+ <option name="transferred" value="true" />
+ </component>
+ <component name="PHPCSFixerOptionsConfiguration">
+ <option name="transferred" value="true" />
+ </component>
+ <component name="PHPCodeSnifferOptionsConfiguration">
+ <option name="highlightLevel" value="WARNING" />
+ <option name="transferred" value="true" />
+ </component>
+ <component name="PhpProjectSharedConfiguration" php_language_level="8.0">
+ <option name="suggestChangeDefaultLanguageLevel" value="false" />
+ </component>
+ <component name="PhpStanOptionsConfiguration">
+ <option name="transferred" value="true" />
+ </component>
+ <component name="PsalmOptionsConfiguration">
+ <option name="transferred" value="true" />
+ </component>
+</project>
+\ No newline at end of file
diff --git a/.idea/vcs.xml b/.idea/vcs.xml
@@ -0,0 +1,6 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<project version="4">
+ <component name="VcsDirectoryMappings">
+ <mapping directory="" vcs="Git" />
+ </component>
+</project>
+\ No newline at end of file
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
@@ -0,0 +1,58 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<project version="4">
+ <component name="AutoImportSettings">
+ <option name="autoReloadType" value="SELECTIVE" />
+ </component>
+ <component name="ChangeListManager">
+ <list default="true" id="f1ac0514-5d96-49e8-8c16-ecccecd1bbe1" name="Changes" comment="">
+ <change beforePath="$PROJECT_DIR$/index.php" beforeDir="false" afterPath="$PROJECT_DIR$/index.php" afterDir="false" />
+ </list>
+ <option name="SHOW_DIALOG" value="false" />
+ <option name="HIGHLIGHT_CONFLICTS" value="true" />
+ <option name="HIGHLIGHT_NON_ACTIVE_CHANGELIST" value="false" />
+ <option name="LAST_RESOLUTION" value="IGNORE" />
+ </component>
+ <component name="ComposerSettings">
+ <execution />
+ </component>
+ <component name="Git.Settings">
+ <option name="RECENT_GIT_ROOT_PATH" value="$PROJECT_DIR$" />
+ </component>
+ <component name="MarkdownSettingsMigration">
+ <option name="stateVersion" value="1" />
+ </component>
+ <component name="PhpWorkspaceProjectConfiguration" interpreter_name="PHP" />
+ <component name="ProjectId" id="2Rsnxoj73UIHCNz0dPBiYIKSEQ1" />
+ <component name="ProjectViewState">
+ <option name="hideEmptyMiddlePackages" value="true" />
+ <option name="showLibraryContents" value="true" />
+ </component>
+ <component name="PropertiesComponent"><![CDATA[{
+ "keyToString": {
+ "RunOnceActivity.ShowReadmeOnStart": "true",
+ "WebServerToolWindowFactoryState": "false",
+ "node.js.detected.package.eslint": "true",
+ "node.js.detected.package.tslint": "true",
+ "node.js.selected.package.eslint": "(autodetect)",
+ "node.js.selected.package.tslint": "(autodetect)",
+ "nodejs_package_manager_path": "npm",
+ "vue.rearranger.settings.migration": "true"
+ }
+}]]></component>
+ <component name="SpellCheckerSettings" RuntimeDictionaries="0" Folders="0" CustomDictionaries="0" DefaultDictionary="application-level" UseSingleDictionary="true" transferred="true" />
+ <component name="TaskManager">
+ <task active="true" id="Default" summary="Default task">
+ <changelist id="f1ac0514-5d96-49e8-8c16-ecccecd1bbe1" name="Changes" comment="" />
+ <created>1688047905882</created>
+ <option name="number" value="Default" />
+ <option name="presentableId" value="Default" />
+ <updated>1688047905882</updated>
+ <workItem from="1688047906916" duration="295000" />
+ <workItem from="1688048224856" duration="968000" />
+ </task>
+ <servers />
+ </component>
+ <component name="TypeScriptGeneratedFilesManager">
+ <option name="version" value="3" />
+ </component>
+</project>
+\ No newline at end of file
diff --git a/index.php b/index.php
@@ -18,28 +18,21 @@ $router->addRoute(["POST"], "/login", $login);
$router->addRoute(["POST", "GET"], "/logout", $logout);
$router->addRoute(["GET"], "/api/:data", function ($key) {
+ $weather_data = [];
if($key['data'] == ':3jvl7yb5sRr80s6lTdeOyxV9VTQZkCPRp7bKOWKFWxfL2vhsU4Hhpgcmz9qe0zEk') {
- $db = new mysqli("86.92.67.21", "friedel", "hailiwa", "wap2");
- $weather_data = [];
- $query = "SELECT distinct temperature, wind_speed, nl.name as city, co.country as country
- FROM weather_data wd
- JOIN station s ON wd.station_name = s.name
- JOIN contract_station cs ON cs.station_name = s.name
- JOIN nearestlocation nl ON nl.station_name = s.name
- JOIN country co ON co.country_code = nl.country_code
- JOIN geolocation geo ON geo.country_code = co.country_code
- JOIN contract c ON cs.contract_id = c.contract_id
- WHERE c.token = '3jvl/yb?sRr80s6lTdeOyxV9VTQZkCPRp/bKOWKFWxfL2vhsU4Hhpgcmz9qe0zEk'
- GROUP BY nl.name";
+ $db = new mysqli("86.92.67.21", "friedel", "hailiwa", "panda");
+ $query = "SELECT distinct wind_chill, city, country
+ FROM retrieve_zoos
+ WHERE date = '2023-06-28'
+ ";
$stmt = mysqli_prepare($db, $query);
$stmt->execute();
$data = $stmt->get_result();
while ($row = $data->fetch_assoc()) {
- $wind_chill = Model\Formula::windchill($row["temperature"], $row["wind_speed"]);
$weather_data[] = [
- 'windchill' => $wind_chill,
+ 'windchill' => $row['wind_chill'],
'location' => $row['city'],
'country' => $row['country']
];
