How to set a condition from and to in Yii2?

Question

Yii

There is a price field,
there are two fields in the search, price from and to, how do I set a condition to select records in a given interval?

Answer 1

$prosucts = Product::find()->andWhere(['>','price',15])->andWhere(['<','price',100])->all();

But when it comes to search, it's probably more convenient to use ActiveDataProvider and SearchModel, then it's almost the same:

$query->andFilterWhere(['>','price',$this->min])->andFilterWhere(['<','price',$this->max]);