session_start(); if (!session_is_registered("LLC")) { // if session check fails, invoke error handler header("Location: ../loginform.php"); exit(); } $user = $_SESSION['UNAME']; //$getcourse = $_GET['course']; //$getdays = $_GET['days']; //$gettitle = $_GET['title']; //$getstarttime = $_GET['starttime']; //$getendtime = $_GET['endtime']; $getclass = $_GET['class']; $getid = $_GET['id']; $semester = $_GET['semester']; include("../include/dbconfig.php"); $connection = mysql_connect($db_host, $db_user, $db_pass) or die ("Unable to connect!"); mysql_select_db($db_name); $query = "SELECT CourseID, CourseTitle, ClassID, Days, BeginTime, EndTime from SR_course WHERE classID='$getclass'"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); while ($row = mysql_fetch_row($result)) { $course = $row[0]; $title = $row[1]; $classid = $row[2]; $days = $row[3]; $starttime = $row[4]; $endtime = $row[5]; } $query = "SELECT InstructorID, FirstName, LastName from SR_instructor where instructorID='$getid'"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); while ($row = mysql_fetch_row($result)) { $FirstName = $row[1]; $LastName = $row[2]; } ?>