PHP Datenbank::query 예제들

예제 #1

파일: spruch.inc.php 프로젝트: Rosk/GartenHelfer

function returnSpruch()
{
    $db = new Datenbank();
    $query = $db->query('SELECT * FROM sprueche');
    // gepuffertes Abfrageergebnis
    $ids = array();
    while ($row = $query->fetchArray()) {
        $ids[] = $row[0];
    }
    $randid = $ids[rand(sizeof(0, $ids))];
    $query2 = $db->query('SELECT spruch FROM sprueche WHERE id = ' . $randid . '');
    // gepuffertes Abfrageergebnis
    while ($row2 = $query2->fetchArray()) {
        $theid = $row2[0];
        $thespruch = $row2[1];
    }
    if ($thespruch == "" || !$thespruch) {
        $thespruch = "Kein Spruch parat.";
    }
    echo $thespruch;
}

예제 #2

파일: tagesdaten.inc.php 프로젝트: Rosk/GartenHelfer

function hasTagesdaten($day)
{
    $date = $day;
    $db = new Datenbank();
    $query = $db->query("SELECT * FROM tagesdaten WHERE datum='" . $date . "'");
    $datensatz = "";
    while ($row = $query->fetchArray()) {
        $datensatz .= "<b>" . $row[0] . "</b><br>" . $row[1] . $row[2] . $row[3] . $row[4] . $row[5];
    }
    if ($datensatz == "") {
        return false;
    } else {
        return true;
    }
}

예제 #3

파일: functions.inc.php 프로젝트: Rosk/GartenHelfer

function printSwitches($g)
{
    $group = $g;
    // count
    $count = 0;
    // db
    $db = new Datenbank();
    // query
    $query = $db->query('SELECT * FROM schalter WHERE gruppe = "' . $group . '"');
    // gepuffertes Abfrageergebnis
    // DB vals
    $switches = array();
    $switchgrp = array();
    $switchval = array();
    $switchserial = array();
    $switchserialoff = array();
    // results
    while ($row = $query->fetchArray()) {
        array_push($switches, $row[1]);
        array_push($switchgrp, $row[2]);
        array_push($switchval, $row[3]);
        array_push($switchserial, $row[4]);
        array_push($switchserialoff, $row[5]);
        $sw = "";
        $sw .= '<div class="col-sm-12 col-md-3">';
        $sw .= '<h6>' . $switches[$count] . '</h6>';
        $sw .= '<input class="' . $switchgrp[$count] . $count . '" type="checkbox" name="' . $switchgrp[$count] . $count . '">';
        $sw .= '<br><div class="badge badge-serial">' . $switchserial[$count] . '</div>';
        $sw .= '<div class="badge badge-serial">' . $switchserialoff[$count] . '</div><br>';
        $sw .= '<div class="badge badge-value">' . $switchval[$count] . '</div>';
        $sw .= '<div class="badge badge-bulb"><i class="ion ion-lightbulb"></i></div>';
        $sw .= '<div class="badge badge-bulb"><i class="ion ion-eye"></i></div>';
        $sw .= '<div class="badge badge-bulb"><i class="ion ion-key"></i></div>';
        $sw .= '<div><div class="led-red led-inline-left"></div>';
        $sw .= '<div class="led-yellow led-inline-left"></div>';
        $sw .= '<div class="led-green led-inline-left"></div>';
        $sw .= '<div class="led-blue led-inline-left"></div>';
        $sw .= '<div class="led-off led-inline-left"></div></div>';
        $sw .= '</div>';
        $scr = "<script>";
        // TODO: Create here the correct script
        $scr .= "";
        $scr .= "</script>";
        echo $sw;
        echo $scr;
        $count++;
    }
}

예제 #4

파일: wartung.inc.php 프로젝트: Rosk/GartenHelfer

function wartungHeute($datum)
{
    $list = "";
    $count = 0;
    $db = new Datenbank();
    $query = $db->query('SELECT * FROM wartungen WHERE datum="' . $datum . '" ORDER BY datum, prioritaet');
    // gepuffertes Abfrageergebnis
    while ($row = $query->fetchArray()) {
        $list .= "\n        <li class='wartung'>" . $row[3] . " um " . $row[4] . "<br>\n        <div class='badge badge-prio pull-right'>{$row['5']}</div>\n        <h5><i class='ion ion-wrench'></i> " . $row[1] . "</h5>\n        <a class='pull-right btn btn-small' alt='Text" . $row[0] . "' href='?del4=" . $row[0] . "'>Erledigt</a></li>";
        $count++;
    }
    if ($list != "") {
        echo "<ul>";
        echo $list;
        echo "</ul>";
        echo "<div class='clearfix' style='width: 100%; float: none; clear: both;'>";
        echo "</div>";
    } else {
        echo "<h6><i class='ion ion-ios-arrow-thin-right'></i> Keine Wartungen für heute!</h6>";
    }
}

예제 #5

파일: termine.inc.php 프로젝트: Rosk/GartenHelfer

function terminHeute($datum)
{
    $list = "";
    $count = 0;
    $db = new Datenbank();
    $query = $db->query('SELECT * FROM termine WHERE datum="' . $datum . '"');
    // gepuffertes Abfrageergebnis
    while ($row = $query->fetchArray()) {
        // Do Something with $row
        // print_r($row[0]);
        $list .= "<li class='terminShort'>" . $row[3] . " um " . $row[4] . "<br><h5>" . $row[1] . "</h5> <a class='pull-right btn btn-small' alt='Text" . $row[0] . "' href='?del2=" . $row[0] . "'>Erledigt</a></li>";
        $count++;
    }
    if ($list != "") {
        echo "<ul>";
        echo $list;
        echo "</ul>";
        echo "<div class='clearfix' style='width: 100%; float: none; clear: both;'>";
        echo "</div>";
    } else {
        echo "<h6><i class='ion ion-ios-arrow-thin-right'></i> Keine Termine für heute!</h6>";
    }
}

예제 #6

파일: tonne.inc.php 프로젝트: Rosk/GartenHelfer

function tonneHeute($datum)
{
    $list = "";
    $count = 0;
    $db = new Datenbank();
    $query = $db->query('SELECT * FROM tonne WHERE datum="' . $datum . '"');
    // gepuffertes Abfrageergebnis
    while ($row = $query->fetchArray()) {
        if ($row[2] == "Braune Tonne") {
            $list .= "<i class='ion ion-ios-trash-outline tonneicon' style='color: #623106;'></i>";
        }
        if ($row[2] == "Gelbe Tonne") {
            $list .= "<i class='ion ion-ios-trash-outline tonneicon' style='color: #fff638;'></i>";
        }
        if ($row[2] == "Blaue Tonne") {
            $list .= "<i class='ion ion-ios-trash-outline tonneicon' style='color: #008cd3;'></i>";
        }
        if ($row[2] == "Schwarze Tonne") {
            $list .= "<i class='ion ion-ios-trash-outline tonneicon' style='color: #001620;'></i>";
        }
        if ($row[2] == "") {
            $list .= "<i class='ion ion-ios-sunny tonneicon' style='color: #657172;'></i>";
        }
        $count++;
    }
    if ($list != "") {
        echo "<ul>";
        echo $list;
        echo "</ul>";
        echo "<div class='clearfix' style='width: 100%; float: none; clear: both;'>";
        echo "</div>";
    } else {
        echo "<i class='ion ion-ios-trash tonneicon' style='color: #657172;'></i>";
        echo "<h3>Heute keine Leerung</h3>";
        echo "<div class='clearfix'></div>";
    }
}

예제 #7

파일: plantable.inc.php 프로젝트: Rosk/GartenHelfer

<?php

header('Content-type: application/json');
include "../functions.inc.php";
$db = new Datenbank();
$query = $db->query('SELECT * FROM pflanzen ORDER BY namekurz, namelang ASC');
// gepuffertes Abfrageergebnis
$json = "";
while ($row = $query->fetchArray()) {
    $json[] = $row;
}
$handle = fopen("../pflanzen.json", "w+");
fwrite($handle, json_encode($json));
fclose($handle);
return json_encode($json);

예제 #8

파일: ajax_neuerSpruch.php 프로젝트: Rosk/GartenHelfer

<?php

/**
 * Created by PhpStorm.
 * User: odroid
 * Date: 06.08.15
 * Time: 16:56
 * asynchrone Datenverarbeitung
 * Diese Seite wird mit Ajax über jQuery parametrisiert aufgerufen.
 * Die verabeiteten Daten werden zurückgegeben,
 * und von der jQuery Methode verarbeitet
 *
 */
include 'functions.inc.php';
$db = new Datenbank();
$query = $db->query('SELECT * FROM sprueche');
// gepuffertes Abfrageergebnis
$ids = array();
$thespruch = "Kein Spruch parat.";
while ($row = $query->fetchArray()) {
    $ids[] = $row[0];
}
$randid = rand(0, sizeof($ids) - 1);
$query2 = $db->query('SELECT spruch FROM sprueche WHERE id = ' . $ids[$randid] . '');
// gepuffertes Abfrageergebnis
while ($row2 = $query2->fetchArray()) {
    $theid = $row2[0];
    $thespruch = $row2[0];
}
echo $thespruch;

예제 #9

파일: pflanzen.inc.php 프로젝트: Rosk/GartenHelfer

function plants2Json()
{
    $count = 0;
    $db = new Datenbank();
    $query = $db->query('SELECT * FROM pflanzen ORDER BY namekurz, namelang ASC');
    // gepuffertes Abfrageergebnis
    $json = "";
    while ($row = $query->fetchArray()) {
        $json[] = $row;
        $count++;
    }
    $handle = fopen("sqlitedb/data1.json", "w+");
    fwrite($handle, json_encode($json));
    fclose($handle);
    return json_encode($json);
}