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 . "')");
}
