<?php  
$page_title = 'Add Committee';
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>Committee</label>
                      <input type="text" class="form-control" name="committee" required />
                    </div>
                  </div>
                  <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>Designation</label>
                      <input type="text" class="form-control" name="designation" required />
                    </div>
                  </div>
                </div>
                <div class="row">
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Others</label>
                      <input type="text" class="form-control" name="others" required />
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Order</label>
                      <input type="number" class="form-control" name="order" required />
                    </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']))
{
  $committee = $_POST['committee'];
  $name = $_POST['name'];
  $designation = $_POST['designation'];
  $others = $_POST['others'];
  $order = $_POST['order'];

  $ins = mysqli_query($con,"INSERT INTO `committee` (`id`, `committee`, `name`, `designation`, `others`, `order_by`) VALUES (NULL, '$committee', '$name', '$designation', '$others', $order)");

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