@H_404_0@本文实例讲述了Yii模型操作之criteria查找数据库的方法。分享给大家供大家参考,具体如下:
@H_404_0@数据模型搜索方法:
<div class="jb51code">
<pre class="brush:php;">
public function search()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$criteria=new CDbCriteria;
$criteria->compare('id',$this->id);
$criteria->compare('title',$this->title,true); //支持模糊查找
$criteria->compare('content',$this->content,true); //支持模糊查找
$criteria->compare('type',$this->type);
$criteria->compare('user',$this->user,true); //支持模糊查找
$criteria->compare('status',$this->status);
$criteria->compare('create_data',$this->create_data,true); //支持模糊查找
return new CActiveDataProvider($this,array(
'criteria'=>$criteria,'pagination'=>array(
'pageSize'=>50,),));
}