Untitled

   <html>

   <head>

     <title>Police Traffic Database</title>

   </head>

   <body>

    <form action="mersey.cs.nott.ac.uk/~psxrjt/policeDBaddINCIDENT.php" method="get">
         <input type="button" name="pressed" value="File Incident Report">
    </form>

   <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 = "mysql.cs.nott.ac.uk";
    $username = "psxrjt";
    $password = "database123";
    $dbname = "psxrjt";

    $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['licensePlate']!="")
    {
        $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 Vehicles 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>