没有不值得去解决的问题,也没有不值得去学习的技术!

Fixing the SQLSTATE[HY093] Error in Yii 2.0

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

1. Screenshot of the $query code implementation:

Screenshot of the $query code implementation
Screenshot of the $query code implementation

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

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

3. Screenshot of the modified $query implementation, removing $query->addParams:

Screenshot of the modified $query implementation, removing $query->addParams
Screenshot of the modified $query implementation, removing $query->addParams

4. $query successfully implemented

$query successfully implemented
$query successfully implemented

关于作者 · 持续学习与技术实践

我是一名拥有 15 年以上开发经验的技术从业者,自 2013 年起持续运营个人技术博客,记录工作与个人项目中遇到的真实问题,以及解决问题过程中的探索、实践和思考。

除了技术写作,我也在持续开发和维护自己的独立项目,探索新技术和新工具在实际场景中的应用。我始终相信,没有不值得去解决的问题,也没有不值得去学习的技术。

如果这篇文章对你有所帮助,欢迎浏览博客中的其他文章,也欢迎交流技术经验与想法。

关于我  ·  GitHub  ·  邮件联系