php - SQLSTATE[HY000] : General error in Yii2 , 创建命令

Question

我使用 Yii2。

在此查询中我有错误:

Yii::$app->db->createCommand("UPDATE post SET text2 = :text2 WHERE id=4",
    [':text2' => htmlspecialchars_decode(':text2')])->queryAll();

SQLSTATE[HY000]: General error

The SQL being executed was: UPDATE post SET text2 = text2 WHERE id=4

Answer 1

使用这个查询它会正常工作

$text2 = htmlspecialchars_decode(YOUR TEXT2 value)

Yii::$app->db->createCommand("UPDATE post SET text2 = '$text2' WHERE id=:id")->bindValues(array(':id' => 4))->execute();