query("SELECT * FROM exams_by_students WHERE exam_id = '$exam_id' and student_id = '".$_SESSION['student']['id']."' "); if($check->num_rows){ echo ''; } else{ $exam = $con->query("SELECT * FROM exams as e,courses as c WHERE e.course_id = c.id AND e.id = '".$exam_id."' and e.status = '1' "); if($exam->num_rows){ // echo '
';
            // print_r($_SESSION);
            $myExam = $exam->fetch_assoc();
          
            $student = $con->query("SELECT * FROM students WHERE id = '".$_SESSION['student']['id']."'");
      
            if($student->num_rows){
                    $student = $student->fetch_assoc();
                    $allQues = [];
                    $questions = $con->query("SELECT * FROM exam_questions WHERE exam_id = '".$exam_id."'");
                    if($questions->num_rows){
                        $i = 0;
                        while($row = $questions->fetch_assoc()){
                            $data = [
                                    'title' => $row['question'],
                                    'id' => $row['id']
                                ];
                            $answers = $con->query("SELECT * FROM exam_question_answers_list WHERE exam_id = '$exam_id' and question_id ='".$row['id']."' ");
                            if($answers->num_rows){
                                $ans = [];
                                while($ansRow = $answers->fetch_assoc()){
                                    $ans[$ansRow['id']] = $ansRow['answer']; 
                                }
                                $data['answer_list'] = $ans;
                            }
                            $allQues[] = $data;
                        }
                    }
                    shuffle($allQues);
    
                    // Take only the first 20 elements
                    $allQues = array_slice($allQues, 0,$ttl_questions = $myExam['max_questions']);
                    // echo ;
                    // echo '';
                    // print_r($allQues);
                    // exit;
        ?>
       
        
        
            
              
            
    				
    				    
                        
                          Student Name:  
                        
                        
                          Student Email Id: 
                        
                        
                          Student Mobile No.: 
                        
                      
                
                      
                      
                        
                          Course Name: 
                        
                        
                          Admission Date: 
                        
                        
                          Exam Date: 
                        
                      
    				
    
    				
    					
    					    
    					    
                								 Q'.$i.'. '.$ques['title'].'
                								';
                								if(isset($ques['answer_list'])){
                								    foreach($ques['answer_list'] as $ans_id =>  $ans){
                								        echo '
                								                     '.$ans.'
                								              
';
                								    }
                								}
                								echo '
                							';
    					            $i++;
    					        }
    					        
    					    }
    					    
    					    ?>
    						
    						
    						    
                                  
                               
    						    
    						
    					
    					
    				
    			
        
        location.href="'.BASE_URL.'student_login.php";';
            }
        }
    }
    
}
require_once 'includes/footer.php';
?>