01 | $criteria = new CDbCriteria; |
02 | $criteria ->addCondition( "id=1" ); //查询条件,即where id = 1 |
03 | $criteria ->addInCondition( 'id' , array (1,2,3,4,5)); //代表where id IN (1,23,,4,5,); |
04 | $criteria ->addNotInCondition( 'id' , array (1,2,3,4,5)); //与上面正好相法,是NOT IN |
05 | $criteria ->addCondition( 'id=1' , 'OR' ); //这是OR条件,多个条件的时候,该条件是OR而非AND |
06 | $criteria ->addSearchCondition( 'name' , '分类' ); //搜索条件,其实代表了。。where name like '%分类%' |
07 | $criteria ->addBetweenCondition( 'id' , 1, 4); //between 1 and 4 |
08 |
09 | $criteria ->compare( 'id' , 1); //这个方法比较特殊,他会根据你的参数自动处理成addCondition或者addInCondition, |
10 | //即如果第二个参数是数组就会调用addInCondition |
11 | /** |
12 | * 传递变量 |
13 | */ |
14 | $criteria ->addCondition( "id = :id" ); |
15 | $criteria ->params[ ':id' ]=1; |
16 | /** |
17 | * 一些public vars |
18 | */ |
19 | $criteria ->select = 'id,parentid,name' ; //代表了要查询的字段,默认select='*'; |
20 | $criteria ->join = 'xxx' ; //连接表 |
21 | $criteria ->with = 'xxx' ; //调用relations |
22 | $criteria ->limit = 10; //取1条数据,如果小于0,则不作处理 |
23 | $criteria ->offset = 1; //两条合并起来,则表示 limit 10 offset 1,或者代表了。limit 1,10 |
24 | $criteria ->order = 'xxx DESC,XXX ASC' ; //排序条件 |
25 | $criteria ->group = 'group 条件' ; |
26 | $criteria ->having = 'having 条件 ' ; |
27 | $criteria ->distinct = FALSE; //是否唯一查询 |