PHP

laravel query builder select

use IlluminateSupportFacadesDB;

$users = DB::table('users')
            ->select('name', 'email as user_email')
            ->get();

How to use Query builder with eloquent in Laravel 8?

$house=house::where('id',1)
    ->orderBy('id')
    ->take(1)
    ->get();
dd($house);

laravel query builder

$email = DB::table('users')->where('name', 'John')->value('email');

laravel query when

$users = DB::table('users')
                ->when($role, function ($query, $role) {
                    $query->where('role_id', $role);
                })
                ->get();

query builder laravel

use IlluminateDatabaseEloquentBuilder;

public function scopeFakePersons(Builder $query): Builder
{
  return $query->where('is_fake', 1);
}

laravel where in query builder

public function index()
{
    $users = User::select("*")
                    ->whereIn('id', [4, 5, 6])
                    ->get();
  
    dd($users);                    
}

LARAVEL QUERY

<?php

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

laravel query builder

use IlluminateSupportFacadesDB;

$users = DB::table('users') // Table name

->get() //Get all users

->where('name', 'John') // Where clause

->first() //First result

->groupBy('status') //Grouping

Laravel query

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