addInCondition('id', array(1,2,3,4,5)); //代表where id IN (1,2,3,4,..." />
首页 > 活着 > Yii CDbCriteria常用用法

Yii CDbCriteria常用用法

Java代码
1.$criteria = new CDbCriteria;
2.$criteria->compare(‘name’,$this->name,true,’OR’); //like部分匹配
3.//$criteria->addCondition(“id=1″); //查询条件,即where id = 1
4.//$criteria->addInCondition(‘id’, array(1,2,3,4,5)); //代表where id IN (1,2,3,4,5);
5.$criteria->compare(‘name’, array(1,2,3,4,5));
6.$criteria->addNotInCondition(‘id’, array(1,2,3,4,5));//与上面正好相法,是NOT IN
7.//$criteria->addCondition(‘id=1′,’OR’);//这是OR条件,多个条件的时候,该条件是OR而非AND
8.//$criteria->addSearchCondition(‘name’, ‘分类’);//搜索条件,其实代表了。where name like ‘%分类%’
9.$criteria->compare(“id”,”<>1″); //not like
10.$criteria->addBetweenCondition(‘id’, 1, 4);//between 1 and 4
11.$criteria->compare(‘id’, 1); //这个方法比较特殊,他会根据你的参数自动处理成addCondition或者addInCondition,
12.$criteria->compare(“id”,”<1"); //这个方法他会根据你提供的条件进行判断
13.//即如果第二个参数是数组就会调用addInCondition
$criteria = new CDbCriteria;
$criteria->compare(‘name’,$this->name,true,’OR’); //like部分匹配
//$criteria->addCondition(“id=1″); //查询条件,即where id = 1
//$criteria->addInCondition(‘id’, array(1,2,3,4,5)); //代表where id IN (1,2,3,4,5);
$criteria->compare(‘name’, array(1,2,3,4,5));
$criteria->addNotInCondition(‘id’, array(1,2,3,4,5));//与上面正好相法,是NOT IN
//$criteria->addCondition(‘id=1′,’OR’);//这是OR条件,多个条件的时候,该条件是OR而非AND
//$criteria->addSearchCondition(‘name’, ‘分类’);//搜索条件,其实代表了。where name like ‘%分类%’
$criteria->compare(“id”,”<>1″); //not like
$criteria->addBetweenCondition(‘id’, 1, 4);//between 1 and 4
$criteria->compare(‘id’, 1); //这个方法比较特殊,他会根据你的参数自动处理成addCondition或者addInCondition,
$criteria->compare(“id”,”<1"); //这个方法他会根据你提供的条件进行判断
//即如果第二个参数是数组就会调用addInCondition
CommandBuilder
Java代码
1.$schema=Yii::app()->db->schema;
2.$builder=$schema->commandBuilder;
3.$command=$builder->createFindCommand($schema->getTable($tableName), $criteria);
$schema=Yii::app()->db->schema;
$builder=$schema->commandBuilder;
$command=$builder->createFindCommand($schema->getTable($tableName), $criteria);Query Builder
Java代码
1.$command = Yii::app()->getDb()->createCommand();
2.$command->select(‘name, label, controller,action’)->from(‘{{menu_item}}’);
3.$command->where(‘menu_id=:mid ‘, array(‘:pid’ => $parent_id);
4.$command->order(‘sort_order ASC, label ASC’);
5.$results = $command->queryAll();
$command = Yii::app()->getDb()->createCommand();
$command->select(‘name, label, controller,action’)->from(‘{{menu_item}}’);
$command->where(‘menu_id=:mid ‘, array(‘:pid’ => $parent_id);
$command->order(‘sort_order ASC, label ASC’);
$results = $command->queryAll();推荐compare,搜索条件允许为空因此不需要加条件
Java代码
1.$criteria = new CDbCriteria;
2.$criteria->alias = ‘t'; //table t,默认select=’*';
3.//一些public vars
4.$criteria->select = ‘id,parentid,name'; //代表了要查询的字段,默认select=’*';
5.$criteria->join = ‘xxx'; //连接表
6.$criteria->with = ‘xxx'; //调用relations $criteria->with = array(‘accounts’,’varchar’);
7.$criteria->with = array(‘teacher’=>
8. array(‘select’=>’username,company_id’,
9. ‘order’=>’teacher.username ASC’)
10.);
11.$criteria->limit = 10; //取1条数据,如果小于0,则不作处理
12.$criteria->offset = 1; //两条合并起来,则表示 limit 10 offset 1,或者代表了。limit 1,10
13.$criteria->order = ‘xxx DESC,XXX ASC’ ;//排序条件
14.$criteria->group = ‘group 条件';
15.$criteria->having = ‘having 条件 ‘;
16.$criteria->distinct = FALSE; //是否唯一查询
17.Article::model()->findAll($criteria);
$criteria = new CDbCriteria;
$criteria->alias = ‘t'; //table t,默认select=’*';
//一些public vars
$criteria->select = ‘id,parentid,name'; //代表了要查询的字段,默认select=’*';
$criteria->join = ‘xxx'; //连接表
$criteria->with = ‘xxx'; //调用relations $criteria->with = array(‘accounts’,’varchar’);
$criteria->with = array(‘teacher’=>
array(‘select’=>’username,company_id’,
‘order’=>’teacher.username ASC’)
);
$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; //是否唯一查询
Article::model()->findAll($criteria);DAO

Java代码
1.$sql =’ … yiiblog_desc like :keywords or yiiblog_title like :keywords … ‘;
2.$TmpStatement = Yii::app()->db->createCommand($sql);
3.$TmpStatement->bindValue(‘:keywords’, ‘%’.$keywords.’%’);
4.findAll(‘username like :username ‘ ,array(“:username”=>”%$key%”));

Java代码 1.$criteria = new CDbCriteria; 2.$criteria->comp […]

  1. 还没有评论
评论提交中, 请稍候...

留言

(Spamcheck Enabled)

Trackbacks & Pingbacks ( 0 )
  1. 还没有 trackbacks