<?php $app->get("/", function () use($app) { $db = new \Easy\PDOW\PDOW(); $sql = 'SELECT *, TIME(`createDate`) AS `createTime` FROM `temperature` WHERE `createDate` >= date_sub(now(), INTERVAL 2 DAY) ORDER BY `createDate` ASC'; $res = $db->query($sql); #var_dump($res); $app->render("index.php", array("temperatur" => $res)); });
<?php # DONT CHANGE session_start(); date_default_timezone_set("UTC"); setlocale(LC_MESSAGES, 'de_DE'); bindtextdomain("messages", __DIR__ . "/../i18n/"); bind_textdomain_codeset("messages", "UTF-8"); textdomain("messages"); include "../vendor/autoload.php"; include "../config/config.php"; if (!empty($mysql["host"])) { $db = new \Easy\PDOW\PDOW(); $db->setTyp("mysql"); $db->setUsername($mysql["user"]); $db->setServer($mysql["host"]); $db->setDatabase($mysql["db"]); $db->setPassword($mysql["pw"]); $db->createConnection(true); $db->createStatic(); } unset($mysql); $app = new \Slim\Slim(array('templates.path' => __DIR__ . "/../app/views/")); $handle = opendir("../app/middelware/"); while ($datei = readdir($handle)) { if (is_file("../app/middelware/" . $datei)) { require_once "../app/middelware/" . $datei; } } closedir($handle); $handle = opendir("../app/controller/");
<?php include "../config/config.php"; include "../vendor/autoload.php"; if (!empty($mysql["host"])) { $db = new \Easy\PDOW\PDOW(); $db->setTyp("mysql"); $db->setUsername($mysql["user"]); $db->setServer($mysql["host"]); $db->setDatabase($mysql["db"]); $db->setPassword($mysql["pw"]); $db->createConnection(true); $db->createStatic(); } else { echo "NO DB CONNECTION"; exit; } $res = json_decode(file_get_contents($api . "temperature"), true); foreach ($res as $r) { $db->insert("INSERT INTO `temperature`(`sensor`, `value`) VALUES (?, ?)", array($r["name"], $r["temperatur"])); }