create php form

**Agenda.php:**

<form action="/restaurant/agenda.php" method="POST">
  Zoek reservering datum:<br>
  <input type="date" name="datum" value=""><br><br>
  <input type="submit" value="Submit">
</form>


<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "restaurant";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

//$date= $_POST['datum'];
//$sql = "SELECT reserveringen.Reservering_Id,reserveringen.Tafel_Id, reserveringen.Res_Datum, reserveringen.VoorNaam, reserveringen.AchterNaam FROM reserveringen INNER JOIN tafels ON reserveringen.Tafel_Id=tafels.Tafel_Id";
$sql = "SELECT Reservering_Id, Tafel_Id, Res_Datum, VoorNaam, AchterNaam FROM reserveringen "; //WHERE Res_Datum LIKE '%$date%'
$result = $conn->query($sql);

if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "reserveringID: ". $row["Reservering_Id"]. " tafelnummer: " . $row["Tafel_Id"]. " - Reservering_datum: " . $row["Res_Datum"]. " " . $row["VoorNaam"]." ".$row["AchterNaam"]. " ". "<br>";
    }
} else {
    echo "0 results";
}

mysqli_close($conn);
?>


</div>


**Bestelling.php :**

 <form action="/restaurant/maak_bestelling.php" method="POST">
  <h2>Enter Order</h2>

  Table Number:<br>
  <input type="text" name="tafelnummer" value=""><br><br>
  Receipt Id:<br>
  <input type="text" name="receiptid"   value=""><br><br>
  Menu_Item:<br>
  <input type="text" name="menu_item"   value=""><br><br>
  Date: <br>
  <input type="date" name="date"        value=""><br><br>

  <input type="submit" value="Submit">
</form>


<h2>Pending Orders:</h2>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "restaurant";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

//MY Query i am trying to run
// $sql = "SELECT O.Res_Datum, R.Reservering_Id, O.Tafel_Id,O.ReceiptID, SUM(MI.ItemPrice) AS TotalReceiptPrice
// FROM Orders, Reserveringen AS O INNER JOIN MenuItem AS MI ON O.MenuItemID = MI.MenuItemID
// AS O LEFT JOIN Reservering_Id AS R on O.Reservering_Id = R.reservering_Id
// GROUP BY O.Res_Datum, O.Res_ID, O.Tafel_Id  ";

//The statement I get with an Empty reservation_ID
$sql = "SELECT O.Res_Datum, O.Res_ID, O.Tafel_Id,O.ReceiptID, SUM(MI.ItemPrice) AS TotalReceiptPrice
FROM Orders AS O INNER JOIN MenuItem AS MI ON O.MenuItemID = MI.MenuItemID
GROUP BY O.Res_Datum, O.Res_ID, O.Tafel_Id  ";


$result = $conn->query($sql);

if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "Res_datum: ". $row["Res_Datum"]. " ReservationID : " . $row["Res_ID"]. " - Table_Number: " . $row["Tafel_Id"]. " Total Order Price: " . $row["TotalReceiptPrice"]." ". "<br>";
    }
} else {
    echo "0 results";
}

mysqli_close($conn);
?>


</div>


index.php:

<!DOCTYPE html>
<html lang="en" dir="ltr">
  <head>
    <meta charset="utf-8">
    <title>Dashboard</title>
  </head>
  <body>
<h1>Dashboard</h1>
  </body>
</html>

maak_bestelling.php:
<?php


$con = mysqli_connect('localhost','root','');

if(!$con) {
echo 'Not connected with server';
}

if(!mysqli_select_db ($con,'restaurant')) {
echo 'Database Not selected';
}

$tablenumber = $_POST['tafelnummer'];
$receiptid = $_POST['receiptid'];
$menu_item = $_POST['menu_item'];
$date = $_POST['date'];


$sql = "INSERT INTO Orders (orders.Tafel_Id, orders.ReceiptID, orders.MenuItemID,  orders.Res_Datum )
VALUES ('$tablenumber', '$receiptid', '$menu_item', '$date')";

if(!mysqli_query($con,$sql)){
  echo 'insert did not work';
}else {
  echo 'Order created successfully';
}

header("refresh:1; url=bestelling.php");


?>


**Maak_reservering.php :**

<?php


$con = mysqli_connect('localhost','root','');

if(!$con) {
echo 'Niet verbonden met Server';
}

if(!mysqli_select_db ($con,'restaurant')) {
echo 'Database Niet Geselecteerd';
}

$voornaam = $_POST['voornaam'];
$achternaam = $_POST['achternaam'];
$email = $_POST['email'];
$telefoonnummer = $_POST['telefoonnummer'];
$tafel = $_POST['tafel'];
$datum = $_POST['datum'];

$sql = "INSERT INTO reserveringen (reserveringen.VoorNaam, reserveringen.AchterNaam, reserveringen.Email, reserveringen.TelefoonNummer, reserveringen.Tafel_Id, reserveringen.Res_Datum)
VALUES ('$voornaam', '$achternaam', '$email', '$telefoonnummer','$tafel','$datum')";

if(!mysqli_query($con,$sql)){
  echo 'Invoeren niet gelukt';
}else {
  echo 'Reservering Succesvol Gemaakt';
}

header("refresh:1; url=reservering.php");


?>

**Reservering.php :**

<!DOCTYPE html>
<html lang="en" dir="ltr">
  <head>
    <meta charset="utf-8">
    <title>reservering maken</title>
  </head>
  <body>
<h1>Maak reservering</h1>

<form action="/restaurant/maak_reservering.php" method="POST">
  Voornaam:<br>
  <input type="text" name="voornaam" value=""><br><br>

  Achternaam:<br>
  <input type="text" name="achternaam" value=""><br><br>

  Email:<br>
  <input type="text" name="email" value=""><br><br>

  Telefoonnummer:<br>
  <input type="text" name="telefoonnummer" value=""><br><br>

  Tafel:<br>
  <input type="text" name="tafel" value=""><br><br>

  Reserverings Datum:<br>
  <input type="date" name="datum" value="dd//mm//yy"><br><br>

  <input type="submit" value="Submit">
</form>


<div id="Tafels">
<h3>Gereserveerde Tafels</h3>

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "restaurant";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// $sql = "SELECT reserveringen.Tafel_Id, reserveringen.Res_Datum
// FROM reserveringen
// INNER JOIN tafels ON reserveringen.Tafel_Id=tafels.Tafel_Id";
// $result = $conn->query($sql);

//andere query welke ik heb geprobeerd met reservering nummer
//tafels.tafel_Nummer,reserveringen.Res_Datum,reserveringen.Reservering_Id FROM tafels INNER JOIN reserveringen ON reserveringen.Res_Datum = reserveringen.Res_Datum AND reserveringen.Reservering_Id = reserveringen.Reservering_Id

//$sql = "SELECT tafels.tafel_Nummer,reserveringen.Res_Datum,reserveringen.Reservering_Id FROM tafels LEFT JOIN reserveringen ON reserveringen.Res_Datum = reserveringen.Res_Datum AND reserveringen.Reservering_Id = reserveringen.Reservering_Id";
$sql = "SELECT Reservering_Id, Tafel_Id, Res_Datum, VoorNaam, AchterNaam FROM reserveringen ORDER BY Res_Datum DESC";
$result = $conn->query($sql);

if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "reserveringID: ". $row["Reservering_Id"]. " tafelnummer: " . $row["Tafel_Id"]. " - Reservering_datum: " . $row["Res_Datum"]. " " . $row["VoorNaam"]." ".$row["AchterNaam"]. " ". "<br>";
    }
} else {
    echo "0 results";
}

mysqli_close($conn);

//$sql = "SELECT tafels.tafel_Nummer,tafels.Res_Datum,tafels.Reservering_Id FROM tafels INNER JOIN reserveringen ON tafels.Res_Datum = reserveringen.Res_Datum AND tafels.tafel_Id = reserveringen.tafel_Id";


//SELECT tafels.Tafel_Id,reserveringen.Res_datum FROM tafels INNER JOIN reserveringen ON reserveringen.Res_Datum = reserveringen.Res_Datum
//tafels en reserveerdatums

//LAATSTE query SELECT tafels.tafel_Nummer,reserveringen.Res_Datum,reserveringen.Reservering_Id FROM tafels RIGHT JOIN reserveringen ON reserveringen.Res_Datum = reserveringen.Res_Datum AND reserveringen.Reservering_Id = reserveringen.Reservering_Id
?>


</div>


  </body>
</html>