<?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>Year Of passing</label>
                      <input type="text" class="form-control" name="passing_year" required />
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Mobile</label>
                      <input type="text" class="form-control" name="mobile_number" required />
                    </div>
                  </div>
                </div>
                <div class="row">
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Email</label>
                      <input type="email" class="form-control" name="email" required />
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Address</label>
                      <textarea class="form-control" name="address"></textarea>
                    </div>
                  </div>
                  <div class="col-md-12">
                    <div class="form-group">
                      <label>Other Info</label>
                      <textarea class="text_editor" name="other_info">
                      </textarea>
                    </div>
                  </div>
                </div>
                <div class="row">
                  <div class="col-md-8">
                    <div class="form-group">
                      <label for="exampleInputFile">Photos</label>
                      <div class="input-group">
                        <div class="custom-file">
                          <input type="file" class="custom-file-input fileUpload_allow" name="alumini_file" id="exampleInputFile" required>
                          <label class="custom-file-label" for="exampleInputFile">Choose file</label>
                        </div>
                      </div>
                    </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'];
  $passing_year = $_POST['passing_year'];
  $mobile_number = $_POST['mobile_number'];
  $email = $_POST['email'];
  $address = $_POST['address'];
  $other_info = mysqli_real_escape_string($con,$_POST['other_info']);

  $fileinfo=PATHINFO($_FILES["alumini_file"]["name"]);
  $newFilename="alumini_". time()."." .$fileinfo['extension'];

  $location="uploads/alumini/" . $newFilename;

  $ins = mysqli_query($con,"INSERT INTO `alumini` (`id`, `name`, `passing_year`, `mobile_number`, `email`, `address`, `otherinfo`, `photo`) VALUES (NULL, '$name', '$passing_year', '$mobile_number', '$email', '$address', '$other_info', '$location')");

  if($ins)
  {
    move_uploaded_file($_FILES["alumini_file"]["tmp_name"],$location);
    $_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>";
  }
}
?>