<?php
     include_once('connect.php');
    session_start(); 
    
    // Check if the user is logged in
    if (!isset($_SESSION['loggedin']) || $_SESSION['loggedin'] !== true) {
         echo "<script type='text/javascript'>window.location.href = 'index.php';</script>"; // Redirect to login page
        exit();
    }
    
    
    include_once('head.php');
?>
<head>
  <style type="text/css">
    textarea{
      width: 400px;
      height: 100px;
      border-radius: var(--bs-border-radius);
    }
  </style>
</head>
<?php
    
    if(isset($_POST["btnStaff"]))
    {
        $pname=$_POST['txtPrincipal'];
        $teacherno=$_POST['txtTeacher'];
        $pgt=$_POST['txtPgt'];
        $tgt=$_POST['txtTgt'];
        $prt=$_POST['txtPrt'];
        $ratio=$_POST['txtRatio'];
        $educator=$_POST['txtEducator'];
        $counsellor=$_POST['txtCounsellor'];
        
        $sql=mysqli_query($con,"INSERT INTO `tbl_staff`(`principal_name`, `teacher_no`, `pgt`, `tgt`, `prt`, `teacher_ratio`, `educator`, `counsellor`) VALUES ('$pname','$teacherno','$pgt','$tgt','$prt','$ratio','$educator','$counsellor')");
        

        //FOR uploading image from tempname to uploads/packages folder
       
        if($sql){
                echo "<script>alert('Staff(Teaching) Added');</script>";
           
        }else{ 
             echo "<script>alert('Failed!!');</script>";
        } 
        
        mysqli_close($con);
       
    }
    ?>


  <main id="main" class="main">

    <div class="pagetitle">
      <!-- <h1>Dashboard</h1> -->
      <nav>
        <ol class="breadcrumb">
          <li class="breadcrumb-item"><a href="index.html">Home</a></li>
          <li class="breadcrumb-item active">Add Staff(Teaching)</li>
        </ol>
      </nav>
    </div><!-- End Page Title -->
 <section class="section">
      <div class="row">
        <div class="col-lg-1">
        </div>
        <div class="col-lg-10">
          <div class="card">
            <div class="card-body">
              <div class="row mb-3 bord-bottom">
              <div class="col-lg-5"><h5 class="card-title">Add New Staff(Teaching)</h5></div>
              <div class="col-lg-5"><h5 class="card-title title-right"><a href="update_staff.php" class="btn btn-secondary">Update Staff(Teaching)</a></h5></div>
              </div>
              <div class="row mb-3">  

              </div>
              <!-- General Form Elements -->
                <form name="FormStaff(Teaching)" method="post" enctype="multipart/form-data" class="pt-20">
                <div class="row mb-3">
                  <label for="inputText" class="col-sm-4 col-form-label">PRINCIPAL</label>
                  <div class="col-sm-5">
                    <input type="text" id="txtPrincipal" name="txtPrincipal" class="form-control" required="">
                  </div>
                </div>
                 <div class="row mb-3">
                  <label for="inputText" class="col-sm-4 col-form-label">TOTAL NO. OF TEACHERS</label>
                  <div class="col-sm-5">
                    <input type="text" id="txtTeacher" name="txtTeacher" class="form-control" >
                  </div>
                </div>
                 <div class="row mb-3">
                  <label for="inputText" class="col-sm-4 col-form-label">PGT</label>
                  <div class="col-sm-5">
                    <input type="text" id="txtPgt" name="txtPgt" class="form-control">
                  </div>
                </div>
                 <div class="row mb-3">
                  <label for="inputText" class="col-sm-4 col-form-label">TGT</label>
                  <div class="col-sm-5">
                    <input type="text" id="txtTgt" name="txtTgt" class="form-control">
                  </div>
                </div>
                 <div class="row mb-3">
                  <label for="inputText" class="col-sm-4 col-form-label">PRT</label>
                  <div class="col-sm-5">
                    <input type="text" id="txtPrt" name="txtPrt" class="form-control">
                  </div>
                </div>
                 <div class="row mb-3">
                  <label for="inputText" class="col-sm-4 col-form-label">TEACHERS SECTION RATIO</label>
                  <div class="col-sm-5">
                    <input type="text" id="txtRatio" name="txtRatio" class="form-control">
                  </div>
                </div>
                 <div class="row mb-3">
                  <label for="inputText" class="col-sm-4 col-form-label">DETAILS OF SPECIAL EDUCATOR</label>
                  <div class="col-sm-5">
                    <input type="text" id="txtEducator" name="txtEducator" class="form-control">
                  </div>
                </div>
                 <div class="row mb-3">
                  <label for="inputText" class="col-sm-4 col-form-label">DETAILS OF COUNSELLOR AND WELLNESS TEACHER</label>
                  <div class="col-sm-5">
                    <input type="text" id="txtCounsellor" name="txtCounsellor" class="form-control">
                  </div>
                </div>
                <div class="row mb-3 pt-20">
                  <label class="col-sm-4 col-form-label"></label>
                  <div class="col-sm-5 ">
                    <input type="submit" class="btn btn-primary  btn-center" name="btnStaff" id="btnStaff" value="Submit">
                    
                  </div>
                </div>

              </form><!-- End General Form Elements -->

            </div>
          </div>

        </div>
         <div class="col-lg-1">
        </div>
      </div>
    </section>

  </main><!-- End #main -->
  <?php
        include_once('footer.php');
   ?>