and or php,AND OR-蒲公英云

and or php,AND OR

女爷i 2022-11-13 04:08 285阅读 0赞

## AND OR

上面是基础的Where语句,下面看一下复杂一点的

你可以使用”AND” 或 “OR” 来拼接非常复杂的SQL语句


namespace Action;
use HY\\Action;
class Index extends Action \{
public function Index()\{
//实例User表为对象
$User = S("User");
// 基础使用
$User->select("user\_name", array(
"AND" => array(
"user\_id\[>\]" => 200,
"age\[<>\]" => array(18, 25),
"gender" => "female"
)
));
// WHERE user\_id > 200 AND age BETWEEN 18 AND 25 AND gender = 'female'
$User->select("user\_name", array(
"OR" => array(
"user\_id\[>\]" => 200,
"age\[<>\]" => array(18, 25),
"gender" => "female"
)
));
// WHERE user\_id > 200 OR age BETWEEN 18 AND 25 OR gender = 'female'
// 复合条件
$User->has(array(
"AND" => array(
"OR" => array(
"user\_name" => "foo",
"email" => "foo@bar.com"
),
"password" => "12345"
)
));
// WHERE (user\_name = 'foo' OR email = 'foo@bar.com') AND password = '12345'
// 注意
// 因为使用的是数组传参，所以下面这种用法是错误的。
// 可见 你有两个OR ,数组不可能存在两个相同索引. 所以你需要将另一个OR 加上一个注释
$User->select('\*', array(
"AND" => array(
"OR" => array(
"user\_name" => "foo",
"email" => "foo@bar.com"
),
"OR" => array(
"user\_name" => "bar",
"email" => "bar@foo.com"
)
)
));
// \[X\] SELECT \* FROM "account" WHERE ("user\_name" = 'bar' OR "email" = 'bar@foo.com') 这是错误的示范
// 正确的方式是使用如下方式定义复合条件
$User->select('\*', array(
"AND \#Actually, this comment feature can be used on every AND and OR relativity condition" => array(
"OR \#the first condition" => array(
"user\_name" => "foo",
"email" => "foo@bar.com"
),
"OR \#the second condition" => array(
"user\_name" => "bar",
"email" => "bar@foo.com"
)
)
));
// SELECT \* FROM "account"
// WHERE (
// (
// "user\_name" = 'foo' OR "email" = 'foo@bar.com'
// )
// AND
// (
// "user\_name" = 'bar' OR "email" = 'bar@foo.com'
// )
// )
\}
\}