| 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/DARS.cloak/ |
Upload File : |
<?
// Admin/DARS/DARSAASA306.phpinc
// Explain menu choices.
$sectionTitle = 'DARSAASA306.phpinc';
$IncludeSummerSessions = false;
require('common/sectionHeader.phpinc');
?>
<?
$query = "
SELECT DISTINCT darsStudentId
FROM dars
WHERE darsCredentialCode = 'AAS A306'
AND darsDatePrepared > '2016'
ORDER BY darsStudentId
";
#d_Var('darsStudentIdResult',$query,'dq');
$darsStudentIdResult = query_do($query);
$darsStudentIdResultCount = $_SESSION['qry']['count'];
#d_Var('$darsStudentIdResult',$darsStudentIdResult,'d');
$darssectionclass = array();
if ( $darsStudentIdResultCount ) {
mysql_data_seek($darsStudentIdResult, 0);
while ($darsRow = mysql_fetch_assoc($darsStudentIdResult)) {
$query = "
SELECT darsId
, darsStudentId
, darsStudentFirstName
, darsStudentLastName
, darsDatePrepared
, darsCredentialCode
FROM dars
WHERE 1=1
AND darsStudentId = '".$darsRow['darsStudentId']."'
AND darsCredentialCode = 'AAS A306'
AND darsDatePrepared = (
SELECT MAX(darsDatePrepared)
FROM dars
WHERE darsStudentId = '".$darsRow['darsStudentId']."'
AND darsCredentialCode = 'AAS A306'
)
";
#d_Var('darsByStudentIdResult',$query,'dq');
$darsByStudentIdResult = query_do($query);
$darsByStudentIdResultCount = $_SESSION['qry']['count'];
#d_Var('$darsByStudentIdResult',$darsByStudentIdResult,'d');
if ( $darsByStudentIdResultCount ) {
mysql_data_seek($darsByStudentIdResult, 0);
$darsIdRow = mysql_fetch_assoc($darsByStudentIdResult);
d_Var('$darsIdRow',$darsIdRow,'d');
$query = "
SELECT *
FROM darssectionclass
WHERE darsId = ".$darsIdRow['darsId']."
";
#d_Var('darssectionclassResult',$query,'dq');
$darssectionclassResult = query_do($query);
$darssectionclassResultCount = $_SESSION['qry']['count'];
#d_Var('$darssectionclassResult',$darssectionclassResult,'d');
if ( $darssectionclassResultCount ) {
mysql_data_seek($darssectionclassResult, 0);
while ($darsclassRow = mysql_fetch_assoc($darssectionclassResult)) {
$id = $darsclassRow['darssectionclassDept'].twoDigit($darsclassRow['darssectionclassNumb'],4).$darsclassRow['darssectionclassCredits'];
$id = $darsclassRow['darssectionclassDept'].twoDigit($darsclassRow['darssectionclassNumb'],4);
if ( !isset($darssectionclass[$id]) ) {
$darssectionclass[$id] = array();
$darssectionclass[$id]['Dept'] = $darsclassRow['darssectionclassDept'];
$darssectionclass[$id]['Numb'] = $darsclassRow['darssectionclassNumb'];
#$darssectionclass[$id]['Cr'] = $darsclassRow['darssectionclassCredits'];
}
}
}
}
}
}
d_Var('$darssectionclass',$darssectionclass,'d');
require('common/sectionFooter.phpinc');
?>