| 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/Class/RecognitionLab/ |
Upload File : |
<?
// Class/RecognitionLab/RecognitionLabCode.phpinc
// Display Recognition lab code.
#$DEBUG_RecognitionLabCode = true;
if ( !isset($DEBUG_RecognitionLabCode) ) $DEBUG_RecognitionLabCode = false;
debugTrackBegin(); // Begin TRACKing included file.
$code = '
$Question = array(); // Question data.
// Question instructions.
$Question[\'Instructions\'] = \''.quot($f_recognitionlabName).'\';
// The number of questions.
$Question[\'Number\'] = '.$recognitionlabquestionResultCount.';
// A quoted comma seperated list of answers for each question. Each question part answer is also seperated by a comma.
$Question[\'Answers\'] = array(
';
// Create
// Create $Question['Answers'] code.
if ( $recognitionlabquestionResultCount) {
if ( $DEBUG_RecognitionLabCode ) printDivVar("\$recognitionlabquestionResult",$recognitionlabquestionResult);
mysqli_data_seek($recognitionlabquestionResult, 0);
while ($recognitionlabquestionRow = mysqli_fetch_assoc($recognitionlabquestionResult)) {
$code .= '"';
$answerString = '';
// Loop through each question part.
mysqli_data_seek($questionpartResult, 0);
while ($questionpartRow = mysqli_fetch_assoc($questionpartResult)) {
// Get DISTINCT question part answer data for this question part.
$query = "
SELECT DISTINCT recognitionlabquestionpartanswerText
FROM `recognitionlabquestionpartanswer`
WHERE recognitionlabquestionpartId = ".$questionpartRow['recognitionlabquestionpartId']."
ORDER BY recognitionlabquestionpartanswerText
";
$questionpartanswerDistinctResult = query_do($query);
$questionpartanswerDistinctResultCount = $_SESSION['qry']['count'];
if ( $DEBUG_RecognitionLabCode ) printDivVar("\$questionpartanswerDistinctResult",$questionpartanswerDistinctResult);
$query = "
SELECT recognitionlabquestionpartanswerId,
recognitionlabquestionId,
recognitionlabquestionpartId,
recognitionlabquestionpartanswerText
FROM `recognitionlabquestionpartanswer`
WHERE recognitionlabquestionId = ".$recognitionlabquestionRow['recognitionlabquestionId']."
AND recognitionlabquestionpartId = ".$questionpartRow['recognitionlabquestionpartId']."
";
#if ( $DEBUG_RecognitionLabCode ) printVar("\$query",$query,'q');
$questionpartanswerResult = query_do($query);
#if ( $DEBUG_RecognitionLabCode ) printDivVar("\$questionpartanswerResult",$questionpartanswerResult);
$questionpartanswerResultCount = $_SESSION['qry']['count'];
if ( $questionpartanswerResultCount ) {
$questionpartanswerRow = mysqli_fetch_assoc($questionpartanswerResult);
$answerString = listAppend($answerString,$questionpartanswerRow['recognitionlabquestionpartId']);
} else {
$answerString = listAppend($answerString,'0');
}
}
$code .= $answerString.'",
';
}
}
$code .= '"");
';
$code = trim($code);
$height = (int)(substr_count($code,"\n")*1.25) + 1;
if ( $DEBUG_RecognitionLabCode ) printDivVar('$recognitionlabquestionResult',$recognitionlabquestionResult);
if ( $DEBUG_RecognitionLabCode ) printDivVar('$questionpartResult',$questionpartResult);
?>
<fieldset><legend><?=quot($f_recognitionlabName)?> code</legend>
<textarea style="width:100%; height:<?=$height?>em;">
<?=$code?>
</textarea>
</fieldset>
<?
debugTrackEnd(); // End TRACKing included file.
?>