PDO错误:“参数编号无效:参数未定义. [英] PDO Error: " Invalid parameter number: parameter was not defined"

问题描述

我正在尝试使用简单的MySQL插入查询以及数组形式的参数.它不断告诉我参数数量错误.我尝试了以下方法，均产生相同的错误:

I am trying to use a simple MySQL insert query with the parameters in array form. It keeps telling me the number of parameters are wrong. I have tried the following, all producing the same error:

$stmt3 = $link->prepare('INSERT INTO messages VALUES(null, :room, :name, :message, :time, :color)');
$stmt3->execute(array(':room' => $Clean['room'],':name' => $Clean['name'],':message' => $Clean['message'],':time' => $time,':color:' => $Clean['color']));

和

$stmt3 = $link->prepare('INSERT INTO messages VALUES(:null, :room, :name, :message, :time, :color)');
$stmt3->execute(array(':null' => null, ':room' => $Clean['room'],':name' => $Clean['name'],':message' => $Clean['message'],':time' => $time,':color:' => $Clean['color']));

以及专门声明各列以避免空插入:

as well as declaring the columns specifically to avoid the null insert:

$stmt3 = $link->prepare('INSERT INTO messages (room, name, message, time, color) VALUES(:room, :name, :message, :time, :color)');
$stmt3->execute(array(':room' => $Clean['room'],':name' => $Clean['name'],':message' => $Clean['message'],':time' => $time,':color:' => $Clean['color']));

这是我第一次使用PDO(我通常使用mysqli，但是我当前的共享主机没有mysqlnd插件，这使我无法使用prepare()，因此，从该角度出发的任何见解都值得赞赏.

This is my first time using PDO (I normally use mysqli, but my current shared host does not have the mysqlnd plugin, preventing me from using prepare(), so any insight from that point of view is appreciated.

推荐答案

问题-您会踢自己-是:color.

The problem - and you will kick yourself - is with :color.

调用execute()时要为该标记传递的值的数组键名为:color:.删除尾随的:(我想无论如何这都是一个错字).

The array key for the value you are passing for that marker when calling execute() is named :color:. Remove the trailing : (I'm guessing this was just a typo anyway).

$stmt3->execute(array(
    ':room' => $Clean['room'],
    ':name' => $Clean['name'],
    ':message' => $Clean['message'],
    ':time' => $time,
    ':color' => $Clean['color'],
    ));

这篇关于PDO错误:“参数编号无效:参数未定义.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！