$firstname = $_POST["firstname"]; $lastname = $_POST["lastname"]; $email = $_POST["email"]; $pass = $_POST["password"];  $check_email = mysqli_query($conn, "SELECT Email FROM crud where Email = '$email' "); if(mysqli_num_rows($check_email) > 0){     echo('Email Already exists'); } else{     if ($_SERVER["REQUEST_METHOD"] == "POST") {     $result = mysqli_query($conn, "INSERT INTO crud (Firstname, Lastname, Email, Password) VALUES ('$firstname', '$lastname', '$email', '$pass')"); }     echo('Record Entered Successfully'); } 

Read more of this post