yii框架怎么条件查询-YII-php.cn

yii框架怎么条件查询

爱喝马黛茶的安东尼

Lepaskan： 2019-12-07 15:33:15

asal

2627 orang telah melayarinya

条件查询

$customers = Customer::find()->where($cond)->all();

Salin selepas log masuk

$cond就是我们所谓的条件，条件的写法也根据查询数据的不同存在差异，那么如何用yii2的方式来写查询条件呢？

[[简单条件]]

// SQL: (type = 1) AND (status = 2).  
$cond = [&#39;type&#39; => 1, &#39;status&#39; => 2]   
// SQL:(id IN (1, 2, 3)) AND (status = 2)  
$cond = [&#39;id&#39; => [1, 2, 3], &#39;status&#39; => 2]   
//SQL:status IS NULL  
$cond = [&#39;status&#39; => null]

Salin selepas log masuk

【and】:将不同的条件组合在一起，用法举例：

//SQL:`id=1 AND id=2`  
$cond = [&#39;and&#39;, &#39;id=1&#39;, &#39;id=2&#39;]  
//SQL:`type=1 AND (id=1 OR id=2)`  
$cond = [&#39;and&#39;, &#39;type=1&#39;, [&#39;or&#39;, &#39;id=1&#39;, &#39;id=2&#39;]]  
//SQL:`type=1 AND (id=1 OR id=2)` //此写法&#39;=&#39;可以换成其他操作符，例：in like != >=等  
$cond = [  
    &#39;and&#39;,  
    [&#39;=&#39;, &#39;type&#39;, 1],  
    [  
        &#39;or&#39;,  
        [&#39;=&#39;, &#39;id&#39;, &#39;1&#39;],  
        [&#39;=&#39;, &#39;id&#39;, &#39;2&#39;],  
    ]  
]

Salin selepas log masuk

[[or]]:

/SQL:`(type IN (7, 8, 9) OR (id IN (1, 2, 3)))`  
$cond = [&#39;or&#39;, [&#39;type&#39; => [7, 8, 9]], [&#39;id&#39; => [1, 2, 3]]

Salin selepas log masuk

[[not]]:

//SQL:`NOT (attribute IS NULL)`  
$cond = [&#39;not&#39;, [&#39;attribute&#39; => null]]

Salin selepas log masuk

[[between]]: not between 用法相同

//SQL:`id BETWEEN 1 AND 10`  
$cond = [&#39;between&#39;, &#39;id&#39;, 1, 10]

Salin selepas log masuk

[[in]]: not in 用法类似

//SQL:`id IN (1, 2, 3)`  
$cond = [&#39;in&#39;, &#39;id&#39;, [1, 2, 3]] or $cond = [&#39;id&#39;=>[1, 2, 3]]

Salin selepas log masuk

//IN条件也适用于多字段  
$cond = [&#39;in&#39;, [&#39;id&#39;, &#39;name&#39;], [[&#39;id&#39; => 1, &#39;name&#39; => &#39;foo&#39;], [&#39;id&#39; => 2, &#39;name&#39; => &#39;bar&#39;]]]  
//也适用于内嵌sql语句  
$cond = [&#39;in&#39;, &#39;user_id&#39;, (new Query())->select(&#39;id&#39;)->from(&#39;users&#39;)->where([&#39;active&#39; => 1])]

Salin selepas log masuk

[[like]]:

//SQL:`name LIKE &#39;%tester%&#39;`
$cond = [&#39;like&#39;, &#39;name&#39;, &#39;tester&#39;]
//SQL:`name LIKE &#39;%test%&#39; AND name LIKE &#39;%sample%&#39;`
$cond = [&#39;like&#39;, &#39;name&#39;, [&#39;test&#39;, &#39;sample&#39;]]
//SQL:`name LIKE &#39;%tester&#39;`
$cond = [&#39;like&#39;, &#39;name&#39;, &#39;%tester&#39;, false]

Salin selepas log masuk

[[exists]]: not exists用法类似

//SQL:EXISTS (SELECT "id" FROM "users" WHERE "active"=1)
$cond = [&#39;exists&#39;, (new Query())->select(&#39;id&#39;)->from(&#39;users&#39;)->where([&#39;active&#39; => 1])]

Salin selepas log masuk

此外，您可以指定任意运算符如下：

//SQL:`id >= 10`
$cond = [&#39;>=&#39;, &#39;id&#39;, 10] 
//SQL:`id != 10`
$cond = [&#39;!=&#39;, &#39;id&#39;, 10]

Salin selepas log masuk

PHP中文网，有大量免费的Yii入门教程，欢迎大家学习！

Atas ialah kandungan terperinci yii框架怎么条件查询. Untuk maklumat lanjut, sila ikut artikel berkaitan lain di laman web China PHP!