Sorry, you must input the instructor's first name and last name.";
exit();
}
if (strlen($Password)<3)
{
print "
Sorry, password must be at least 3 letters.
";
exit();
}
$InstructorID=strtolower(substr(str_replace(" ", "", $FirstName),0,1).substr(str_replace(" ", "", $LastName),0,7));
$ID = $InstructorID;
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 Department, FirstName, LastName from SR_instructor WHERE InstructorID = '$InstructorID'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$i=0;
while (mysql_num_rows($result)>0)
{
$i++;
$InstructorID = $ID."$i";
$query = "SELECT Department, FirstName, LastName from SR_instructor WHERE InstructorID = '$InstructorID'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
}
$query = "insert into SR_instructor set Department='$Department', InstructorID='$InstructorID', Password=OLD_PASSWORD($Password), FirstName='$FirstName', LastName='$LastName', Extension='$Extension', Email='$Email', Home='$Home'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
if ($Email==''){$Email='langlab@mtsac.edu';}
include("../SendMail.php");
$TEXT="Dear Prof. $LastName\n\n";
$TEXT=$TEXT."We have created an account for you to use our online reservation system.\n\n";
$TEXT=$TEXT."Your user id is: $InstructorID\n";
$TEXT=$TEXT."Your initial password is: $Password\n\n";
$TEXT=$TEXT."Please take a couple of minutes to change your password and update your personal information by clicking on the following link:\n";
$TEXT=$TEXT."https://www.mtsac.edu/llc/login/reservation/reservation.php\n\n";
$TEXT=$TEXT."If you have any question, please call us at (909)594-5611, Ext. 4580. Thank you.\n\n\n";
$TEXT=$TEXT."Language Learning Center\n";
SendMail(
"langlab@mtsac.edu","Language Learning Center", //sender
$Email, $FirstName." ".$LastName, //recipient
"langlab@mtsac.edu", // copy to
"Your account for Language Learning Center reservation system.", //subject
$TEXT,$HTML,$ATTM); //body and attachment(s)
print <<New instructor added
New instructor has been added.
END;
if ($Email<>'')
{
print << Add classes for $FirstName $LastName | Make a reservation for:
END;
$query = "SELECT Year, Semester from SR_semester WHERE EndDate >= CURDATE() and OpenDate <= CURDATE() and Status='1'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row = mysql_fetch_array($result))
{
print <<$row[1] $row[0]
END;
}
print <<Sign Out
END;
print <<