<!DOCTYPE html>
<html lang="de">
<head>
<meta charset="utf-8">
<title>Datensatz ändern</title>
</head>
<body>
<?php
$oripn = $_POST["oripn"];
$con = new mysqli("", "root", "", "firma");
$ps = $con->prepare("UPDATE personen SET name = ?,"
. " vorname = ?, personalnummer = ?, gehalt = ?,"
. " geburtstag = ? WHERE personalnummer = $oripn");
$ps->bind_param("ssids", $_POST["na"], $_POST["vn"],
$_POST["pn"], $_POST["ge"], $_POST["gt"]);
$ps->execute();
if ($ps->affected_rows > 0)
echo "Datensatz geändert<br>";
else
echo "Fehler, Datensatz nicht geändert<br>";
$ps->close();
$con->close();
?>
<p>Zur <a href="db_einzel_a.php">Auswahl</a></p>
</body>
</html>