About the usage of Yii’s CDbCriteria query conditions

This article mainly introduces the usage of CDbCriteria query conditions in Yii. The examples summarize the common usage of CDbCriteria query conditions. It has certain reference value for using Yii for database programming. Friends in need can refer to it

The examples in this article summarize some usage of Yii’s CDbCriteria query conditions and share them with you for your reference. The specific analysis is as follows:

Here are the various conditions for querying using the CDbCriteria method in Yii:

The code is as follows:

$criteria = new CDbCriteria;
$criteria->addCondition("MACID=464"); //查询条件，即where id = 1 
$criteria->addInCondition('id', array(1,2,3,4,5)); //代表where id IN (1,23,,4,5,); 
$criteria->addNotInCondition('id', array(1,2,3,4,5));//与上面正好相法，是NOT IN 
$criteria->addCondition('id=1','OR');//这是OR条件，多个条件的时候，该条件是OR而非AND 
$criteria->addSearchCondition('link', '裸体');//搜索条件where name like '%分类%' 
$criteria->addBetweenCondition('id', 10000, 10005);//between 10000 and 10005
$criteria->compare('id', 1);  //这个方法比较特殊，他会根据你的参数
//自动处理成addCondition或者addInCondition，
//即如果第二个参数是数组就会调用addInCondition  
/**
* 传递变量
*/  
$criteria->addCondition("id = :id");  
$criteria->params[':id']=10;  
/**
* 一些public vars
*/  
$criteria->select = 'id,MACID,type'; //代表了要查询的字段，默认select='*'; 
$criteria->join = 'xxx'; //连接表 
$criteria->with = 'xxx'; //调用relations 
$criteria->limit = 10;    //取1条数据，如果小于0，则不作处理 
$criteria->offset = 1;   //两条合并起来，则表示 limit 10 offset 1,或者代表了。limit 1,10 
$criteria->order = 'id DESC,MACID ASC' ;//排序条件 
$criteria->group = 'group type'; 
$criteria->having = 'having 条件 '; 
$criteria->distinct = FALSE; //是否唯一查询  
return new CActiveDataProvider('visitlog', array(
  'criteria'=>$criteria,
));

The above is the entire content of this article , I hope it will be helpful to everyone’s learning. For more related content, please pay attention to the PHP Chinese website!

Related recommendations:

About how to extend YII view integration kindeditor

About using join and joinwith in Yii2 Multi-table association query

Yii2 framework implements common database operation analysis

The above is the detailed content of About the usage of Yii’s CDbCriteria query conditions. For more information, please follow other related articles on the PHP Chinese website!