| 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/RecognitionLab_Code.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_recognitionlabQuestion).'\';
// 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.
';
// Create answers and parts arrays.
$QuestionAnswers = array();
$QuestionParts = array();
$QuestionPartNumber = 0;
// Loop through each question part.
mysqli_data_seek($questionpartResult, 0);
while ($questionpartRow = mysqli_fetch_assoc($questionpartResult)) {
$questionpartId = $questionpartRow['recognitionlabquestionpartId'];
$QuestionAnswers[$questionpartId] = array();
$QuestionPartNumber++;
$QuestionParts[$questionpartId] = array();
// Get DISTINCT question part answer data for this question part.
$query = "
SELECT DISTINCT recognitionlabquestionpartanswerText
FROM `recognitionlabquestionpartanswer`
WHERE recognitionlabquestionpartId = ".$questionpartRow['recognitionlabquestionpartId']."
ORDER BY recognitionlabquestionpartanswerText
";
$query = "
SELECT DISTINCT recognitionlabquestionpartanswerText
FROM `recognitionlabquestionpartanswer`
WHERE recognitionlabquestionpartId = ".$questionpartRow['recognitionlabquestionpartId']."
ORDER BY CAST(recognitionlabquestionpartanswerText AS DECIMAL), recognitionlabquestionpartanswerText
";
$questionpartanswerDistinctResult = query_do($query);
$questionpartanswerDistinctResultCount = $_SESSION['qry']['count'];
if ( $DEBUG_RecognitionLabCode ) printDivVar("\$questionpartanswerDistinctResult",$questionpartanswerDistinctResult);
if ( $questionpartanswerDistinctResultCount ) {
$QuestionAnswerNumber = 0;
// Loop through each DISTINCT question part answer;
mysqli_data_seek($questionpartanswerDistinctResult, 0);
while ($questionpartanswerDistinctRow = mysqli_fetch_assoc($questionpartanswerDistinctResult)) {
$QuestionAnswerNumber++;
$QuestionAnswers[$questionpartId][$questionpartanswerDistinctRow['recognitionlabquestionpartanswerText']] = $QuestionAnswerNumber;
$QuestionParts[$questionpartId][$QuestionAnswerNumber] = $questionpartanswerDistinctRow['recognitionlabquestionpartanswerText'];
}
}
}
if ( $DEBUG_RecognitionLabCode ) printDivVar("\$QuestionAnswers",$QuestionAnswers);
if ( $DEBUG_RecognitionLabCode ) printDivVar("\$QuestionParts",$QuestionParts);
// Create $Question['Answers'] code.
$code .='$Question[\'Answers\'] = array(
';
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.
if ( $questionpartResultCount) {
mysqli_data_seek($questionpartResult, 0);
while ($questionpartRow = mysqli_fetch_assoc($questionpartResult)) {
$questionpartId = $questionpartRow['recognitionlabquestionpartId'];
// 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,$QuestionAnswers[$questionpartId][$questionpartanswerRow['recognitionlabquestionpartanswerText']]);
} else {
$answerString = listAppend($answerString,'0');
}
}
}
$code .= $answerString.'",
';
}
}
$code .= '"");
';
// Create $Question['DataFrom'] code.
$code .='$Question[\'DataFrom\'] = array(
';
if ( $recognitionlabquestionResultCount) {
if ( $DEBUG_RecognitionLabCode ) printDivVar("\$recognitionlabquestionResult",$recognitionlabquestionResult);
mysqli_data_seek($recognitionlabquestionResult, 0);
while ($recognitionlabquestionRow = mysqli_fetch_assoc($recognitionlabquestionResult)) {
$code .= '"'.quot($recognitionlabquestionRow['recognitionlabquestionData']).'",
';
}
}
$code .= '"");
';
// Create $QuestionPart code.
$code .='$QuestionPart = array(); // Question part data.
';
// Create $QuestionPart['Text'] code.
$code .='$QuestionPart[\'Text\'] = array(
';
if ( $questionpartResultCount) {
mysqli_data_seek($questionpartResult, 0);
while ($questionpartRow = mysqli_fetch_assoc($questionpartResult)) {
$code .= '"'.quot($questionpartRow['recognitionlabquestionpartText']).'",
';
}
}
$code .= '"");
';
// Create $QuestionPart['Options'] code.
$code .='$QuestionPart[\'Options\'] = array("
';
foreach ( $QuestionParts as $QuestionPart ) {
foreach ( $QuestionPart as $QuestionPartText ) {
$code .= quot(str_replace('\\','\\\\',$QuestionPartText)).'|
';
}
$code = substr($code,0,-3)."\n";
$code .= '","
';
}
$code .= '");
';
// Create $QuestionPart['Value'] code.
$code .='$QuestionPart[\'Value\'] = array(
';
if ( $questionpartResultCount) {
mysqli_data_seek($questionpartResult, 0);
while ($questionpartRow = mysqli_fetch_assoc($questionpartResult)) {
$code .= quot($questionpartRow['recognitionlabquestionpartValue']).',
';
}
}
$code .= '"");
';
$code = trim($code)."\n";
$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.
?>