php - How rewrite DB::select to model with findOrFail in LARAVEL Controller

Question

Hi i have REGION model but i dont know how rewrite this DB::select. I want it with findOrFail or something for ,,If i find this slug i show page if no i show 404

My web.php route

Route::get('/turnaje/{slug}', [RegionController::class, 'show']);

My Region Controller

public function show($slug)
{

    $regions = DB::select('select * from regions where slug = ?', [$slug]);
    $regions_list = DB::select('select * from regions');

    return view('tournaments.show', [
        'regions' => $regions,
        'regions_list' => $regions_list,
    ]);
}

question from:https://stackoverflow.com/questions/65935464/how-rewrite-dbselect-to-model-with-findorfail-in-laravel-controller

Answer 1

So you can use the model as a facade and write a similar query. I'm assuming you want an exception thrown when there is no region with that slug?

https://laravel.com/docs/8.x/eloquent#not-found-exceptions

public function show($slug)
{
    $regions = Region::where('slug', $slug)->firstOrFail();
    $regions_list = Region::all();

    return view('tournaments.show', [
        'regions' => $regions,
        'regions_list' => $regions_list,
    ]);
}

You may want to handle the ModelNotFoundException