tp3.2的组合查询

Question

thinkphp3.2下，怎么写以下情况的where语句，当role字段等于1或者2且home字段等于4，请问这句where怎么写？

Answer 1

$where['_string']="(role=1 or role 2 ) and home=4 ";

Answer 2

先查询home等于4 然后对结果集遍历取出相应的结果

Answer 3

$where['role']  = array('eq', 1);
$where['role']  = array('eq',2);
$where['_logic'] = 'or';
$map['_complex'] = $where;
$map['home']  = array('eq',4);

->where($map)->select()