<?php
include('header.php');
$news_letter_class = "newsletter-area-2";
?>
<section class="">
	<div class="container">
		<div class="event-details-content mb-50">
			<div class="contact-form">
            <div class="row justify-content-center">
                <div class="col-lg-8">
                    <div class="contact-title text-center">
                        <h3 class="title">Alumni</h3>
                        <div class="mt-20">
                            <?php
if(isset($_SESSION['error_msg']))
{
  ?>
  <div class="alert alert-danger alert-dismissible fade show" role="alert">
    <?php echo $_SESSION['error_msg']; ?>
    <button type="button" class="close" data-dismiss="alert" aria-label="Close">
      <span aria-hidden="true">&times;</span>
    </button>
  </div>
  <?php
  unset($_SESSION['error_msg']);
}
?>
<?php
if(isset($_SESSION['success_msg']))
{
  ?>
  <div class="alert alert-success alert-dismissible fade show" role="alert">
    <?php echo $_SESSION['success_msg']; ?>
    <button type="button" class="close" data-dismiss="alert" aria-label="Close">
      <span aria-hidden="true">&times;</span>
    </button>
  </div>
  <?php
  unset($_SESSION['success_msg']);
}
?>
                        </div>
                    </div>
                </div>
            </div>
            <div class="row justify-content-center">
                <div class="col-lg-8">
                    <div class="contact-form-wrapper">
                        <form action="" method="POST" enctype="multipart/form-data">
                            <div class="row">
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <label>Member of Institute</label>
                                        <select name="institute">
                                            <option>LIONS ENGISH MEDIUM SCHOOL</option>
                                            <option>LIONS KANNADA MEDIUM SCHOOL</option>
                                            <option>LIONS PU COLLAGE</option>
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="row">
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <label>Name</label>
                                        <input type="text" name="name" placeholder="Name" required>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <label>Email</label>
                                        <input type="email" name="email" placeholder="Email" required>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <label>Mobile Number</label>
                                        <input type="text" name="mobile_number" placeholder="Mobile Number" required>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <label>Year Of Passing</label>
                                        <input type="text" name="passing_year" placeholder="Year Of Leaving" required>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <label>Address</label>
                                        <input type="text" name="address" placeholder="Address" required>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <label>Photos</label>
                                        <input type="file" name="alumini_file" required>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <label>Qualification</label>
                                        <input type="text" name="present_status" placeholder="Qualification" required>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <label>Current Profession</label>
                                        <input type="text" name="present_working_place" placeholder="Current Profession" required>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <label>Area of Interest	</label>
                                        <input type="text" name="area_of_interest" placeholder="Area of Interest" required>
                                    </div>
                                </div>
                                <div class="col-md-12">
                                    <div class="single-form">
                                        <label>Nostalgia / Memorable Event</label>
                                        <textarea name="other_info" placeholder="Write here..."></textarea>
                                    </div>
                                </div>
                                <p class="form-message"></p>
                                <div class="col-md-12">
                                    <div class="single-form text-center">
                                        <button class="main-btn" type="submit" name="btnSubmit">Submit</button>
                                    </div>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
		</div>
	</div>
</section>
<?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 = $_POST['other_info'];
  $institute = $_POST['institute'];
  $present_status = $_POST['present_status'];
  $present_working_place = $_POST['present_working_place'];
  $area_of_interest = $_POST['area_of_interest'];

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

  $location="uploads/alumini/" . $newFilename;
  
  $ins = mysqli_query($con,"INSERT INTO `alumini`(`institute`, `name`, `passing_year`, `mobile_number`, `email`, `address`, `otherinfo`, `photo`, `present_status`, `present_working_place`, `area_of_interest`) VALUES ('$institute','$name','$passing_year','$mobile_number','$email','$address','$other_info','$location','$present_status','$present_working_place','$area_of_interest')");

  if($ins)
  {
    move_uploaded_file($_FILES["alumini_file"]["tmp_name"],"adminweb/".$location);
    $_SESSION['success_msg'] = 'Alumni has been added...';
    echo"<script>window.location='alumni.php';</script>";
  }
  else
  {
    $_SESSION['error_msg'] = 'Unable to add Alumni...';
    echo"<script>window.location='alumni.php';</script>";
  }
}
?>