<?php
  // echo '<pre>';
  // print_r($_POST);
  $db = mysqli_connect('162.214.81.24','vehiclea_appleIITSchool','Ramesh@465','vehiclea_appleIIT')or die(mysqli_connect_error()); 
 

  
  $number = count($_POST['subjectid']);

  $query1 =  "INSERT INTO branch_data (class,section,syllabus,branch,year) values('".$_POST['class_name']."','".$_POST['section']."','".$_POST['syllabus']."','".$_POST['Branch']."','".$_POST['Year']."')";

    $insert1 = mysqli_query($db,$query1);
    $id =  mysqli_insert_id($db);
    
  if(!empty($id)){
   $insert_id = $id;

  $query = "INSERT INTO exam_timeTable (class_id,subjects,exam_type,exam_date) values";
  for($i=0; $i<$number; $i++)
  {
    
    $query .="('$insert_id','".$_POST['subjectid'][$i]."','".$_POST['exam_type'][$i]."','".$_POST['exam_date'][$i]."'),";
  }
   $finalquery = rtrim($query,',');
  
 $insert = mysqli_query($db,$finalquery);

 if(!empty($insert))
 {
    header('location: exam_type.php?succ=1');
 }
}
  
?>