| 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/questionnaireProcess.phpinc
// Get questionnaire responses.
$f_questionNumber = formValue('questionNumber');
$f_classId = formValue('classId');
$f_courseId = formValue('courseId');
$f_courseNumber = formValue('courseNumber');
$f_courseTitle = formValue('courseTitle');
$f_question = array();
$f_questionAnswers = array();
$f_questionAnswer = array();
for ($i=1; $i<=$f_questionNumber; $i++) {
$f_question[$i] = formValue('question_'.$i);
$f_questionAnswers[$i] = formValue('questionAnswers_'.$i);
$f_questionAnswer[$i] = formValue('questionAnswer_'.$i);
}
// Save questionnaire.
$query = "
INSERT
INTO questionnaire (
classId,
courseId,
questionnaireCourseNumber,
questionnaireCourseTitle,
questionnaireUUID
) VALUES (
".$f_classId.",
".$f_courseId.",
'".$f_courseNumber."',
'".$f_courseTitle."',
'".$f_uuid."'
)
";
#printVar('',$query);
$questionnaireInsert = query_do($query);
// Ger the questionnaireId.
$f_questionnaireId = mysqli_insert_id($_SESSION['DATABASE_LINK']);
// Save questionnaire questions and answers.
for ($i=1; $i<=$f_questionNumber; $i++) {
$query = "
INSERT
INTO questionnairequestion (
questionnaireId,
questionnairequestionNumber,
questionnairequestionText,
questionnairequestionAnswers,
questionnairequestionAnswer
) VALUES (
".$f_questionnaireId.",
".$i.",
'".$f_question[$i]."',
'".$f_questionAnswers[$i]."',
'".$f_questionAnswer[$i]."'
)
";
#printVar('',$query);
$questionnairequestionInsert = query_do($query);
}
// Save that the user has completed the class questionnaire.
$query = "
INSERT
INTO questionnaire_class_user (
classId,
userId,
questionnaire_class_userUUID
) VALUES (
".$f_classId.",
".$_SESSION['userId'].",
'".$f_uuid."'
)
";
#printVar('',$query);
$questionnaire_class_userInsert = query_do($query);
// Stop page reload from submitting a duplicate questionnaire.
$_SESSION['UUID'] = $f_uuid;