detall post - consultas sql a la route

Creado en: 2022-08-10 13:01:31

Actualizado en: 2024-08-28 06:02:30

codes

bbdd consulta-sql laravel

consultas sql a la route



Route::get('/people', function () {
    $persons = DB::select("SELECT * FROM `people` WHERE `categoria` IN ('photographers', 'painters', 'influencers', 'music'); ");
    return view('people', compact('persons'));
});



Route::get('/dashboard', function()
{
    $persons = DB::table('people')->where('categoria', 'models')
                                ->orderBy('id', 'desc')
                                ->paginate(20);
    return View::make('dashboard')->with('persons', $persons);
})->name('dashboard');
consultas sql  a la route