Yii中CDbCriteria的使用
$criteria = new CDbCriteria();的使用 $criteria -> addCondition("id=1"); //查询条件,where id=1 $criteria -> addCondition("id=1",'OR|AND'); $criteria -> addInCondition('id',array(1,2,3,4,5)); //代表where id IN(1,2,3,4,5); $criteria -> addNotInCondition('id',array(1,2,3,4,5)); //代表where id IN(1,2,3,4,5); $criteria -> addCondition('id=1','OR'); //这是OR条件,多个条件的时候,该条件是OR而非AND $criteria -> addSearchCondition('name','分类'); //搜索条件,其实代表了,,, where name like '%分类%'; $criteria -> addBetweenCondition('id',1,4); //between 1 and 4 $criteria -> compare('id',1); //这个方法比较特殊,他会根据你的参数自动处理成addCondition或者addInCondition,如果第二个参数是数组时就会调用 addInCondition $criteria -> addCondition("id=:id"); $criteria -> params[':id'] = 1; $criteria -> select = 'id,parentid,name'; //代表了要查询的字段,默认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 = 'xxx desc,xxx asc'; //排序条件 $criteria -> group = 'group 条件'; // $criteria -> having = 'having 条件'; $criteria -> distinct = false; //是否唯一查询