<?php
 include('include/header.php'); 
  if(!empty($_GET['edit']))
   {
     $selectData = executework("SELECT * from  exam_timeTable where id = '".$_GET['edit']."'");
       $row = mysqli_fetch_array($selectData);
        $selectData1 = executework("SELECT * from  branch_data where id = '".$row['class_id']."'"); 
         $rowData = mysqli_fetch_array($selectData1); 
   }


?>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<main id="main" class="main">

<div class="pagetitle">
  <h1>Apple IIT Schools</h1>
  <nav>
    <ol class="breadcrumb">
      <li class="breadcrumb-item"><a href="index.php">Home</a></li>
      <li class="breadcrumb-item active">Time Table List</li>
    </ol>
  </nav>
</div>
<section class="section">
      <div class="row">
        <div class="col-lg-12">

          <div class="card">
            <div class="card-body">
              <h5 class="card-title">Edit Time Table</h5>

<?php
 if(!empty($_POST['submit']))
   {
      
      $update = executework("update exam_timeTable set exam_type = '".$_POST['exam_type']."',exam_date = '".date('Y-m-d',strtotime($_POST['exam_date']))."',subjects = '".$_POST['subjectid']."' where id = '".$_POST['edit_data']."'");
     redirect('exam_report.php?upd=1');
   }
?>
    <form  method="post"> 
      <div class="row">
        <div class="col-md-2 mt-4">
            <label for="exampleInputEmail1" class="form-label">Academic Year :</label>
          
        </div>
      <div class="col-md-2 mt-4">
       <h5><strong><?= $rowData['year']?></strong></h5>
      </div>

        <div class="col-md-2 mt-4">
            <label for="exampleInputEmail1" class="form-label">Branch :</label>
          
        </div>

      <div class="col-md-2 mt-4">
       <h5><strong><?= $rowData['branch']?></strong></h5>
      </div>

        <div class="col-md-2 mt-4">
            <label for="exampleInputEmail1" class="form-label">Class :</label>
          
        </div>
      <div class="col-md-2 mt-4">
       <h5><strong><?= $rowData['class']?></strong></h5>
      </div>
       

       <div class="col-md-2 mt-4">
            <label for="exampleInputEmail1" class="form-label">Section :</label>
          
        </div>
      <div class="col-md-2 mt-4">
       <h5><strong><?= $rowData['section']?></strong></h5>
      </div>
     <div class="col-md-2 mt-4">
            <label for="exampleInputEmail1" class="form-label">Syllabus Type :</label>
          
        </div>
      <div class="col-md-2 mt-4">
       <h5><strong><?= $rowData['syllabus']?></strong></h5>
      </div>
       
          
      </div>
        
    
   <div class="row mt-4">
    <h5 class="text-center card-title">Exam Time Table</h5>
    
      <div class="col-md-3 mt-4">
            <?php
                   $select_subject = executework("SELECT * from subjects where year = '".$rowData['year']."' and class = '".$rowData['class']."' and section = '".$rowData['section']."' and syllabus = '".$rowData['syllabus']."'");

            ?>
             <select name="subjectid" id="subject" class="form-control">
              <option value="">Please Select Subjects</option>
              <?php
                 while($subRow = mysqli_fetch_array($select_subject)){
              ?>
              <option value="<?= $subRow['subject']?>" <?php if($subRow['subject'] == $row['subjects'] ){ echo 'selected';}?>><?= $subRow['subject']?></option>
             <?php
                 }
             ?>
           </select>
            
        </div>
     <div class="col-md-3 mt-4">
       <input type="text" name="exam_type" id="exam_type" value="<?= strtoupper($row['exam_type'])?>" class="form-control" placeholder="Enter Exam Type" required>
     </div>
     <div class="col-md-3 mt-4">
       <input type="text" name="exam_date" id="datepicker" value="<?= date('d-M-Y',strtotime($row['exam_date']))?>" class="form-control" placeholder="Select Exam Date" readonly required>
     </div>
    
   <input type="hidden" name="edit_data" value="<?=$row['id']?>">
   <div class="mt-4">
   <input type="submit" name="submit" value="Update" class="btn btn-primary">
 </div>
</div>
    </form>
  

        </div>
      </div>
          </div>
    </section>
  


</main><!-- End #main --> 

<script src="https://code.jquery.com/jquery-1.11.1.min.js"></script>
<script src="https://cdn.jsdelivr.net/jquery.validation/1.16.0/jquery.validate.min.js"></script>
<script src="https://cdn.jsdelivr.net/jquery.validation/1.16.0/additional-methods.min.js"></script>
  <script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>

  
    
  
   
  
 <?php include('include/footer.php'); ?>