How to organize range search in yii2?

Question

Yii

Hello. There is yii2, there is a table column "price". Tell me how to organize a search by price range, for example: search from 100 to 200? Maybe there is a module, or is there an article on the implementation of this? I searched but didn't find anything useful. I would appreciate any information on this matter.

Answer 1

MyModel::find()->where(['between', 'price', 100, 200]);

Answer 2

Maxim Fedorov gave a working example, I'll add it as an option:

$small = 100;
$big = 200;
MyModel::find()
->andWhere(['>','attribute', $small])
->andWhere(['<','attribute', $big])
->all();