PHP

laravel database select

use IlluminateSupportFacadesDB;
 
$users = DB::select('select * from users');
 
foreach ($users as $user) {
    echo $user->name;
}

laravel db query

$users = DB::table('users')
            ->where('votes', '>', 100)
            ->orWhere(function($query) {
                $query->where('name', 'Abigail')
                      ->where('votes', '>', 50);
            })
            ->get();

LARAVEL QUERY

<?php

Route::get('games', function () {
    
    $games = DB::table('games')->get();
    
    return view('games', ['games' => $games]);
});

Laravel query

//select specified colomns from all users
Employee::get(['name','email','title']);