Untitled

   <html>

   <head>

     <title>Police Traffic Database</title>

   </head>

   <body>
   <h1> Add Vehicle</h1>

    <form method="POST">
        Colour: <input type="text" name="Colour"><br>
        Make: <input type="text" name="Make"><br>
        Model: <input type="text" name="Model"><br>
        License Plate: <input type="text" name="licensePlate"><br>
        <input type="submit" value = "Add Record">
    </form>
    <hr>

<?php
    // MySQL database information
    $servername = "####";
    $username = "####";
    $password = "####";
    $dbname = "#####";

    $conn = mysqli_connect($servername, $username, $password, $dbname);

    if(mysqli_connect_errno())
    {
      echo "Failed to connect to MySQL:".mysqli_connect_error();
      die();
    }
    else echo "MySQL connection OK";


    if ($_POST['colour']!="" && $_POST['make']!=""
    && $_POST['model']!="" && $_POST['vehicleID']!="")
    {
        $sql="INSERT INTO Vehicles(Colour, Make, Model, VehicleID) VALUES
        ('".$_POST['Colour']."','".$_POST['Make']."','".$_POST['Model']."','".$_POST['licensePlate'].");";
        $result = mysqli_query($conn, $sql);
    }


    if ($_GET['del']!="")
    {
    $sql="DELETE FROM People WHERE VehicleID=".$_GET['del'].";";
    $result = mysqli_query($conn, $sql);
    }

    // construct the SELECT query
    $sql = "SELECT * FROM Vehicles ORDER BY VehicleID;";
    // send query to database
    $result = mysqli_query($conn, $sql);

    echo "<br>" .mysqli_num_rows($result)." rows<br>";

    while($row = mysqli_fetch_assoc($result))
    {
        echo "<li>";
        echo $row["VehicleID"];
        echo " (Colour: ".$row["Colour"].") ";
        echo " (Make: ".$row["Make"].") ";
        echo " (Model: ".$row["Model"].") ";
        $ID = $row["VehicleID"];
        echo "<a href='?del=$ID'>delete</a>";
        echo "<br>";
    }

mysqli_close($conn);

?>


   </body>

   </html>