Laravel Route::get using where conditions

- 1 answer

Ad

I'm working on Laravel 5.1 and I have the following code:

//Routes.php
Route::get('/listagem/{campo}','[email protected]');

//ControllerParque.php
    public function listar($campo) {       
        $listagem = DB::SELECT("SELECT COUNT(x.".$campo.") AS nreg, x.* FROM (SELECT * FROM computadores ORDER BY id DESC) AS x GROUP BY ".$campo." ORDER BY ".$campo." ASC");  
        $dados = array('listagem' => $listagem, 'campo' => $campo);
        return view("ViewListagem")->with($dados);           
    }

I would like to restrict anything different of 'listagem/usuario' or 'listagem/tag'. I mean, if an user types in your navigator (URL bar) 'listagem/crap', it will be denied, because it's not 'listagem/usuario' or 'listagem/tag'.

I've tried 'where' clause':

Routes.php
    Route::get('/listagem/{campo}','[email protected]')
->where('campo', 'usuario');

But this way I'm restricting just the one condition, this case 'listagem/usuario'.

Any idea?

Ad

Answer

Ad

You can use a regular expression in the "where" clause. usario|tag would match only usario or taghttp://laravel.com/docs/5.0/routing#route-parameters

Route::get('/listagem/{campo}','[email protected]')
    ->where('campo', 'usuario|tag');
Ad
source: stackoverflow.com
Ad