php - 使用命名参数在我的 SQL 中找不到错误

Question

这个问题已经有答案了:

Can PHP PDO Statements accept the table or column name as parameter? (9 个回答)

已关闭 8 年前。

在 PHP 中，我正在构建(至少尝试构建)一个使用命名参数的查询，如下所示...

$answerNumber = "a1";
$questionNumber = "q2";
$answerText = "Test Answer";

//INSERT QUERY
$sql = "INSERT INTO $questionNumber (:answerNumber) VALUES (:answerText)";
$stmt = $db->prepare($sql);
$stmt->bindValue(':answerNumber', $answerNumber);
$stmt->bindValue(':answerText', $answerText);
$stmt->execute();

$errorInfo = $stmt->errorInfo();

if(isset($errorInfo[2])){
    $error =    $errorInfo[2];
    echo $error;
} else {
    echo "No errors.";
};

但我不断收到错误。返回错误...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''a1') VALUES ('Test Answer')' at line 1

Answer 1

删除:

INSERT INTO $questionNumber (:answerNumber) VALUES (:answerText) 
             here------------^

使用列名而不是参数内容。您的列名称是 answerNumber，对吧？因为首先您必须命名要插入的列。然后按该顺序列出值。示例:

insert into users (id, name) values (1, 'John')

在 PDO 中

insert into users (id, name) values (:id, :name)