Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <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['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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement