Route
Route::get('/site/{site_name_en}/{id}', array( 'as' => 'profile-site', 'uses' => 'ProfileController@site' )); Controller
class ProfileController extends BaseController{ public function site($id, $site_name_en){ $site = Site::where('id', '=', $id) ->where('site_name_en', '=', $site_name_en); if($site->count()){ $site = $site->first(); return View::make('profile.site') ->with('site', $site); } return App::abort(404); } } What I'm trying to achieve is: that when I visit the following URL www.domain.com/site/abc/123456, it will shown the correct page based on the parameters. Is the where clause correct? (because I couldn't retrieve the value)