Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Laravel Route::get using where conditions

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?

like image 668
jbernardo Avatar asked Dec 05 '25 00:12

jbernardo


1 Answers

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');
like image 182
Jeff Avatar answered Dec 07 '25 16:12

Jeff



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!