<?php
  include('include/include.php');
  if($_POST['type'] == 1){
    // echo "SELECT * FROM subjects,subject_list where subjects.year = '".$_POST['yeardata']."' and subjects.class = '".$_POST['Clist1']."'  and subjects.syllabus = '".$_POST['syllabus']."' and subjects.id =subject_list.class_id ";
     $section = executework("SELECT * FROM subjects,subject_list where subjects.year = '".$_POST['yeardata']."' and subjects.class = '".$_POST['Clist1']."'  and subjects.syllabus = '".$_POST['syllabus']."' and subjects.id =subject_list.class_id ");
     ?>
       <option value="">--Select Subject</option>
     <?php
     
    while( $row = mysqli_fetch_array($section) )
     {
               
              ?>
                <option value="<?php echo $row["subject"];?>"><?php echo strtoupper($row["subject"]);?></option>
              <?php

     }
 

  }
?>

<?php
if($_POST['type']==2)
   {
     

      $selectSubData = executework("select * from subjects where year = '".$_POST['year']."' and class = '".$_POST['class_name']."' and syllabus = '".$_POST['syllabus']."' ");
       ?>
         <table class="table">
           <tr>
             <th>S.No</th>
             <th>Subjects</th>
             <th>Action</th>
           </tr>
           <?php
              $i=1;
             while($subRow = mysqli_fetch_array($selectSubData)){
           ?>
           <tr>
             <td><?= $i;?></td>
             <td><?= $subRow['subject'] ?></td>
             <td><a href="javascript:void();" onclick="confirmDelete(<?php echo $subRow['id']?>)" class="btn btn-danger">Delete</a>
              <a href="javascript:void();" onclick="subject_edit(<?php echo $subRow['id']?>)" class="btn btn-success">Edit</a>

             </td>
           </tr>
           <?php
              $i++;
              }
           ?>
         </table>
       <?php
   }
    if($_POST['type'] == 3){
   
     $section = executework("SELECT * FROM sections where class = '".$_POST['PresentClass']."'");
     ?>
       <option value="">--Select Section</option>
     <?php
     
    while( $row = mysqli_fetch_array($section) )
     {
               
              ?>
                <option value="<?php echo $row["section"];?>"><?php echo strtoupper($row["section"]);?></option>
              <?php

     }
 

  }
   if($_POST['type'] == 4){
   
     $Subjects = executework("SELECT * FROM subjects where class = '".$_POST['class_name']."' and year = '".$_POST['academic_year']."'");
     ?>
       <option value="">--Select Subjects</option>
     <?php
     
    while( $row = mysqli_fetch_array($Subjects) )
     {
               
              ?>
                <option value="<?php echo $row["subjects"];?>"><?php echo strtoupper($row["subjects"]);?></option>
              <?php

     }
 

  }
  if($_POST['type'] == 5){
   
     $exam_type = executework("SELECT * FROM exam_type where class = '".$_POST['class_name']."' and year = '".$_POST['academic_year']."'");
     ?>
       <option value="">--Select Exam Type</option>
     <?php
     
    while( $row = mysqli_fetch_array($exam_type) )
     {
               
              ?>
                <option value="<?php echo $row["exam_type"];?>"><?php echo strtoupper($row["exam_type"]);?></option>
              <?php

     }
 

  }

  if($_POST['type'] == 6){
   
    $update_table = executework("UPDATE exam_time_table set exam_date = '".date('Y-m-d',strtotime($_POST['exam_date']))."',exam_time = '".$_POST['exam_time']."' where id = '".$_POST['id']."'");
   echo $update_table;
   
  }
?>