Viewing file:  submitAnswer.php (7.38 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
require 'connection.php';
$type= $_REQUEST['type'];
if($type=='Multiple choice'){
$p_type=1;
}
else if($type=='Comprehensive'){
$p_type=2;
}
$anserArray=array();
$user_id=$_REQUEST['user_id'];
$exam_details_id=$_REQUEST['exam_id'];
$exam_type_id=$p_type;
$score=$_REQUEST['score'];
$total_q=$_REQUEST['total_question'];
$total_not_ate=$_REQUEST['total_not_attend'];
$time_start=$_REQUEST['time_start'];
$time_end=$_REQUEST['time_end'];
$sc= $score;
$ttotal=$total_q;
$percentage=($sc/$ttotal)*100;
$mark_status="";
$image="";
if($percentage==100){
$mark_status="Outstanding";
$image="";
}
else if($percentage>=80 ){
$mark_status="Excellent";
$image="";
}
else if($percentage>=70){
$mark_status="Very good";
$image="";
}
else if($percentage>=60){
$mark_status="Good";
$image="";
}
else if($percentage>=50){
$mark_status="Average";
$image="";
}
else if($percentage>=40){
$mark_status="Poor";
$image="";
}
else if($percentage>=0){
$mark_status="Very Bad";
$image="";
}
$userid=$user_id;
$sqldata="select * from tb_user where user_id='$userid' and delete_status=0";
$resultdata=$con_it->query($sqldata);
$countdata=$resultdata->num_rows;
$row=$resultdata->fetch_assoc();
$phone=$row['phone'];
$query="SELECT *
FROM `user_details`
INNER JOIN enrolldetails ON user_details.user_id=enrolldetails.user_id where user_details.phone='$phone'";
$queryResult=$con->query($query);
$queryCount=$queryResult->num_rows;
$s="select * from exam where exam_id=$exam_details_id";
$r=$con->query($s);
$ro=$r->fetch_assoc();
$batch_id=$ro['batch_id'];
$semester=$ro['semester'];
$subject=$ro['subject'];
$exam_title=$ro['exam_title'];
$date=date('Y-m-d');
if($queryCount>0){
$queryRow=$queryResult->fetch_assoc();
$uid=$queryRow['user_id'];
//echo $uid;die();
$sql="select * from exam_result where exam_id=$exam_details_id";
$result=$con->query($sql);
$count=$result->num_rows;
if($count>0){
$row=$result->fetch_assoc();
$details=$row['id'];
$query="update exam_result set no_of_correct_answer='$score',batch_id='$batch_id',semester='$semester',subject='$subject',exam_title='$exam_title',time_start='$time_start',time_end='$time_end',start_date='$date',total_q='$total_q' where exam_id='$exam_details_id' and stud_id='$uid'";
$queryResult=$con->query($query);
$viewdata="SELECT * FROM `exam_result` where result_id='$details' ";
$viewResult=$con->query($viewdata);
while($viewRow=$viewResult->fetch_assoc()){
$viewData[]=array('id'=>$viewRow['result_id'],
"user_id"=>$viewRow['stud_id'],
"exam_details_id"=>$viewRow['exam_id'],
"exam_type_id"=>"",
"session_id"=>"",
"date"=>$viewRow['start_date'],
"score"=>$viewRow['no_of_correct_answer'],
"total_q"=>$viewRow['total_q'],
"total_not_ate"=>"",
"time_start"=>$viewRow['time_start'],
"time_end"=>$viewRow['time_end']);
}
$result=array('status'=>true,
'message'=>'Answer Submit Success',
'mark_status'=>$mark_status,
'image'=>$image,
'answer_details'=>$viewData);
}
else{
$query="insert into exam_result(stud_id,exam_id,batch_id,no_of_correct_answer,total_q,time_start,time_end,start_date,semester,subject,exam_title) values('$uid','$exam_details_id','$batch_id','$score','$total_q','$time_start','$time_end','$date','$semester','$subject','$exam_title')";
$queryResult=$con->query($query);
$last_id = $con->insert_id;
$viewdata="SELECT * FROM `exam_result` where result_id='$last_id' ";
$viewResult=$con->query($viewdata);
while($viewRow=$viewResult->fetch_assoc()){
$viewData[]=array('id'=>$viewRow['result_id'],
"user_id"=>$viewRow['stud_id'],
"exam_details_id"=>$viewRow['exam_id'],
"exam_type_id"=>"",
"session_id"=>"",
"date"=>$viewRow['start_date'],
"score"=>$viewRow['no_of_correct_answer'],
"total_q"=>$viewRow['total_q'],
"total_not_ate"=>"",
"time_start"=>$viewRow['time_start'],
"time_end"=>$viewRow['time_end']);
}
$result=array('status'=>true,
'message'=>'Answer Submit Success',
'mark_status'=>$mark_status,
'image'=>$image,
'answer_details'=>$viewData);
}
}
else{
$sql="select * from exam_result where exam_details_id=$exam_details_id";
$result=$con_it->query($sql);
$count=$result->num_rows;
if($count>0){
$row=$result->fetch_assoc();
$details=$row['id'];
$query="update exam_result set exam_type_id='$p_type',score='$score',total_q='$total_q',total_not_ate='$total_not_ate',time_start='$time_start',time_end='$time_end' where exam_details_id='$exam_details_id' and user_id='$user_id'";
$queryResult=$con_it->query($query);
$viewdata="SELECT * FROM `exam_result` where id='$details' ";
$viewResult=$con_it->query($viewdata);
while($viewRow=$viewResult->fetch_assoc()){
$viewData[]=array('id'=>$viewRow['id'],
"user_id"=>$viewRow['user_id'],
"exam_details_id"=>$viewRow['exam_details_id'],
"exam_type_id"=>$viewRow['exam_type_id'],
"session_id"=>$viewRow['session_id'],
"date"=>$viewRow['date'],
"score"=>$viewRow['score'],
"total_q"=>$viewRow['total_q'],
"total_not_ate"=>$viewRow['total_not_ate'],
"time_start"=>$viewRow['time_start'],
"time_end"=>$viewRow['time_end']);
}
$result=array('status'=>true,
'message'=>'Answer Submit Success',
'mark_status'=>$mark_status,
'image'=>$image,
'answer_details'=>$viewData);
}
else{
$query="insert into exam_result(user_id,exam_details_id,exam_type_id,score,total_q,total_not_ate,time_start,time_end) values('$user_id','$exam_details_id','$p_type','$score',' $total_q','$total_not_ate','$time_start','$time_end')";
$queryResult=$con_it->query($query);
$last_id = $con_it->insert_id;
$viewdata="SELECT * FROM `exam_result` where id='$last_id' ";
$viewResult=$con_it->query($viewdata);
while($viewRow=$viewResult->fetch_assoc()){
$viewData[]=array('id'=>$viewRow['id'],
"user_id"=>$viewRow['user_id'],
"exam_details_id"=>$viewRow['exam_details_id'],
"exam_type_id"=>$viewRow['exam_type_id'],
"session_id"=>$viewRow['session_id'],
"date"=>$viewRow['date'],
"score"=>$viewRow['score'],
"total_q"=>$viewRow['total_q'],
"total_not_ate"=>$viewRow['total_not_ate'],
"time_start"=>$viewRow['time_start'],
"time_end"=>$viewRow['time_end']);
}
$result=array('status'=>true,
'message'=>'Answer Submit Success',
'mark_status'=>$mark_status,
'image'=>$image,
'answer_details'=>$viewData);
}
}
echo json_encode($result);
?>
|