$where = array();
$where['status'] = '发布中';
$list = D('ad')->where($condition)->select();
执行后输出的sql语句(会报错)如下:
SELECT * FROM t_ad
WHERE status
= ‘鍙戝竷涓\?
原因应该是where()方法把条件中的中文转码了
如果修改为
$list = D('ad')->where("status = '发布中' ")->select();
执行后输出的sql语句(正常)如下:
SELECT * FROM t_ad
WHERE status
= ‘发布中’