$criteria=new CDbCriteria; $criteria->select = "priority"; $criteria->order = "priority desc"; return new CActiveDataProvider($model, array( 'criteria'=>$criteria, )); ----- $criteria=new CDbCriteria; $criteria->compare('year(`EventStartdate`)','>=:'.$currentYear); $criteria->compare('year(`EventStartdate`)','>='.$currentYear); ----- $criteria = new CDbCriteria; $criteria->condition = 'foo = 1 OR bar = 2'; $models = TableName::model()->findAll($criteria); ----- $criteria=new CDbCriteria; /** together **/ $criteria->together=true; /** with **/ $criteria->with=array('tbl_user'); /** inner join **/ $criteria->join="INNER JOIN tbl_user as user ON(user.userid=t.user_id)"; /** compare **/ $criteria->compare('t.isactive',$this->isactive,true); /** addCondition **/ $criteria->addCondition('isactive=1','AND'); /** addInCondition : pass array**/ $criteria->addInCondition('categoryid',$this->categoryid,true); /** addBetweenCondition **/ $criteria->addBetweenCondition("t.createdon",$this->date_after,$this->date_before,"AND"); $criteria->addCondition("$condition"); ---
Thursday, May 17, 2012
CDbCriteria Simple
by Unknown
0 comments:
Post a Comment