php - yii 插入语句错误 SQLSTATE[HY093] : Invalid parameter number: parameter was not defined

Question

在 Yii 中向表中插入数据时，出现此错误:

CDbCommand failed to execute the SQL statement:
SQLSTATE[HY093]: Invalid parameter number: parameter was not defined.
The SQL statement executed was: insert into user_feedback (name,
desc,email,mobilenumber) values (:Name, :Desc,:email,:Mobilenmber).

下面是我的代码:

$sql = "insert into user_feedback (name, desc,email,mobilenumber) values (:Name, :Desc,:email,:Mobilenmber)";
      $parameters = array(":name"=>$_POST['Name'], ':desc' => $_POST['Desc'],':email'=>$_POST['email'],':mobile_number'=>$_POST['Mobile_nmber']);
      Yii::app()->db->createCommand($sql)->execute($parameters);

Answer 1

您的请求有 2 个错误。正如亚历山大所说，您的参数不匹配(所有期望电子邮件)。而且有打字错误。

这个请求/参数应该有效:

$sql = "insert into user_feedback (name, desc,email,mobilenumber) values (:name, :desc,:email,:mobile_number)";
      $parameters = array(":name"=>$_POST['Name'], ':desc' => $_POST['Desc'],':email'=>$_POST['email'],':mobile_number'=>$_POST['Mobile_number']);