session_start();
if (!session_is_registered("LLC"))
{
// if session check fails, invoke error handler
header("Location: ../loginform.php");
exit();
}
$user = $_SESSION['UNAME'];
$ID = $_POST['id'];
$Semester = $_POST['semester'];
$Course = $_POST['course'];
$Title = $_POST['title'];
$Class = $_POST['class'];
$Days = $_POST['days'];
$StartTime = $_POST['starttime'];
$EndTime = $_POST['endtime'];
$dept = $_POST['dpt'];
list ($semester, $syear) = split (' ', $Semester);
//if ($dept == "AMLA" OR $dept == "Chinese" OR $dept == "Italian") {
if (strlen($Class) != 5){
//print "
You must enter the 5 digit ticket number.
";
//exit();
header("Location:newclass.php?id=$ID&error=1&course=$Course&title=$Title&days=$Days&starttime=$StartTime&endtime=$EndTime&dpt=$dept");
exit();
//}
} //else {
//if ($dept != "AMLA" OR $dept != "Chinese" OR $dept != "Italian") {
//if (strlen($Class) != 5) {
//print "
You must enter the 5 digit ticket number.
";
//exit();
// header("Location: newclass.php?id=$ID&error=$Class&course=$Course&title=$Title&days=$Days&starttime=$StartTime&endtime=$EndTime&dpt=$dept");
// exit();
//}
//}
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 classid from SR_course where Semester='$semester' and Year='$syear' and classid like '$Class' limit 1";
echo "
Success!
";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row = mysql_fetch_row($result)){
$check = $row[0];
}
if ($check == $Class) {
header("Location: newclass.php?id=$ID&error=2&course=$Course&title=$Title&days=$Days&starttime=$StartTime&endtime=$EndTime&dpt=$dept");
exit();
}
$query = "insert into SR_course set Semester='$semester', Year='$syear', CourseID='$Course', CourseTitle='$Title', ClassID='$Class', InstructorID='$ID', Days='$Days', BeginTime='$StartTime', EndTime='$EndTime'";
//$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
//$result = mysql_query($query, $connection) or die ("Duplicate entry $Class, please enter a new ticket number.");
$result = mysql_query($query, $connection) or die (header("Location:newclass.php?id=$ID&msg=$Class&course=$Course&title=$Title&days=$Days&starttime=$StartTime&endtime=$EndTime"));
header("Location: newclass.php?semester=$Semester&id=$ID");
exit();
?>