Answers for "laravel query builder create"

laravel not in query

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

wherein laravel

DB::table('user')->whereIn('id', [100,200])->get();

laravel db::query update

DB::table('user')->where('email', $userEmail)->update(array('member_type' => $plan));

laravel query builder select

use Illuminate\Support\Facades\DB;

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

Laravel query builder toSql

$query = DB::table('table')->whereIn('some_field', [1,2,30]);

$sql = $query->toSql();

$bindings = $query->getBindings();

query builder laravel

use Illuminate\Database\Eloquent\Builder;

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