<?php  
$page_title = 'Add Academic Calender';
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>Events</label>
                      <input type="text" class="form-control" name="event_name" required />
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Week</label>
                      <input type="text" class="form-control" name="week" required />
                    </div>
                  </div>
                </div>
                <div class="row">
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Month/Year</label>
                      <input type="date" class="form-control" name="event_date" required />
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Guests</label>
                      <input type="text" class="form-control" name="guests" 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']))
{
  $event_name = $_POST['event_name'];
  $event_date = $_POST['event_date'];
  $week = $_POST['week'];
  $guests = $_POST['guests'];

  $ins = mysqli_query($con,"INSERT INTO `academic_calender` (`id`, `event_name`, `event_date`, `week`, `guests`) VALUES (NULL, '$event_name', '$event_date', '$week', '$guests')");

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