<?php
include('db_conn.php'); //db connection
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<!-- jQuery library -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css">
<!-- Link to use icon-->
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.7.0/css/all.css" integrity="sha384-lZN37f5QGtY3VHgisS14W3ExzMWZxybE1SJSEsQp9S+oqd12jhcu+A56Ebc1zFSJ" crossorigin="anonymous">
<!-- Latest compiled JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js"></script>
<!-- Popper JS -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
</head>
<body>
<div class ="container">
<h2 align ="center">Unit details</h2>
<div style="overflow-x:auto;">
<button type="button" class="btn btn-light"><a href="tute7_main.php"> Back to the Main</a></button>
<table class="table" style="border:2px">
<tr>
<th scope="col">ID</th>
<th scope="col">Unit Code</th>
<th scope="col">Unit Name</th>
<th scope="col">Lecturer</th>
<th scope="col">Semester</th>
</tr>
<?php
include ('db_conn.php');
$query="select * from units";
$result = $mysqli->query($query);
while ($row = $result->fetch_array(MYSQLI_ASSOC))
{
echo"<tr><td>".$row["id"]."</td><td>".$row["unit_code"]
."</td><td>".$row["unit_name"]."</td><td>".$row["lecturer"]."</td><td>".$row["semester"]."</td><tr>";
}
?>
</table>
</div>
<button type="button" class="btn btn-success"><a href="tute7_manage.php">Manage Unit Details</a></button>
</div>
</body>
</html>
