Tips for implementing the Yii framework: the main operations involved in SQL statements are addition, deletion, modification, and query. we can define the scopes method in models to define the most basic data operation method: News. in the php model, [php] public function scopes () {return array (// obtain the common news method 'referend' => array ('condition' => "isrecommend = ". self: RECOMMEND,), 'getnew' => array ('select' => array ('id', 'title', 'coverimg '), 'order' => 'dateline desc',),);} After definition, if you want to use the method in it, you only need to use: [php] $ recommend_news = News :: model ()-> getNews ()-> recommend ()-> findAll (Array ('select' => array ('content'), 'condition' => "coverimg <>'' and coverimg is not null and type = ". news: TYPE_YLZX, 'limit '=> '4',); call. Concerning data update: [php] // Number of update clicks News: model ()-> updateCounters (array ('clicks' => 1), "id = ". $ id );