=$checkExpiredDate && !empty($checkExpiredDate)){ echo "
"; echo "

Your session has already been expired.

Good Luck ".$user_data['u_fname']."!



"; echo "
"; echo "
"; } if(isset($_GET['nu'])){ date_default_timezone_set('Asia/Singapore'); $currentDate = date("m/d/Y H:i:s"); $currentDate_timestamp = strtotime($currentDate); $endDateTime = strtotime("+".$addTime." Minutes", $currentDate_timestamp); $packageEndDateTime = date("m/d/Y H:i:s", $endDateTime); echo "
"; echo "

You are about to start the ".$_GET['trn']." part of the ".$title ." exam. You only have ".$_GET['nu']." minutes to complete and answer all questions.

Good Luck ".$user_data['u_fname']."!



"; echo "
"; echo "
"; $chkIfPrevExist = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pod_exam_taken` WHERE `exam_id`='$examID' AND `training_id`='$trainingID' AND `employee_id`='$userID' AND `type`='$examType'"),0); if($chkIfPrevExist != '0' ){ }else{ $sql="INSERT INTO `pod_exam_taken` (`id`,`employee_id`,`exam_id`,`training_id`,`date_started`,`time_started`,`date_finished`,`time_finished`,`type`,`chk_required`) VALUES('','$userID','$examID','$trainingID','$toDate','$currentTime','$packageEndDateTime','$packageEndDateTime','$examType','YES')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); } } } //SAVE ANSWERS if(isset($_POST['submitAnswer'])){ $questionID=$_POST['recID']; $examID=$_POST['myXID']; $trainingID=$_POST['myTRID']; $myAnswer=$_POST['myAnswer']; //$correctAnswer=$_POST['correctAnswer']; $SysMessage='Answer saved...'; $myAnswer = mysql_real_escape_string($myAnswer); $chkIfExist = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pod_exam_true_false_answer` WHERE `exam_id`='$examID' AND `training_id`='$trainingID' AND `question_id`='$questionID' AND `employee_id`='$empID' AND `ex_type`='$examType'"),0); //echo "


CHECK IF EXIST: ".$chkIfExist . "QID: ".$questionID. "ANSWER ".$myAnswer; //break; if($chkIfExist != '0' ){ mysql_query("UPDATE `pod_exam_true_false_answer` SET `my_answer`='$myAnswer',`score`='$score' WHERE `exam_id`='$examID' AND `training_id`='$trainingID' AND `question_id`='$questionID' AND `employee_id`='$empID' AND `ex_type`='$examType'"); }else{ $sql="INSERT INTO `pod_exam_true_false_answer` (`id`,`employee_id`,`exam_id`,`question_id`,`training_id`,`correct_answer`,`my_answer`,`score`,`date`,`time`,`ex_type`) VALUES('','$empID','$examID','$questionID','$trainingID','0','$myAnswer','$score','$toDate','$currentTime','$examType')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); } } } echo "
"; echo "
".$xmType.": ".$xmTitle."
X
"; //START OF CODE--====================================================================================================== echo "

Exam will End at exactly ".$checkExpiredDate ."

"; echo "
"; echo ""; echo ""; echo ""; echo "
"; echo "
"; echo "

YOUR ESSAY QUESTION:"; $qq = mysql_query("SELECT * FROM `pod_exam_essay` WHERE `exam_id`='$examID' ORDER BY `id` ASC"); while($arow=mysql_fetch_array($qq)){ echo "

"; echo $arow['question']; echo "
"; } echo "
"; echo "		"; echo "
"; echo "

TYPE YOUR ANSWER IN THE TEXT BOX BELOW"; $qq = mysql_query("SELECT * FROM `pod_exam_essay` WHERE `exam_id`='$examID' ORDER BY `id` ASC"); while($row=mysql_fetch_array($qq)){ $queID = $row['id']; $prevAnswer = mysql_result(mysql_query("SELECT `my_answer` FROM `pod_exam_true_false_answer` WHERE `training_id`='$trainingID' AND `question_id`='$queID' AND `employee_id`='$empID' AND `exam_id`='$examID' AND `ex_type`='$examType'"),0); echo "

"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

"; echo "  "; echo "
"; echo "
"; } echo "".$SysMessage.""; echo "
"; echo "
"; //END OF CODE=================================================================================================================== echo "
"; ?>