function insertTonne($datum, $farbe) { $db = new Datenbank(); $s = $datum; $t = $farbe; $db->exec("INSERT INTO tonne (datum, farbe) VALUES ('" . $s . "', '" . $t . "')"); }
function insertTermin($termin, $terminnr, $datum, $uhrzeit) { $db = new Datenbank(); $s = $termin; $t = $terminnr; $u = $datum; $v = $uhrzeit; $db->exec("INSERT INTO termine (termin, terminnr, datum, uhrzeit) VALUES ('" . $s . "', '" . $t . "', '" . $u . "', '" . $v . "')"); }
function insertWartung($wartung, $wartungnr, $datum, $uhrzeit, $prioritaet) { $db = new Datenbank(); $s = $wartung; $t = $wartungnr; $u = $datum; $v = $uhrzeit; $p = $prioritaet; $db->exec("INSERT INTO wartungen (wartung, wartungnr, datum, uhrzeit, prioritaet) VALUES ('" . $s . "', '" . $t . "', '" . $u . "', '" . $v . "', '" . $p . "')"); }
function insertPflanze($namekurz, $namelang, $standort, $giessen, $frostsicher, $saatmonat, $erntemonat, $wikipedia) { $db = new Datenbank(); $p1 = $namekurz; $p2 = $namelang; $p3 = $standort; $p4 = $giessen; $p5 = $frostsicher; $p6 = $saatmonat; $p7 = $erntemonat; $p8 = $wikipedia; $db->exec("INSERT INTO pflanzen (namekurz, namelang, standort, giessen, frostsicher, saatmonat, erntemonat, wikipedia)\n VALUES ('" . $p1 . "','" . $p2 . "','" . $p3 . "','" . $p4 . "','" . $p5 . "','" . $p6 . "','" . $p7 . "','" . $p8 . "')"); }
function insertSpruch($spruch) { $db = new Datenbank(); $s = $spruch; $db->exec("INSERT INTO sprueche (spruch, spruchnr) VALUES ('" . $s . "', '23')"); }
/** * Created by PhpStorm. * User: rosk * Date: 29.07.15 * Time: 21:08 */ function writeTagesdaten($today, $w, $g, $l, $j, $m) { $date = $today; $db = new Datenbank(); $db->exec("INSERT INTO tagesdaten (datum, wind, grad, luftfeuchte, jahr, monat) VALUES ('" . $date . "', '" . $w . "', '" . $g . "', '" . $l . "', '" . $j . "', '" . $m . "')"); }