php - 无法将用户添加到数据库，不匹配错误？ '{"错误信息": ["HY093", 0]}'

Question

我不明白为什么这仍然给我一个 PDO 错误。我对 php 比较陌生，所以任何帮助都会很好。

    $query = "INSERT INTO users (userID, email, password, fName, lName, dob,
 online, verified, lastLogedIn, gender) VALUES (:id ,:email, :pass, :fn, :ln,
 dob, :online, :verified, :lli, :gender )";

$queryParams = array(
    ':id' => 0,
    ':email' => $_POST['email'],
    ':pass' => $_POST['password'],
    ':fn' => $_POST['firstName'],
    ':ln' => $_POST[':lastName'],
    ':dob' => $_POST[':dob'],
    ':online' => $online,
    ':verified' => $verified,
    ':lli' => $lli,
    ':gender' => $gender
);

try{

    $stmt = $db->prepare($query);
    $result = $stmt->execute($queryParams);
    var_dump($result->errorCode());

}catch(PDOException $ex){
    $response["success"] = 0;
    $response["message"] = "Database Error. failed to add user to database";
    echo '<pre>';
    print_r($result);
    echo '</pre>';
    die(json_encode($ex));
}

我的代码不断弹出这个错误，我知道这意味着查询和数据库不匹配，但我不知道在哪里。

Answer 1

你在 dob 中省略了 :，改为:

$query = "INSERT INTO users (userID, email, password, fName, lName, dob, online, verified, lastLogedIn, gender) VALUES (:id ,:email, :pass, :fn, :ln, :dob, :online, :verified, :lli, :gender )";