Current directory: /home/klas4s23/domains/585455.klas4s23.mid-ica.nl/public_html/Gastenboek/uploads
<?php
include 'connectie.php';
// Get the data from the form
$name = $_POST['name'];
$phone = $_POST['phone'];
$email = $_POST['email'];
$address = $_POST['address'];
$pizza = $_POST['pizza'];
$quantity = $_POST['quantity'];
// Insert the data into the database
$sql = "INSERT INTO orders (name, phone, email, address, pizza, quantity) VALUES (:name, :phone, :email, :address, :pizza, :quantity)";
$stmt = $conn->prepare($sql);
$stmt->bindParam(':name', $name);
$stmt->bindParam(':phone', $phone);
$stmt->bindParam(':email', $email);
$stmt->bindParam(':address', $address);
$stmt->bindParam(':pizza', $pizza);
$stmt->bindParam(':quantity', $quantity);
$stmt->execute();
$order_id = $conn->lastInsertId();
echo "Order placed successfully<br>";
echo "Your order ID is: " . $order_id;
?>