<?php
	include 'config.php';
	$del = $_REQUEST['id'];
	$array = array();
	if($del != ""){
		$query = "DELETE FROM sp_exam WHERE exam_id='$del'";
		$sql = $db->prepare($query);
		if($sql->execute()){

			$exam_links = $db->prepare("DELETE FROM sp_exam_links WHERE exam_id='$del'");
			$exam_links->execute();

			$exam_cutoff = $db->prepare("DELETE FROM sp_exam_cutoff WHERE exam_id='$del'");
			$exam_cutoff->execute();

			$exam_pattern = $db->prepare("DELETE FROM sp_exam_pattern WHERE exam_id='$del'");
			$exam_pattern->execute();

			$vacancy_detail = $db->prepare("DELETE FROM sp_vacancy_detail WHERE exam_id='$del'");
			$vacancy_detail->execute();

			$physical_eligibility = $db->prepare("DELETE FROM sp_physical_eligibility WHERE exam_id='$del'");
			$physical_eligibility->execute();

			$array = array('status'=>1, 'msg'=>"Exam is Successfully Deleted. ");
		} else {
			$array = array('status'=>0, 'msg'=>"Exam is not Deleted.");
		}
	} else {
		$array = array('status'=>0, 'msg'=>"Delete ID is not Existed");
	}
	echo json_encode($array);
?>