首页›数据库›Where\Factor 数组语法
Where\Factor 数组语法
_complex 嵌套、跨字段 OR、字符串条件
_complex 嵌套
// 方式一:字符串键
M("order")->where(array(
"status" => 1,
"_complex" => array("or",
array("amount" => array(">", 1000)),
array("vip_level" => array(">=", 3)),
),
))->select();
// WHERE (`status` = :w0 AND (`amount` > :w1 OR `vip_level` >= :w2))
// 方式二:数字首元素
M("order")->where(array(
array("_complex", "or", array("a" => 1), array("b" => 2)),
))->select();跨字段 OR(字段名含 |)
M("user")->where(array(
"name|email" => "张", // name=张 OR email=张
))->select();
// 等价
M("user")->where(array(
"_complex" => array("or", array("name" => "张"), array("email" => "张")),
))->select();多条件优先级
多个条件时自动加括号:(cond1 AND cond2 ...);andWhere/orWhere 追加条件,与既有条件按各自关系连接。
KuoqiPHP v1.05 · 离线静态文档 · 界面基于 KuoqiUI ·
返回首页