Question

laravel add where clouse only if value is not null

Answer 1

return DB::table('course_modules')->select('module_id', 'publish_from', 'publish_to') ->where('course_id', $course_id) ->where('is_deleted', '0') ->orwhere('publish_from', '>=', date('Y-m-d H:i:s')) ->orwhere('publish_to', '<=', date('Y-m-d H:i:s')) ->orwhere(function($query) { $query->where('publish_from', '>=', date('Y-m-d H:i:s')) ->where('publish_to', '<=', date('Y-m-d H:i:s')); }) ->where('hide_module', 1) ->get();