| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/Admin/Class/ |
Upload File : |
<?
// Admin/Class/ClassDrop.phpinc
debugTrackBegin();
if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","<b>".__FILE__."</b><br>\n"; }
#setDebugOn(); include('common/pageFooter.phpinc');
if ($_SESSION['uuid'] != $f_uuid) {
// Get classmeetingId for this class.
$f_classId = formValue('classId');
$f_courseNumber = formValue('courseNumber');
$f_classSection = formValue('classSection');
$query = "
SELECT classmeetingId
FROM `classmeeting`
WHERE classId = ".$f_classId."
";
$classmeetingResult = query_do($query);
$classmeetingResultCount = $_SESSION['qry']['count'];
if ( $classmeetingResultCount ) {
mysqli_data_seek($classmeetingResult, 0);
while ($classmeetingRow = mysqli_fetch_assoc($classmeetingResult)) {
// DELETE all classmeeting_weekday entries.
$query = "
DELETE
FROM `classmeeting_weekday`
WHERE classmeetingId = ".$classmeetingRow['classmeetingId']."
";
$classmeeting_weekdayDelete = query_do($query);
}
// DELETE all classmeeting entries.
$query = "
DELETE
FROM `classmeeting`
WHERE classId = ".$f_classId."
";
$classmeeting_weekdayDelete = query_do($query);
}
// DELETE the class.
$query = "
DELETE FROM class
WHERE classId = ".$f_classId."
";
$classDelete = query_do($query);
$f_message = $f_courseNumber.'-'.$f_classSection.' dropped.';;
$_SESSION['uuid'] = $f_uuid;
$_SESSION['message'] = $f_message;
} else {
$f_message = $_SESSION['message'];
}
debugTrackEnd();
?>