xxxxxxxxxx
use Illuminate\Database\Eloquent\Builder;
public function scopeFakePersons(Builder $query): Builder
{
return $query->where('is_fake', 1);
}
xxxxxxxxxx
use Illuminate\Support\Facades\DB;
$users = DB::table('users')
->select('name', 'email as user_email')
->get();
xxxxxxxxxx
public function index()
{
$users = User::select("*")
->whereIn('id', [4, 5, 6])
->get();
dd($users);
}
xxxxxxxxxx
$house=house::where('id',1)
->orderBy('id')
->take(1)
->get();
dd($house);
xxxxxxxxxx
DB::table('users')->insert([
'email' => 'kayla@example.com',
'votes' => 5
]);
xxxxxxxxxx
$users = DB::table('users')
->when($role, function ($query, $role) {
$query->where('role_id', $role);
})
->get();
xxxxxxxxxx
<?php
Route::get('games', function () {
$games = DB::table('games')->get();
return view('games', ['games' => $games]);
});
xxxxxxxxxx
$freePages = Page::where(function ($query) {
$query->where('menu_id', '<>', $this->menu->id);
$query->orWhereNull('menu_id');
})->where('status', '=', true)
->get();
xxxxxxxxxx
DB::table('users')->insert([
'email' => 'kayla@example.com',
'votes' => 0
]);