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