<?php  
$page_title = 'Add Alumini';
include 'header.php';
?>
<div class="content-wrapper">
  <section class="content mt-4">
    <div class="container-fluid">
      <div class="row">
        <div class="col-md-12">
          <?php include('alert-msg.php'); ?>
          <div class="card card-primary">
            <div class="card-header">
              <h3 class="card-title"><?php echo $page_title; ?></h3>
            </div>
            <form action="" method="POST" enctype="multipart/form-data">
              <div class="card-body">
                <div class="row">
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Name</label>
                      <input type="text" class="form-control" name="name" required />
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Admitted Year</label>
                      <input type="text" class="form-control" name="admitted_year" required />
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Year Of passing</label>
                      <input type="text" class="form-control" name="passing_year" required />
                    </div>
                  </div>
                </div>
                <div class="row">
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Roll Number</label>
                      <input type="text" class="form-control" name="roll_number" required />
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>College</label>
                      <select class="form-control" name="college_id" required>
                          <option value="">Select College</option>
                          <?php
                            $sel_clg = mysqli_query($con, 'select * from college where is_active=1');
                            while($row_clg = mysqli_fetch_array($sel_clg)) {
                          ?>
                            <option value="<?php echo $row_clg['id']; ?>"><?php echo $row_clg['name']; ?></option>
                          <?php
                            }
                          ?>
                      </select>
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Course</label>
                      <input type="text" class="form-control" name="course" />
                    </div>
                  </div>
                </div>
                <div class="row">
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Mobile Number</label>
                      <input type="text" class="form-control" name="mobile_number" />
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Email</label>
                      <input type="email" class="form-control" name="email" />
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Address</label>
                      <textarea class="form-control" name="address"></textarea>
                    </div>
                  </div>
                </div>
                <div class="row">
                    <div class="col-md-4">
                        <div class="form-group">
                          <label>Current Occupation</label>
                          <textarea class="form-control" name="current_occupation"></textarea>
                        </div>
                      </div>
                </div>
                <button type="submit" class="btn btn-primary" name="btnSubmit">Submit</button>
              </div>
            </form>
          </div>
        </div>
      </div>
    </div>
  </section>
</div>
<?php include 'footer.php'; ?>


<?php
if(isset($_POST['btnSubmit']))
{
  $name = $_POST['name'];
  $admitted_year = $_POST['admitted_year'];
  $passing_year = $_POST['passing_year'];
  $roll_number = $_POST['roll_number'];
  $college_id = $_POST['college_id'];
  $course = $_POST['course'];
  $mobile_number = $_POST['mobile_number'];
  $email = $_POST['email'];
  $address = $_POST['address'];
  $current_occupation = $_POST['current_occupation'];

  $ins = mysqli_query($con,"INSERT INTO `alumini` (`id`, `name`, `admitted_year`, `passing_year`, `roll_number`, `college_id`, `course`, `mobile_number`, `email`, `address`, `current_occupation`) VALUES (NULL, '$name', '$admitted_year', '$passing_year', '$roll_number', '$college_id', '$course', '$mobile_number', '$email', '$address', '$current_occupation')");

  if($ins)
  {
    $_SESSION['success_msg'] = 'Alumini has been added...';
    echo"<script>window.location='alumini.php';</script>";
  }
  else
  {
    $_SESSION['error_msg'] = 'Unable to add Alumini...';
    echo"<script>window.location='alumini.php';</script>";
  }
}
?>