如何在Yii 2中使用id以外的字段查找记录

Question

I have the following code where I want to find a model using a field called link instead of id. However, it doesn't seem to produce any results. Where could I be getting it wrong? It returns 404

public function actionView($link)
    {
        $model = News::find()->where(['link'=>$link])->all();
        return $this->render('view', [
            'model' => $model,
        ]);
    }

NB: in the search model, I have tried adding this:

 $query->andFilterWhere([
            'id' => $this->id,
            'link'=>$this->link,
            'category' => $this->category,
            'date' => $this->date,
            'userid' => $this->userid,
            'featured' => $this->featured,
        ]);

Answer 1

For anyone who may encounter such an error, the problem is after using pretty urls, you need to add rules to map the url format. C:\xampp\htdocs\your_project\frontend\config\main.php under urlManager add the rules like so:

'urlManager' => [
        'class' => 'yii\web\UrlManager',
        // Disable index.php
        'showScriptName' => false,
        // Disable r= routes
        'enablePrettyUrl' => true,
        'rules' => array(
                '<controller:\w+>/<id:\d+>' => 'news/view',
             '<controller:\w+>/<link>' => 'news/latestnews', // This is required for $link parameter
                '<controller:\w+>/<action:\w+>/<id:\d+>' => '<controller>/<action>',
            '<controller:\w+>/<action:\w+>/<link>' => 'news/latestnews',
                '<controller:\w+>/<action:\w+>' => '<controller>/<action>',
        ),
        ],
    ],