jQuery AJAX检查数据库中是否存在因某些原因而无法正常工作的电子邮件

Question

I am trying to use jQuery, AJAX, PHP, and MySQL to check if an email entered into a form already exists in a database. This is my current jQuery code :

$.post('check-email.php', {'suEmail' : $suEmail}, function(data) {
  if(data=='exists') {
    validForm = false;
    $suRememberMeCheckbox.css('top', '70px');
    $suRememberMeText.css('top', '68px');
    $signUpSubmit.css('top', '102px');
    $tosppText.css('top', '115px');
    $suBox.css('height', '405px');
    $suBox.css('top', '36%');
    $errorText.text('The email has been taken.');
    return false;
  };
});

And this is my PHP code:

<?php include("dbconnect.php") ?>
  <?php
    $sql = "SELECT email FROM users WHERE email = '" .$_POST['suEmail'] . "'";
    $select = mysqli_query($connection, $sql);

    if (mysqli_num_rows($select) > 0) {
      echo "exists";
    }
?>

When I go through with the sign up form, when I use an email already in the database, the error text never changes to what I specified, but instead to some other error cases I have coded. Why is this not working! Thanks so much!

Answer 1

You may have extra whitespace in response

Try:

if(data.trim()=='exists') {