How to check user already exists in PHP?
$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'); }