Adding another view - Department Course Listings
Create another PHP file that displays course information based upon a department_code parameter.
courses.php- take a "department_code" parameter and produce alist of courses for that department.
Need to link to to courses.php:
Modify the department listing to include the hyperlink:
<!DOCTYPE html>
<html>
<head>
<title>Departments</title>
<link rel="stylesheet" href="site.css" type="text/css"/>
</head>
<body>
<h1>Faculty of Arts & Sciences</h1>
<h2>Departments</h2>
<?php
// Connecting, selecting database
$mysqli = new mysqli('localhost','class','cscie12','coursecatalog');
if ($mysqli->connect_errno) {
echo "Failed to connect to mysql: ".$mysqli->connect_errno." ".$mysqli->connect_error;
}
// Performing SQL query
$query = 'SELECT distinct department_short, department_code FROM courses order by department_short';
$result = $mysqli->query($query);
// Printing results in HTML
echo "<ul>\n";
while ($row = $result->fetch_assoc()) {
echo "<li>";
echo "<a href=\"courses.php?department_code=$row[department_code]\">$row[department_short]</a>";
echo "</li>\n";
}
echo "</ul>\n";
// Free resultset
$result->free();
// Close connection
$mysqli->close();
?>
</body>
</html>