3
require_once 'includes/header.php';
10
require_once 'conf/conf.php';
11
$dbc=mysqli_connect(dbConf::$dbHostname, dbConf::$dbUser, dbConf::$dbPasswd,dbConf::$dbName);
13
if (isset($_GET['courseId'])) { //if visitor wants particular course
14
$q='SELECT * FROM courses WHERE courseId="'.$_GET['courseId'].'";';
15
$r=mysqli_query($dbc,$q);
17
echo "<br> ".mysqli_error($dbc)."<br>"."Query: ".$q;
19
if (mysqli_num_rows($r)==0) { //courseId not found
20
echo '<h2 class="largeHeading">Invalid Course Id</h2>';
21
echo '<p>Click <a href="javascript:window.back();">here</a> to go back or <a href="course.php">here</a> to view all the courses available.</p>';
24
$rows=mysqli_fetch_array($r);
26
$q='SELECT * FROM professors WHERE profId = "'.$rows['instructorId'].'";';
27
$r=mysqli_query($dbc,$q);
29
echo "<br> ".mysqli_error($dbc)."<br>"."Query: ".$q;
31
if (mysqli_num_rows($r)==0) {
32
//instructor not found
34
$row2=mysqli_fetch_array($r);
36
echo '<table class="courseData">';
39
echo "<th>Course</th>";
40
echo "<td>{$rows['courseCode']}-{$rows['courseName']}</td>";
44
echo "<th>Description</th>";
45
echo "<td><p>{$rows['courseDesc']}</p></td>";
48
echo "<th>Instructor</th>";
49
echo "<td>{$row2['name']}</td>";
55
else { //display ability to choose course
64
<?php require_once('login/login_box.php'); ?>
69
require_once 'includes/footer.php';