switch ($key) {
case in_array($key, ['=', '>', '<', '>=', '<=', '<>']):
$this->where .= " AND $value $key ?";
break;
case 'like':
$this->where .= " AND $value LIKE ?";
$item = "%$item%";
break;
case 'like-L':
$this->where .= " AND $value LIKE ?";
$item = "%$item";
break;
case 'like-R':
$this->where .= " AND $value LIKE ?";
$item = "$item%";
break;
}
switch ($key) {
case in_array($key, ['=', '>', '<', '>=', '<=', '<>']):
$this->where .= " AND $value $key ?";
break;
case in_array($key, ['like', 'like-L', 'like-R']):
$this->where .= " AND $value LIKE ?";
if ($key === 'like') {
$item = "%$item%";
break;
};
if ($key === 'like-L') {
$item = "%$item";
break;
}
if ($key === 'like-R') {
$item = "$item%";
}
break;
default:
//
}
有更好的 还请大家分享一下 谢谢
个人观点:不推荐,在case后面做公式,直接
case
单一的值就好。为什么不推荐?
丑
、乱
、邋遢
。如果
case
下面拼装sql的代码一致,可以这样写: