答案：Yii2中實(shí)現(xiàn)搜索和過濾需創(chuàng)建搜索模型、使用ActiveDataProvider與GridView。首先為Product創(chuàng)建ProductSearch類，定義規(guī)則並實(shí)現(xiàn)search方法，通過load和validate處理參數(shù)，用andFilterWhere添加條件；控制器中實(shí)例化搜索模型並傳入請求參數(shù)；視圖中結(jié)合ActiveForm構(gòu)建搜索表單，GridView展示數(shù)據(jù)並設(shè)置filterModel；支持日期範(fàn)圍、關(guān)聯(lián)查詢等高級功能，確保數(shù)據(jù)庫索引優(yōu)化性能。

To implement search and filtering in Yii (specifically Yii2), you typically use the Search Model pattern with ActiveDataProvider and GridView (for web interface). This approach is commonly used in CRUD operations. Below are the key steps and best practices.

Create a Search Model

Example: models/ProductSearch.php

 class ProductSearch extends Product
{
    public function rules()
    {
        return [
            [['id', 'status'], 'integer'],
            [['name', 'sku'], 'safe'],
        ];
    }

    public function search($params)
    {
        $query = Product::find();

        // Add conditions here based on filters
        $dataProvider = new ActiveDataProvider([
            'query' => $query,
            'pagination' => ['pageSize' => 10],
        ]);

        // Load parameters and validate
        if (!($this->load($params) && $this->validate())) {
            return $dataProvider;
        }

        // Apply filter conditions
        $query->andFilterWhere([
            'id' => $this->id,
            'status' => $this->status,
        ]);

        $query->andFilterWhere(['like', 'name', $this->name])
              ->andFilterWhere(['like', 'sku', $this->sku]);

        return $dataProvider;
    }
}

Use the Search Model in Controller

Example: controllers/ProductController.php

 public function actionIndex()
{
    $searchModel = new ProductSearch();
    $dataProvider = $searchModel->search(Yii::$app->request->queryParams);

    return $this->render('index', [
        'searchModel' => $searchModel,
        'dataProvider' => $dataProvider,
    ]);
}

Display in View with GridView

Example: views/product/index.php

 <?= Html::beginForm([&#39;product/index&#39;], &#39;get&#39;) ?>
    <?= Html::input(&#39;text&#39;, &#39;ProductSearch[name]&#39;, Yii::$app->request->get(&#39;ProductSearch&#39;)[&#39;name&#39;] ?? &#39;&#39;, [&#39;placeholder&#39; => &#39;Search by name&#39;]) ?>
    <?= Html::dropDownList(&#39;ProductSearch[status]&#39;, Yii::$app->request->get(&#39;ProductSearch&#39;)[&#39;status&#39;] ?? &#39;&#39;, [&#39;1&#39; => &#39;Active&#39;, &#39;0&#39; => &#39;Inactive&#39;], [&#39;prompt&#39; => &#39;All Statuses&#39;]) ?>
    <?= Html::submitButton(&#39;Filter&#39;, [&#39;class&#39; => &#39;btn btn-primary&#39;]) ?>
<?= Html::endForm() ?>

<?= GridView::widget([
    &#39;dataProvider&#39; => $dataProvider,
    &#39;filterModel&#39; => $searchModel,
    &#39;columns&#39; => [
        &#39;id&#39;,
        &#39;name&#39;,
        &#39;sku&#39;,
        [
            &#39;attribute&#39; => &#39;status&#39;,
            &#39;value&#39; => function ($model) {
                return $model->status ? &#39;Active&#39; : &#39;Inactive&#39;;
            },
            &#39;filter&#39; => [&#39;1&#39; => &#39;Active&#39;, &#39;0&#39; => &#39;Inactive&#39;],
        ],
    ],
]) ?>

Advanced Filtering Tips

• Date Range: Use two fields ( date_from , date_to ) in the search model and apply BETWEEN in query.
• Relation-based Filters: Join related tables (eg, category name) and filter accordingly using innerJoinWith .
• Custom Attributes: Add virtual attributes in the search model for complex conditions.
• Performance: Ensure proper database indexing on filtered columns.

Basically, Yii2's built-in components make search and filtering clean and scalable. Just follow the pattern: search model data provider GridView/form handling.

以上是如何在YII中實(shí)施搜索和過濾？的詳細(xì)內(nèi)容。更多資訊請關(guān)注PHP中文網(wǎng)其他相關(guān)文章！