session_start();
if (!session_is_registered("LLC"))
{
// if session check fails, invoke error handler
header("Location: ../loginform.php");
exit();
}
$user = $_SESSION['UNAME'];
$ID = isset($_GET['id']) ? $_GET['id'] : "";
$Class = isset($_GET['class']) ? $_GET['class'] : "";
include("../include/dbconfig.php");
$connection = mysql_connect($db_host, $db_user, $db_pass) or die ("Unable to connect!");
mysql_select_db($db_name);
if ($ID != '')
{
$query = "SELECT FirstName, LastName, Department from SR_instructor WHERE InstructorID='$ID'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
$FirstName = $row[0];
$LastName = $row[1];
$Department = $row[2];
}
if ($Class != '')
{
$query = "SELECT CourseID, CourseTitle, Days, BeginTime, EndTime, Year, Semester from SR_course WHERE ClassID='$Class'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
$TClass = $Class.' '.$row[0].' '.$row[1].' '.$row[2].' From '.$row[3].' To '.$row[4];
}
print <<Transfer Class $Class