Using query builder or eloquent where adding statements with conditions

Laravel Redirect To Another URL / Web Page - HTTP Laravel Redirects

Conditional When Case Statement in Laravel 6 Eloquent