Showing posts with label Yii CDbCriteria. Show all posts
Showing posts with label Yii CDbCriteria. Show all posts
Monday, July 16, 2012
Monday, July 9, 2012
Yii Pagination Using CDbCriteria
by Unknown
Yii Pagination Using CDbCriteria
Just we need Pagenumber and limit per page Add Validation for page number, limit
Thursday, May 17, 2012
CDbCriteria Simple
by Unknown
$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");
---
CDbCriteria Search config in model
by Unknown
searchcategory is new function instead of search