yii框架怎么条件查询

条件查询

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

$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]

【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;],  
    ]  
]

[[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]]

[[not]]:

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

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

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

[[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]]

//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])]

[[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]

[[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])]

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

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

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

以上就是yii框架怎么条件查询的详细内容，更多请关注其它相关文章！