laravel db query builder code example

Example 1: laravel not in query

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();

Example 2: laravel query builder select first

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

var_dump($user->name);

Example 3: query builder laravel

use Illuminate\Database\Eloquent\Builder;

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