About common methods of CDBCriteria in Yii-PHP Tutorial-php.cn

About common methods of CDBCriteria in Yii

不言

Release： 2023-04-01 08:54:02

Original

1853 people have browsed it

This article mainly introduces the common methods of Yii CDBCriteria. It summarizes and analyzes the functions and common methods of the CDBCriteria class in the form of examples. It has certain reference value. Friends in need can refer to it.

The examples in this article describe Yii CDBCriteria common methods. Share it with everyone for your reference, the details are as follows:

Note: $c = new CDbCriteria(); is a way of writing ActiveRecord, which makes ActiveRecord more flexible, instead of DAO (PDO) and Query Builder.

A small comment: I feel that this part of the manual is average.

These are some notes and common usage of Yii CDbCriteria:

1. A sql assembly situation

Php code:

$criteria = new CDbCriteria;
//函数方式
$criteria->addCondition("id=1"); //查询条件，即where id = 1
$criteria->addInCondition(&#39;id&#39;, array(1,2,3,4,5)); //代表where id IN (1,23,,4,5,);
$criteria->addNotInCondition(&#39;id&#39;, array(1,2,3,4,5));//与上面正好相法，是NOT IN
$criteria->addCondition(&#39;id=1&#39;,&#39;OR&#39;);//这是OR条件，多个条件的时候，该条件是OR而非AND
$criteria->addSearchCondition(&#39;name&#39;, &#39;分类&#39;);//搜索条件，其实代表了。。where name like &#39;%分类%&#39;
$criteria->addBetweenCondition(&#39;id&#39;, 1, 4);//between 1 and 4
$criteria->compare(&#39;id&#39;, 1); //这个方法比较特殊，他会根据你的参数自动处理成addCondition或者addInCondition，
//即如果第二个参数是数组就会调用addInCondition
$criteria->addCondition("id = :id");
$criteria->params[&#39;:id&#39;]=1;
//属性方式
$criteria->select = &#39;id,parentid,name&#39;; //代表了要查询的字段，默认select=&#39;*&#39;;
$criteria->join = &#39;xxx&#39;; //连接表
$criteria->with = &#39;xxx&#39;; //调用relations
$criteria->limit = 10; //取1条数据，如果小于0，则不作处理
$criteria->offset = 1; //两条合并起来，则表示 limit 10 offset 1,或者代表了。limit 1,10
$criteria->order = &#39;xxx DESC,XXX ASC&#39; ;//排序条件
$criteria->group = &#39;group 条件&#39;;
$criteria->having = &#39;having 条件 &#39;;
$criteria->distinct = FALSE; //是否唯一查询

Copy after login

Example:

Php code:

$criteria = new CDbCriteria();
$criteria->select = &#39;table_name,model_id,sum(amount) total&#39;;
$criteria->group = &#39;table_name,model_id&#39;;
$criteria->addCondition("$nIdcId=4");//也可以$criteria->condition = "$nIdcId=4";
$aResult = accessory_info::model()->findAll($criteria);
$c = new CDbCriteria();
$c->select = &#39;t.id, t.created_at, t.outsource_id, t.user_id, t.operate, t.content&#39;;
$c->join = &#39;LEFT JOIN outsource ON outsource.id=t.outsource_id&#39;;
$c->condition = &#39;outsource.idc_id IN(&#39; . implode(&#39;,&#39;, $idc_ids) . &#39;)&#39;;
if($last_log_id) {
$c->condition .= " AND t.id > $last_log_id";
}
$c->limit = 20;
$c->order = &#39;t.id DESC&#39;;
$logs = OutsourceProcessLog::model()->findAll($c);

Copy after login

Comments:

1. The difference from the DAO method is that each element in the DAO method array is still an array. With the CDbCriteria method, the elements in the array are objects.
2. Even if this function is very powerful, there are still some requirements that cannot be met, and sql statements are still needed at this time. For example, select avg(num) amount from ****.
3. Print the results after running, and you can learn more about how Yii implements this

Php code:

//可见
$c = new CDbCriteria();
$c->join = "JOIN idc_user on t.id=idc_user.user_id";
$c->condition = "idc_user.idc_id=$idc_id";
//运行后
object(CDbCriteria)#98 (12) { ["select"]=> string(1) "*" ["distinct"]=> bool(false) ["condition"]=> string(17) "idc_user.idc_id=6" ["params"]=> array(0) { } ["limit"]=> int(-1) ["offset"]=> int(-1) ["order"]=> string(0) "" ["group"]=> string(0) "" ["join"]=> string(38) "JOIN idc_user on t.id=idc_user.user_id" ["having"]=> string(0) "" ["with"]=> NULL ["alias"]=> NULL }
//User::model()->with(&#39;Idcs&#39;)->findAll($c)

Copy after login

2. The situation of mergeWith

Php code:

//在ActiveRecord中，增加条件限制
$this->getDbCriteria()->mergeWith(array(
&#39;condition&#39;=>"idc_id IN ($ids)",
));

Copy after login

The above is the entire content of this article , I hope it will be helpful to everyone’s learning. For more related content, please pay attention to the PHP Chinese website!

Related recommendations:

How to implement the Yii framework to output and execute sql statements on the page and debug

How to implement the Yii2 framework Use PHPExcel to export Excel files

The above is the detailed content of About common methods of CDBCriteria in Yii. For more information, please follow other related articles on the PHP Chinese website!