ajax总是显示电子邮件已经电子邮件已经存在于该函数中


ajax always showing email already Email already exist in this function

我正在通过ajax和php验证用户电子邮件,但这里ajax总是显示电子邮件已经退出;

AJAX/Javascript代码:

$.ajax({
    type: "POST",
    url: "classes/aeAjaxFunction.php",
    data: "do=sem&ci=" + ci11,
    success: function(msg) {
        if(msg ="yes") {
            alert('Email already exist');
        }
        else {
        // alert("Occured internal Error. please check network connection");
        }
        // $('#psid').html("<img src='images/spacer.gif'>");
        //$('#email1').html(msg);
        //
        //$('#sid').sSelect({ddMaxHeight: '300px'});
    },
    error: function() {
        // alert('some error has occured...');
    },
    start: function() {
        // alert('ajax has been started...');   
    }
});

PHP代码:

<?php
function checkSpEmail($postAr) {
    $mysqli = dbconn::get_mysqli();
    $email = $postAr['ci'];
    $selEmail = "SELECT fld_email FROM tbl_spouse WHERE fld_email = '$email' ";
    $res = mysqli_query($mysqli, $selEmail);
    $count = mysqli_num_rows($res);
    if (mysqli_num_rows($res) == 1) {
        echo 'yes';
        exit;
    }
}
?>

更改ajax代码,您使用的是msg = "yes",必须使用msg == "yes"

$.ajax({
    type: "POST",
    cache: false, 
    url: "classes/aeAjaxFunction.php",
    data: "do=sem&ci=" + ci11,
    success: function(msg) {
        if(msg == "yes") {
            alert('Email already exist');
        }
        else {
        // alert("Occured internal Error. please check network connection");
        }
        // $('#psid').html("<img src='images/spacer.gif'>");
        //$('#email1').html(msg);
        //
        //$('#sid').sSelect({ddMaxHeight: '300px'});
    },
    error: function() {
        // alert('some error has occured...');
    },
    start: function() {
        // alert('ajax has been started...');   
    }
});

更改

if(msg ="yes") 

if(msg =="yes")