PHP Easy\PDOW\PDOW示例

示例#1

文件： index.php 项目： sspssp/wohnung-public

<?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));
});

示例#2

文件： bootstrap.php 项目： sspssp/sspapp

<?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/");

示例#3

文件： temperature.php 项目： sspssp/wohnung-public

<?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"]));
}