query("INSERT INTO `exam` (`id`, `course_id`, `exam_name`, `max_questions`) VALUES (NULL, '".$_POST['course_id']."', '".$_POST['exam_name']."', '".$_POST['max_questions']."')"); echo ''; } if(isset($_GET['action']) && $_GET['action'] == 'del' && isset($_GET['id'])) { $exam_id = $_GET['id']; // Assign the value of 'id' to $exam_id $con->query("DELETE FROM exam WHERE id = '$exam_id'"); $delete = $con->query("DELETE FROM exam_question WHERE exam_id ='$exam_id'"); // print_r($delete);exit; echo ''; } if($_GET['action'] == 'changeStatus'){ $val = $_GET['val']?0:1; $id = $_GET['id']; $con->query("UPDATE `exam` SET `status`= '$val' WHERE id = '$id'"); echo ''; } ?>

Add Exam

List Exam

query("SELECT exam.id as exam_id, exam.exam_name, exam.max_questions, courses.course_name,courses.id as cid FROM exam JOIN courses ON exam.course_id = courses.id"); while($exam = $data->fetch_assoc()) { $statusBtn = $exam['status'] ? 'success' : 'danger'; $statusIcon = $exam['status'] ? 'on' : 'off'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; // echo ''; // Schedule column // Status column echo ''; // Action column echo ''; } ?>
#. Course Name Exam Title Max Questions Questions Schedule Action
'.$i++.''.$exam['course_name'].''.$exam['exam_name'].''.$exam['max_questions'].' Add // //