<div id="id01" class="modal">
<span onclick="document.getElementById('id01').style.display='none'" class="close" title="Close Modal">&times;</span>
<form class="modal-content" method="post" action="insert.php">
<div class="container">
      <h1><i class="fa fa-fw fa-globe"></i>Satebo</h1>
      <p>Welcome to Satebo!</p>
      <hr>
      <label for="fullname"><b>Full Name</b></label>
      <input type="text" placeholder="Enter Full Name" name="fullname" required>
      <label for="name"><b>Username</b></label>
      <input type="text" placeholder="Enter Username" name="username" required>
      <label for="email"><b>Email</b></label>
      <input type="text" placeholder="Enter Email" name="email" required>
      <label for="psw"><b>Password</b></label>
      <input type="password" placeholder="Enter Password" name="psw" required>
      <label for="pswrepeat"><b>Repeat Password</b></label>
      <input type="password" placeholder="Repeat Password" name="pswrepeat" required>
      <label for="contactnumber"><b>Contact Number</b></label>
      <input type="text" placeholder="(XXX)XXX-XXXX" name="contactnumber" required>

      <label>
        <input type="checkbox" checked="checked" name="remember" style="margin-bottom:15px"> Remember me
      </label>

                <div class="clearfix">
                    <button type="submit" class="signupbtn">Sign Up</button>
                    <button type="button" onclick="document.getElementById('id01').style.display='none'" class="cancelbtn">Cancel</button>

                </div>
            </div>
        </form>
    </div>

<?php

$fullname = $_POST['fullname'];
$username = $_POST['username'];
$email = $_POST['email'];
$psw = $_POST['psw'];
$pswrepeat = $_POST['pswrepeat'];
$contactnumber = $_POST['contactnumber'];

if(!empty($fullname) || !empty($username) ||
!empty($email) || !empty($psw) || !empty($pswrepeat) ||
!empty($contactnumber)) {
    $host = "localhost";
    $dbUsername = "root";
    $dbPassword = "";
    $dbname = "satebo registration";

    //create connection
    $conn = new mysqli($host, $dbUsername, $dbname);

    if(mysqli_connect_error()){
        die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error())
    }
    else {
        $SELECT = "SELECT email From registration Where email = ? Limit 1";
        $INSERT = "INSERT Into registration (fullname, username, email,
        psw, pswrepeat, contactnumber) values(?, ?, ?, ?, ?, ?)";

        //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 = $conn->prepare($INSERT);
            $stmt->bind_param("ssssii", $fullname, $username, $email, $psw, $pswrepeat, $contactnumber);
            $stmt->execute();
            echo "New record inserted sucessfully";
        }
            else{
            echo "Someone already register using this email";
                        }
        $stmt->close();
        $conn->close();
                        }
}

else {
    echo "All fields are required";
    die();
}



?>