<script>

              $("#kys_SignUp_form").submit(function(event){
                  event.preventDefault();

                  var $form = $(this);
                  var $url = $form.attr('action');
                  var $email = $("#email").val();
                  var $username = $("#username").val();
                  var $password = $("#password").val();


                     $.ajax({
                          type: 'POST',
                          url: $url,
                          data: { email: $email, password: $password, username: $username },

                         success: function(data) {
                                   alert("Transaction Completed!");

                                 }

                     });

              });

       </script>

<form role="form" action="kys_SignUp.php" method="post" id="kys_SignUp_form">
                <div class="form-group">
                                         <label for="email" >Email address:</label>
                                         <input type="email" style="width: 300px" class="form-control"  name="email" id="email" required>
                    </div>

             <div class="form-group">
                                         <label for="Username" >Username:</label>
                                         <input type="text" style="width: 300px" class="form-control" name="username" id="Username" required>
                    </div>

                <div class="form-group">
                                         <label for="password" >Password:</label>
                                         <input type="password" style="width: 300px" class="form-control" id="password" name="password" required>
                    </div>

                   <button type="submit"  class="btn btn-default">Submit</button>

            </form>

<?php

 include "kys_DbConnect.php";

$email = $username = $password = "";

if($_SERVER["REQUEST_METHOD"] == "POST"){

    $email = cleanData($_POST["email"]);
    $username = cleanData($_POST["username"]);
    $password = cleanData($_POST["password"]);


}



    $stmt = $con->prepare("SELECT * FROM kys_users WHERE username=? OR email=?");
    $stmt->bind_param("ss",$username,$email);
    $stmt->execute();
    $stmt->bind_result($kys_id,$kys_email,$kys_username,$kys_password);
     $stmt->fetch();

    if(isset($kys_username)){



        echo "Username or Email already exists";

    }
   else{

        $insert = $con->prepare("INSERT INTO kys_users (username, email, password) VALUES (?, ?, ?)");
        $insert->bind_param("sss",$username,$email,$password);
        $insert->execute();
         header("Location: http://localhost/KeyStroke/index.html");
        exit();

   }



function cleanData($data){

    $data = stripslashes($data);
  $data = htmlspecialchars($data);
    return $data;

}





?>