5.0.0 - 普通 - 已关闭
StoreQuestion::where(function ($query) use ($param) {
if (isset($param['keyword'])) {
$query->where('title', 'like', '%' . $param['keyword'] . '%');
}
if (isset($param['courseid'])) {
$query->where('courseid', '=', $param['courseid']);
}
})
->where('createuidtype', '=', $createuidtype)
->where('createuid', '=', $account['id'])
如果闭包里的where条件不走的话 就会报sql语句错误 把闭包写在后面就没有问题如下：
StoreQuestion::where('createuidtype', '=', $createuidtype)
->where('createuid', '=', $account['id'])
->where(function ($query) use ($param) {
if (isset($param['keyword'])) {
$query->where('title', 'like', '%' . $param['keyword'] . '%');
}
if (isset($param['courseid'])) {
$query->where('courseid', '=', $param['courseid']);
}
}) 