php - 一个我没有得到的错误，MYSQL PDO PHP

Question

尝试运行这个插入查询

$query = $pdo->prepare("INSERT INTO `contacts` (`id`, `firstname`, `lastname`, `phonenumber`, `rank`, `time`) VALUES (NULL, :firstname, :lastname, :authcode, '1', NOW()");
$query->execute(array(":firstname" => $firstname, ":lastname" => $lastname, ":phone" => $phone));
$message[1] = '<font color=lime>Successfully added!</font>';

我收到这个错误:

Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 in /public_html/contacts/add.php on line 61

这个 ($query->execute(array...) 是第 61 行

Answer 1

您的查询不正确，这就是您收到语法错误的原因。您错过了结尾 )。

INSERT INTO contacts (
   id,
   firstname,
   lastname,
   phonenumber,
   rank,
   time
) VALUES (
   NULL,
   :firstname,
   :lastname,
   :phone,
   '1',
   NOW()
)

格式化查询后更容易发现此类错误。