
<?php

$con = new mysqli(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);

 $course_id = $request->getAttribute('course_id');
  $season_id=$request->getAttribute('season_id');
   $exams_id=$request->getAttribute('exams_id');
    $date=$request->getAttribute('date');
	$time=$request->getAttribute('time');
     $exam_name=$request->getAttribute('exam_name');
      $proctor_id=$request->getAttribute('proctor_id');
       $block=$request->getAttribute('block');
	    $floor=$request->getAttribute('floor');
	     $room=$request->getAttribute('room');
	      $papers=$request->getAttribute('papers');
	       $total_students=$request->getAttribute('total_students');
	        $students=$request->getAttribute('students');


$response=array();
if(isset($course_id)&&isset($season_id)&&isset($exams_id)&&isset($date)&&isset($time)){
	$sql="SELECT proctors_sheet.course_id, proctors_sheet.season_id, proctors_sheet.exams_id, proctors_sheet.date, proctors_sheet.time,
	proctors_sheet.proctor_id, proctors_sheet.room,
	course.course_name, season.seasonname, Exams.examname, faculty.Faculty_name, faculty.Staff_number 
	from (proctors_sheet  INNER JOIN course ON course.course_id=proctors_sheet.course_id 
 INNER JOIN season ON season.id=proctors_sheet.season_id
 INNER JOIN Exams ON Exams.id=proctors_sheet.exams_id
 INNER JOIN faculty ON faculty.id=proctors_sheet.proctor_id) WHERE proctors_sheet.course_id='$course_id' AND proctors_sheet.season_id='$season_id' 
 AND proctors_sheet.exams_id='$exams_id' AND proctors_sheet.date='$date' AND proctors_sheet.time='$time'";
}
elseif(isset($course_id)&&isset($season_id)&&isset($exams_id)&&isset($date)){
	$sql="SELECT proctors_sheet.course_id, proctors_sheet.season_id, proctors_sheet.exams_id, proctors_sheet.date, proctors_sheet.time,
	proctors_sheet.proctor_id, proctors_sheet.room,
	course.course_name, season.seasonname, Exams.examname, faculty.Faculty_name, faculty.Staff_number 
	from (proctors_sheet  INNER JOIN course ON course.course_id=proctors_sheet.course_id 
 INNER JOIN season ON season.id=proctors_sheet.season_id
 INNER JOIN Exams ON Exams.id=proctors_sheet.exams_id
 INNER JOIN faculty ON faculty.id=proctors_sheet.proctor_id) WHERE proctors_sheet.course_id='$course_id' AND proctors_sheet.season_id='$season_id' 
 AND proctors_sheet.exams_id='$exams_id' AND proctors_sheet.date='$date'";
}
elseif(isset($course_id)&&isset($season_id)&&isset($exams_id)){
	$sql="SELECT proctors_sheet.course_id, proctors_sheet.season_id, proctors_sheet.exams_id, proctors_sheet.date, proctors_sheet.time,
	proctors_sheet.proctor_id, proctors_sheet.room,
	course.course_name, season.seasonname, Exams.examname, faculty.Faculty_name, faculty.Staff_number 
	from (proctors_sheet  INNER JOIN course ON course.course_id=proctors_sheet.course_id 
 INNER JOIN season ON season.id=proctors_sheet.season_id
 INNER JOIN Exams ON Exams.id=proctors_sheet.exams_id
 INNER JOIN faculty ON faculty.id=proctors_sheet.proctor_id) WHERE proctors_sheet.course_id='$course_id' AND proctors_sheet.season_id='$season_id' 
 AND proctors_sheet.exams_id='$exams_id'";
}
elseif(isset($course_id)&&isset($season_id)){
	$sql="SELECT proctors_sheet.course_id, proctors_sheet.season_id, proctors_sheet.exams_id, proctors_sheet.date, proctors_sheet.time,
	proctors_sheet.proctor_id, proctors_sheet.room,
	course.course_name, season.seasonname, Exams.examname, faculty.Faculty_name, faculty.Staff_number 
	from (proctors_sheet  INNER JOIN course ON course.course_id=proctors_sheet.course_id 
 INNER JOIN season ON season.id=proctors_sheet.season_id
 INNER JOIN Exams ON Exams.id=proctors_sheet.exams_id
 INNER JOIN faculty ON faculty.id=proctors_sheet.proctor_id) WHERE proctors_sheet.course_id='$course_id' AND proctors_sheet.season_id='$season_id'";
}
elseif(isset($course_id)){
	$sql="SELECT proctors_sheet.course_id, proctors_sheet.season_id, proctors_sheet.exams_id, proctors_sheet.date, proctors_sheet.time,
	proctors_sheet.proctor_id, proctors_sheet.room,
	course.course_name, season.seasonname, Exams.examname, faculty.Faculty_name, faculty.Staff_number 
	from (proctors_sheet  INNER JOIN course ON course.course_id=proctors_sheet.course_id 
 INNER JOIN season ON season.id=proctors_sheet.season_id
 INNER JOIN Exams ON Exams.id=proctors_sheet.exams_id
 INNER JOIN faculty ON faculty.id=proctors_sheet.proctor_id) 	WHERE proctors_sheet.course_id='$course_id'";
}
else{
	$sql="SELECT proctors_sheet.course_id, proctors_sheet.season_id, proctors_sheet.exams_id, proctors_sheet.date, proctors_sheet.time,
	proctors_sheet.proctor_id, proctors_sheet.room,
	course.course_name, season.seasonname, Exams.examname, faculty.Faculty_name, faculty.Staff_number 
	from (proctors_sheet  INNER JOIN course ON course.course_id=proctors_sheet.course_id 
 INNER JOIN season ON season.id=proctors_sheet.season_id
 INNER JOIN Exams ON Exams.id=proctors_sheet.exams_id
 INNER JOIN faculty ON faculty.id=proctors_sheet.proctor_id)";
}


$result=mysqli_query($con,$sql);

    while ($row[]=mysqli_fetch_assoc($result)) {  

      $user=$row;

	}


echo json_encode($user);

?>