dongzhan5286
2016-12-06 06:01
浏览 21
已采纳

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

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,
        ]);

图片转代码服务由CSDN问答提供 功能建议

我有以下代码,我想使用名为link而不是id的字段查找模型。 但是,它似乎没有产生任何结果。 我哪里可以弄错? 它返回404

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

注意:在搜索模型中,我尝试添加此项:

  $ query-> andFilterWhere([
'  id'=> $ this-> id,
'link'=> $ this-> link,
'category'=> $ this-> category,
'date'=>  $ this-> date,
'userid'=> $ this-> userid,
'features'=> $ this-> featured,
]); 
   
 
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

5条回答 默认 最新

  • duangekui7451 2016-12-08 06:35
    最佳回答

    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>',
            ),
            ],
        ],
    
    评论
    解决 无用
    打赏 举报
查看更多回答(4条)

相关推荐 更多相似问题