经过长时间的研究,我找不到PDOException SQLSTATE的确切解决方案[HY093]我正在使用 yii 2 框架工作,在条件之间使用时遇到问题。
$query = SalesOrder::find()->where(['between','created_date', ':fromDate', ':toDate']);
$query->addParams([':fromDate' => $salesReport->fromDate,':toDate' => $salesReport->toDate]);
$query->all();
尝试了不同的相同问题。
$qString1=':fromDate';
$qString2=':toDate';
$query = SalesOrder::find()->where(['between','created_date',$qString1,$qString2]);
$query->addParams([':fromDate' => $salesReport->fromDate],[':toDate' => $salesReport->toDate]);
$query->all();
由:PDOException引起SQLSTATE[HY093]:参数编号无效:绑定变量数与标记数不匹配
在这种情况下,
不能传递参数名称。 尝试 :
$query = SalesOrder::find()->where(['between','created_date', $salesReport->fromDate, $salesReport->toDate]);
$query->all();
或者,如果您想使用参数,请尝试:
$query = SalesOrder::find()->where('created_date BETWEEN :fromDate AND :toDate');
$query->addParams([':fromDate' => $salesReport->fromDate],[':toDate' => $salesReport->toDate]);
$query->all();