Yii 2.0 下报错:SQLSTATE[HY093]的解决!

1、$query代码实现截图:

$query代码实现截图

2、报错:SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens\nThe SQL being executed was

报错:SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens\nThe SQL being executed was

3、$query修改后实现截图,取消$query->addParams:

$query修改后实现截图,取消$query->addParams

4、$query成功实现

$query成功实现

永夜