<?php
    include('header.php');
    $news_letter_class = "newsletter-area-2";
?>

<section class="page-banner">
    <div class="page-banner-bg bg_cover" style="background-image: url(assets/images/page-banner.jpg);">
        <div class="container">
            <div class="banner-content text-center">
                <h2 class="title">Register</h2>
            </div>
        </div>
    </div>
</section>

<section class="mb-50">
    <div class="container">
        <div class="mt-50">
                            <?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 class="mt-50">
            <div class="row justify-content-center">
                <div class="col-lg-8">
                    <div class="contact-title text-center">
                        <h3 class="title">SCHOLARSHIP REGISTER FORM</h3>
                        <p>SRI SAYABANNA N TEGGINAMANI  SCHOLARSHIP  EXAMINATION REGISTRATION FORM 
</p>
                    </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">
                                        <input type="text" name="name" placeholder="Name">
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <input type="text" name="father_name" placeholder="Father Name">
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <input type="number" name="mobile_number" placeholder="Mobile Number">
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <input type="number" name="aadhar_no" placeholder="Aadhar No">
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <input type="text" name="school_name" placeholder="School Name">
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <input type="text" name="address" placeholder="Address">
                                    </div>
                                </div>
                                <div class="col-md-12">
                                    <div class="single-form">
                                        <textarea name="remarks" placeholder="Remarks"></textarea>
                                    </div>
                                </div>
                                <p class="form-message"></p>
                                <div class="col-md-12">
                                    <div class="single-form text-center">
                                        <button class="main-btn" name="btnSubmit">Submit</button>
                                    </div>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>

<?php include('footer.php'); ?>


<?php
if(isset($_POST['btnSubmit']))
{
  $name = $_POST['name'];
  $father_name = $_POST['father_name'];
  $mobile_number = $_POST['mobile_number'];
  $aadhar_no = $_POST['aadhar_no'];
  $school_name = $_POST['school_name'];
  $address = $_POST['address'];
  $remarks = $_POST['remarks'];

  $ins = mysqli_query($con,"INSERT INTO `register` (`name`, `father_name`, `mobile_number`, `aadhar_no`, `school_name`, `address`, `remarks`) VALUES ('$name', '$father_name', '$mobile_number', '$aadhar_no', '$school_name', '$address', '$remarks')");

  if($ins)
  {
    $_SESSION['success_msg'] = 'Your registration has been successfully...';
    echo"<script>window.location='register.php';</script>";
  }
  else
  {
    $_SESSION['error_msg'] = 'Unable to register your details...';
    echo"<script>window.location='register.php';</script>";
  }
}
?>