Untitled

<!DOCTYPE html>
<html>
<head>
<title>Contact</title>

<meta charset="utf-8">
    <!-- Required for responsive view when on mobile -->
  <meta name="viewport" content="width=device-width, initial-scale=1">

  <!-- calling custom css links -->
<link rel="stylesheet" type="text/css" href="Stylesheet1.css"/>
<link rel="stylesheet" type="text/css" href="contactCSS.css"/>

<!-- Calling the Boostrap 4 stylesheet and JavaScript Library  -->
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>

<!-- jQuery -->
  <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js" integrity="sha384-ChfqqxuZUCnJSK3+MXmPNIyE6ZbWh2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy" crossorigin="anonymous"></script>
  <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.bundle.min.js" integrity="sha384-pjaaA8dDz/5BgdFUPX6M/9SUZv4d12SUPF0axWc+VRZkx5xU3daN+lYb49+Ax+Tl" crossorigin="anonymous"></script>


  <script>
  $( function() {
    $( "input" ).checkboxradio();
  } );
  </script>
    <script>
  $( function() {
    $( document ).tooltip();
  } );
  </script>

</head>
<body>

<?php

// Connecting to the database

include('dbconnect.php');

// Create SQLi query to display records from database

$query = "SELECT * FROM feedback ORDER BY user_id ASC";
$result = mysqli_query($conn, $query);


?>

<div class="container">
   <img class="logo" src="images/Tool.jpg" alt="Logo">
</div>

<div class="header">
  <ul class="nav justify-content-center">
    <li class="nav-item">
      <a class="nav-link" style="color: white" href="Home.htm">Home</a>
    </li>
    <li class="nav-item">
      <a class="nav-link" style="color: white" href="Suppliers.htm">Suppliers</a>
    </li>
    <li class="nav-item">
      <a class="nav-link" style="color: white" href="Products.htm">Products</a>
    </li>
    <li class="nav-item">
      <a class="nav-link" style="color: white" href="Contact.htm">Contact us</a>
    </li>
    <li class="nav-item">
      <a class="nav-link" style="color: white" href="FindUs.htm">Find Us</a>
    </li>
  </ul>
</div>

 <div class="container">
  <form  action="insert.php" class="contact" class="was-validated" method="post">

    <label for="fname">First Name</label>
    <input type="text" id="fname" required="required" name="firstname" placeholder="Your name..">

    <label for="lname">Last Name</label>
    <input type="text" id="lname" required="required" name="lastname" placeholder="Your last name..">

    <fieldset>
      <label for="fname">Gender:   </label>
      <label for="radio-1">Male</label>
      <input type="radio" name="radio-1" id="radio-1">
      <label for="radio-2">Female</label>
      <input type="radio" name="radio-1" id="radio-2">
    </fieldset>

    <label for="fname">Email Address</label>
    <input type="text" id="fname" name="email" required="required" placeholder="Your email.."  title="Please entere a valid email address.">

    <label for="subject">Subject</label>
    <textarea id="subject" name="subject" required="required" placeholder="Write something.." style="height:200px"></textarea>

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

  </form>
</div>

<div class="col-sm-8">
<h3>Display All Users</h3>
<table class="table table-hover">
<thead>
    <tr>
        <th>user_id</th>
        <th>Firstname</th>
        <th>Surname</th>
        <th>Email</th>
        <th>Subject</th>
    </tr>
</thead>

<tbody>

<?php

while ($row = mysqli_fetch_assoc($result)){


?>

<tr>
    <td><?php echo $row['user_id'];?></td>
    <td><?php echo $row['Firstname'];?></td>
    <td><?php echo $row['Lastname'];?></td>
    <td><?php echo $row['Email'];?></td>
    <td><?php echo $row['Subject'];?></td>


<td>
<a href="edit2.php?id=<?php echo $row['user_id']; ?>"><button type='button' class='btn btn-info btn-xs fa fa-edit'></button></a>
<a href="delete.php?id=<?php echo $row['user_id']; ?>"><button type='button' class='btn btn-danger btn-xs fa fa-trash'></button></a>
</td>
</tr>
<?php
}
mysqli_close($conn);


?>


</tbody>
</table>


</body>

<!-- Footer with bootstrap4 code for style-->
<footer class="footer">

  <!-- Copyright -->
  <div class="footer-copyright text-center py-3">© 2019 Copyright:
    <a href="https:#"> cavc.ac.uk</a>
    <p>Contact information: <a href="adrian_rowlands@msn.com">adrian_rowlands@msn.com</a></p>
  </div>
  <!-- Copyright -->

</footer>
<!-- Footer -->

</footer>
<!-- Footer -->

</html>