原来5.0x版本的原来可以这么写,没有报错并且正常查询到数据!
$ids = array(
0 => 121,
1 => 125,
2 => 135
);
$where=[];
$where['site_id'] = ['in',$ids];
$data = Db::name('site')->where($where)->count();
但是在5.1x版报 sql语句错误,具体错误代码如下!
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':)' at line 1
问:在5.1x版本中这个数组查询表达式应该怎么写?
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…