Yii model operation criteria search database method

The example of this article describes the method of searching the database using criteria for Yii model operation. Share it with everyone for your reference, the details are as follows:

Data model search method:

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

Definition of comparison operation:

$criteria->compare(&#39;create_time&#39;,&#39;<=&#39;.$this->endtime),
//创建早间小于等于指定时间

Define the field to be searched:

//查找的结果
$criteria->select = 'id,title,content,author,status,createtime',
//也可以以下一种方式定义
$criteria->select = array('id','title','content','author','status','createtime'),

Define the search conditions:

//定义条件
$criteria->select = 'status=1',
//添加匹配
$criteria->compare('title',$this->title,true),
//添加条件 $condition可以是数组，也可以是字符串，and可以省略
$criteria->addCondition($condition,'and'),
//添加IN条件 $column为字段名
$criteria->addInCondition(string $column, array $values, string $operator='AND')
//添加notin条件
$criteria->addNotInCondition(string $column, array $values, string $operator='AND')
//添加like条件
$criteria->addSearchCondition(string $column, string $keyword),
//添加Between条件
$criteria->addBetweenCondition(string $column, string $valueStart, string $valueEnd, string $operator='AND')，

JOIN connection table query

$criteria->join = 'LEFT JOIN users ON users.id=authorID',

##order query result sorting:

$criteria->order = 'createtime DESC',

group result grouping:

$criteria->group = 'projectID, teamID',

##having filter grouping result group number:

$criteria->having = &#39;SUM(revenue)<50000&#39;,

I hope this article will be helpful to everyone’s PHP program design based on the Yii framework.

For more articles related to Yii model operation criteria and how to find the database, please pay attention to the PHP Chinese website!