prepare("INSERT INTO personen"
. "(name, vorname, personalnummer, gehalt, geburtstag)"
. " VALUES(@na, @vo, @pn, @gh, @gb)");
$ps->bindParam("@na", $_POST["na"][0], SQLITE3_TEXT);
$ps->bindParam("@vo", $_POST["vo"][0], SQLITE3_TEXT);
$ps->bindParam("@pn", $_POST["pn"][0], SQLITE3_INTEGER);
$ps->bindParam("@gh", $_POST["gh"][0], SQLITE3_FLOAT);
$ps->bindParam("@gb", $_POST["gb"][0], SQLITE3_TEXT);
$ps->execute();
}
/* ändern */
else if($_POST["aktion"] == "1")
{
$id = $_POST["id"];
$ps = $db->prepare("UPDATE personen SET name=@na,"
. " vorname=@vo, personalnummer=@pn, gehalt=@gh,"
. " geburtstag=@gb WHERE personalnummer=$id");
$ps->bindParam("@na", $_POST["na"][$id], SQLITE3_TEXT);
$ps->bindParam("@vo", $_POST["vo"][$id], SQLITE3_TEXT);
$ps->bindParam("@pn", $_POST["pn"][$id], SQLITE3_INTEGER);
$ps->bindParam("@gh", $_POST["gh"][$id], SQLITE3_FLOAT);
$ps->bindParam("@gb", $_POST["gb"][$id], SQLITE3_TEXT);
$ps->execute();
}
/* löschen */
else if($_POST["aktion"] == "2")
{
$ps = $db->prepare("DELETE FROM personen"
. " WHERE personalnummer = " . $_POST["id"]);
$ps->execute();
}
/* sortieren */
else if($_POST["aktion"] == "3")
$od = " ORDER BY name";
else if($_POST["aktion"] == "4")
$od = " ORDER BY vorname";
else if($_POST["aktion"] == "5")
$od = " ORDER BY personalnummer";
else if($_POST["aktion"] == "6")
$od = " ORDER BY gehalt";
else if($_POST["aktion"] == "7")
$od = " ORDER BY geburtstag";
}
/* Formularbeginn */
echo "";
$db->close();
?>