PHP
<?php
error_reporting(E_ALL);
if (isset($_POST["r"])) {
require_once '../php/db.php';
$restaurantname = $_POST["Restaurantname"];
$name = $_POST["firstname"];
$lastname =$_POST["lastname"];
$email=$_POST["email"];
$Passwort= $_POST["password"];
$md5passwort = md5($Passwort);
$Tisch = $_POST["tisch"];
$statement = $pdo->prepare("INSERT INTO users (email,passwort ,vorname, nachname,Restaurantname,Tisch) VALUES (?, ?, ?, ?, ?, ?)");
$statement->execute(array('$email', '$md5passwort','$name', '$lastname', '$Restaurantname', '$Tisch'));
$neue_id = $pdo->lastInsertId();
echo "<div class='alert alert-danger'role='alert'>
Neuer Nutzer mit id $neue_id angelegt</div>";
}
?>
<!doctype html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">
<title>Registrieren | GaKass</title>
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-light bg-light">
<a class="navbar-brand" href="#">GAKass</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarSupportedContent">
<ul class="navbar-nav mr-auto">
<li class="nav-item active">
<a class="nav-link" href="#">Home <span class="sr-only">(current)</span></a>
</li>
<li class="nav-item">
<a class="nav-link" href="#">Link</a>
</li>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
Dropdown
</a>
<div class="dropdown-menu" aria-labelledby="navbarDropdown">
<a class="dropdown-item" href="#">Action</a>
<a class="dropdown-item" href="#">Another action</a>
<div class="dropdown-divider"></div>
<a class="dropdown-item" href="#">Something else here</a>
</div>
</li>
<li class="nav-item">
<a class="nav-link disabled" href="#" tabindex="-1" aria-disabled="true">Disabled</a>
</li>
</ul>
<form class="form-inline my-2 my-lg-0">
<input class="form-control mr-sm-2" type="search" placeholder="Search" aria-label="Search">
<button class="btn btn-outline-success my-2 my-sm-0" type="submit">Search</button>
</form>
</div>
</nav>
<div class="container mt-5">
<form action="index.php" method="Post">
<label>Restaurantname:</label>
<input class="form-control" type="text" maxlength="160" name="Restaurantname">
<label>Passwort:</label>
<input type="password" name="password" maxlength="12" class="form-control">
<label>Vorname:</label>
<input type="text" maxlength="60" name="firstname" class="form-control">
<label>Nachname:</label>
<input type="text" name="lastname" maxlength="60" class="form-control">
<label>E-Mail:</label>
<input class="form-control" type="email" name="email">
<label>Tische</label>
<input class="form-control" type="number" name="tisch" value="0">
<button type="submit" name="r" value="1" class="btn btn-dark">Absenden</button>
</form>
<!-- Optional JavaScript -->
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<script src="https://code.jquery.com/jquery-3.4.1.slim.min.js" integrity="sha384-J6qa4849blE2+poT4WnyKhv5vZF5SrPo0iEjwBvKU7imGFAV0wwj1yYfoRSJoZ+n" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js" integrity="sha384-wfSDF2E50Y2D1uUdj0O3uMBJnjuUD4Ih7YwaYd1iqfktj0Uod8GCExl3Og8ifwB6" crossorigin="anonymous"></script>
</body>
</html>