Answers for "laravel select by id"

laravel query select from table where id != to another table id

DB::table('tbl_sales')
->whereNotIn('id', DB::table('tbl_registration')->pluck('sale_id'))
->get();

DB::table('users')->get(); id 1

$users = DB::table('users')where('id','=', $userid)->get();

laravel get ID from insert

$data = User::create(['name'=>'first']);
dd($data->id);

query builder laravel

use IlluminateDatabaseEloquentBuilder;

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