consultas sql a la route

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');
  • Categoria: web_development
  • Etiquetes: bbdd, consulta-sql, laravel
  • Data de creació: 10/08/2022
  • Última actualització: 28/08/2024