| 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/Course/ |
Upload File : |
<?
// Course/Course_classId_List.phpinc
// Get f_Course_classId_List.
$f_Course_classId_List = '';
if ($courseNumber != '') {
// Get the courseId.
$query = "
SELECT courseId
FROM course
WHERE courseNumber = '".$courseNumber."'
";
$courseResult = query_do($query);
$courseCount = $_SESSION['qry']['count'];
if ($courseCount) {
$courseInfo = mysqli_fetch_assoc($courseResult);
$f_courseId = $courseInfo['courseId'];
} else {
$f_courseId = 0;
}
#printVar("\$f_courseId",$f_courseId);
// Get the list of classIds.
$query = "
SELECT classId
FROM class
WHERE courseId = ".$f_courseId."";
if (!isset($anyYRTR) || $anyYRTR === false) {
$query .= "
AND YRTR = '".$_SESSION['YRTR']['User']."'";
}
$query .= "
AND modifiedBy = ".$_SESSION['userId']."
ORDER BY classId
";
$classResult = query_do($query);
$classCount = $_SESSION['qry']['count'];
// Create f_Course_classId_List.
if ($classCount) {
mysqli_data_seek($classResult, 0);
while ($classRow = mysqli_fetch_assoc($classResult)) {
$f_Course_classId_List .= $classRow['classId'].', ';
}
$f_Course_classId_List = substr($f_Course_classId_List,0,strlen($f_Course_classId_List)-2);
}
#printVar("\$f_Course_classId_List",$f_Course_classId_List);
#printVar("exit",'','fn'); exit;
}
?>