prepare("INSERT INTO personen
(name, vorname, personalnummer, gehalt, geburtstag)
VALUES(?, ?, ?, ?, ?)");
$ps->bind_param("ssids", $_POST["na"][0],
$_POST["vo"][0], $_POST["pn"][0],
$_POST["gh"][0], $_POST["gb"][0]);
$ps->execute();
$ps->close();
}
/* ändern */
else if($_POST["aktion"] == "1")
{
$id = $_POST["id"];
$ps = $con->prepare("UPDATE personen SET name=?,
vorname=?, personalnummer=?, gehalt=?,
geburtstag=? WHERE personalnummer=$id");
$ps->bind_param("ssids", $_POST["na"][$id],
$_POST["vo"][$id], $_POST["pn"][$id],
$_POST["gh"][$id], $_POST["gb"][$id]);
$ps->execute();
$ps->close();
}
/* löschen */
else if($_POST["aktion"] == "2")
{
$id = $_POST["id"];
$ps = $con->prepare(
"DELETE FROM personen WHERE personalnummer = $id");
$ps->execute();
$ps->close();
}
/* 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 "";
$res->close();
$con->close();
?>