平时做项目,在封装where条件是会有一些不常用的小点,记下来,免得忘了。
两字段或:
$where['name1|name2'] = array('like',"%$name%");
手写条件:
$where['_string'] = "id IN (SELECT id FROM table WHERE name LIKE '%$name%') ";
一字段多限制:
$where['time'][] = array('egt',$starttime);
$where['time'][] = array('elt',$en