<?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['subject_name']);
$select_query = "SELECT * FROM subjects where class = '".$_POST['class_name']."' and section='".$_POST['section']."' and syllabus = '".$_POST['syllabus']."' and year ='".$_POST['Year']."'";
$select_query = mysqli_query($db,$select_query);
if(mysqli_num_rows($select_query)>0)
{
   header('location: subjects.php?failed=1');
}
  
   
else{
  for($i=0; $i<$number; $i++)
  {
  $query1 =  "INSERT INTO subjects (class,subjects,syllabus,year,create_date) values('".$_POST['class_name']."','".$_POST['section']."','".$_POST['syllabus']."','".$_POST['Year']."','".date('Y-m-d H:i:s')."')";

    }
 
    $finalquery = rtrim($query,',');
  
 $insert = mysqli_query($db,$finalquery);
 
  
 if(!empty($insert))
 {
    header('location: subjects.php?succ=1');
 }

 
  }
?>