I'm working on Laravel 5.1 and I have the following code:
//Routes.php
Route::get('/listagem/{campo}','ControllerParque@listar');
//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}','ControllerParque@listar')
->where('campo', 'usuario');
But this way I'm restricting just the one condition, this case 'listagem/usuario'.
Any idea?
You can use a regular expression in the "where" clause. usario|tag would match only usario or tag http://laravel.com/docs/5.0/routing#route-parameters
Route::get('/listagem/{campo}','ControllerParque@listar')
->where('campo', 'usuario|tag');
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With