php - MySQL查询插入成功但返回false

Question

问题是..我尝试从 php 解析 json..这里是 jquery 代码:

$.post( "confirmsignup.php", $("#signupform").serialize()).always(function( data ) {
    alert(data.msg);
}, "json");

PHP代码:

if (isset($_POST['gender'])&&isset($_POST['fname'])&&isset($_POST['sname'])&&isset($_POST['username'])&&isset($_POST['dob'])) {
    $gender=secureing($_POST['gender']);
    $fname=secureing($_POST['fname']);
    $sname=secureing($_POST['sname']);
    $username=secureing($_POST['username']);
    $email=secureing($_POST['email']);
    $dob=secureing($_POST['dob']);
    if (isset($_POST['agree'])&&isset($_POST['pass'])&&isset($_POST['repass'])) {
        $pass=secureing($_POST['pass']);
        if ($_POST['pass']==secureing($_POST['repass'])) {
            $query = "INSERT INTO users VALUES('$username', '$gender', '$fname', '$sname', '$email', '".md5($pass)."', '$dob')";
            if(!($query_run = mysql_query($query))){
                $msg = "error";
            }else{
                $msg = "complete";
            }
        }
    }
}
header('Content-Type: application/json');
?>
{
"msg": "<?php echo $msg ." - ". $query; ?>"
}

secureing() 用于在 escape_string.. 之后返回字符串。$msg 假设返回字符串“complete”...但它返回“error”..然而在 phpmyadmin 中，查询被成功执行..

我认为没有错误..我的错误是什么？请帮助..

Answer 1

你能不能把下面的代码改成你的代码，我用mysql_insert_id来检查记录是否插入了。

$query = "INSERT INTO users VALUES('$username', '$gender', '$fname', '$sname', '$email', '".md5($pass)."', '$dob')";
$query_run = mysql_query($query);
$id        = mysql_insert_id();
if($id > 0)
{
    $msg = "complete";
}
else
{
    $msg = "error";
}

它可能对你有帮助。