xxxxxxxxxx
use Illuminate\Support\Facades\DB;
$users = DB::table('users') // Table name
->get() //Get all users
->where('name', 'John') // Where clause
->first() //First result
->groupBy('status') //Grouping
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
use Illuminate\Database\Eloquent\Builder;
public function scopeFakePersons(Builder $query): Builder
{
return $query->where('is_fake', 1);
}