Untitled

<?php
$name = $_POST['name'];
$nameOfChild = $_POST['name2'];
$age = $_POST['age'];
$date = $_POST['date'];
$phone = $_POST['phone'];
$email = $_POST['email'];
$comment = $_POST['comment'];

if(!empty($name) || !empty($name2) || !empty($age) || !empty($date) || !empty($phone) || !empty($email)) {
    $host = "localhost";
    $dbUsername = "root";
    $dbPassword = "";
    $dbname = "agi_reg_database";

    // connection
    $conn = new mysqli($host, $dbUsername, $dbPassword,$dbname);
    if(mysqli_connect_error()) {
      die('Connect Error(' . mysqli_connect_error().')'. mysqli_connect_error());
    }else{
      $SELECT = "SELECT email From register Where email = ? Limit 1";
      $INSERT = "INSERT Into register (name,name2,age,date,phone,email,comment) value(?,?,?,?,?,?,?)";

      // prepare statement
      $stmt = $conn->prepare($SELECT);
      $stmt->bind_param("s", $email);
      $stmt->execute();
      $stmt->bind_result($email);
      $stmt->store_result();
      $rnum = $stmt->num_rows;

      if($rnum==0){
        $stmt->close();

        $stmt = $conn->prepare($INSERT);
        $stmt->bind_param("ssiiiss"$name,$name2,$age,$date,$phone,$email,$comment);
        $stmt->execute();
        echo "New record inserted successfully";
      }else {
        echo "Someone already registered with this email address";
      }
      $stmt->close();
      $conn->close();
    }
}else {
  echo "All fields are required";
  die();
}

 ?>

<!DOCTYPE html>
<html lang="en" dir="ltr">

<head>
  <meta charset="utf-8">
  <title>UNI - Unique Individuals</title>
  <link rel="stylesheet" href="style.css">
  <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">

  <style>
    * {
  margin: 0;
  padding: 0;
  box-sizing: border-box;
}

body {
  background-image: url('img/bg4.jpg');
  background-repeat: no-repeat;
  background-attachment: fixed;
  background-size: cover;
  background-position: center;
  margin-top: 150px !important;
}

.register-left {
  text-align: center;
  color: #000;
  padding: 30px;
}

.register-left img {
  margin-top: 60px;
  margin-bottom: 18px;
  width: 80px;
  animation: mover 1s infinite alternate;
}

.register-left p {
  padding: 20px 20px 0;
  font-size: 30px;
  font-weight: 600;
}

.register-left .btn-primary {
  border-radius: 1.5rem;
  border: none;
  width: 120px;
  background: rgba(124, 252, 0, 1);
  font-weight: 600;
  color: #000;
  margin-top: 20px;
  padding: 20px;
}

.register-left .btn-primary:hover {
  background: #000;
}

.register-right {
  border: none;
  background: rgba(0, 0, 0, .4);
  border-top-left-radius: 10% 50%;
  border-bottom-left-radius: 10% 50%;
  padding: 50px;
}

.register-right {
  text-align: center;
  margin-bottom: 10px;
  color: #fff;
  ;
}

.register-form {
  padding: 30px;
  width: 90%;
  margin: 0 auto;
}

#datepicker {
  width: 276px;
}

.register-right .btn-primary {
  float: right;
  border-radius: 1.5rem;
  border: none;
  width: 120px;
  background: rgba(124, 252, 0, 1);
  font-weight: 600;
  color: #000;
  ;
  margin-top: 20px;
  padding: 20px;
}

.register-right .btn-primary:hover {
  background: #000;
}

@keyframes mover {
  0% {
    transform: translateY(0);
  }

  100% {
    transform: translateY(-20px);
  }
}
</style>
</head>

<body>
  <div class="container">
    <div class="row">
      <div class="col-md-10 offset=mad-1 ">
        <div class="row">
          <div class="col-md-5 register-left">
            <img src="img/yellow.png" alt="arrow">
            <h1>Join us</h1>
            <p>Register your interest</p>
            <button type="button" class="btn btn-primary">About Us</button>
          </div>
          <div class="col-md-7 register-right">
            <h2>Register here</h2>
            <form class="" action="insert.php" method="POST">


              <div class="register-form">
                <div class="form-group">
                  <input type="text" class="form-control" name="name" required value="" placeholder="Name">
                </div>
                <div class="form-group">
                  <input type="text" class="form-control " name="name2" required value="" placeholder="Name of child">
                </div>
                <select class="form-control form-group" name="select" required id="select">
                  <option selected>Age</option>
                  <option value="3month-1year">3month-1year</option>
                  <option value="1year-2years">1year-2years</option>
                  <option value="2years-3years">2years-3years</option>
                  <option value="3years-4years">3years-4years</option>
                  <option value="4years-5years">4years-5years</option>
                  <option value="5years-6years">5years-6years</option>
                </select>
                <div class="input-group form-group date" required data-date-format="dd.mm.yyyy">
                  <input type="text" class="form-control" required placeholder="Starting date(dd.mm.yyyy)">

                </div>
                <div class="form-group">
                  <input type="Phone" class="form-control " required name="phone" value="" placeholder="Phone Number">
                </div>

                <div class="form-group">
                  <input type="email" class="form-control" required name="email" value="" placeholder="Email">
                </div>
                <div class="form-group">
                  <label for="textarea">Comments</label>
                  <textarea class="form-control" id="textarea" rows="3"></textarea>
                </div>

                <button type="submit" value="submit" class="btn btn-primary">Register<button>
              </div>
            </form>
          </div>
        </div>
      </div>
    </div>
  </div>
  </div>
  <script type="text/javascript" src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js">

  </script>
  <script type="text/javascript">
    $('.input-group.date').datepicker({
      format: "dd.mm.yyyy"
    });
  </script>
</body>

</html>