Unable to pair in Yii2 QueryBuilder

Question

I cannot bind params in Yii2 Query Builder in between state

 $query=(new Query()) ->select('*') ->from(CreditSettings::tableName()) ->where(['between','minPrice',':min',':max'])->addParams([ ':min' =>0, ':max' => 1111110 ])->createCommand()->queryAll(); 

Getting an error like:

Invalid parameter number: the number of associated variables does not match the number of tokens Executed SQL: SELECT * FROM creditSettings WHERE minPrice BETWEEN ': min' AND ': max'

Answer 1

You can use:

 $query=(new \yii\db\Query()) ->select('*') ->from(CreditSettings::tableName()) ->where(' minPrice between :min AND :max ')->addParams([ ':min' =>10007, ':max' => 10075 ])->createCommand()->queryAll(); 

Answer 2

Try it like this:

  $criteria = new CDbCriteria; $criteria->addBetweenCondition('minPrice', '0', '1111110'); $result = ModelName::model()->findAll($criteria); dump($result);