PHP

laravel database select

use IlluminateSupportFacadesDB;
 
$users = DB::select('select * from users');
 
foreach ($users as $user) {
    echo $user->name;
}

laravel select selected

    @foreach ($categories as $item)
           @if (isset($produits->categorie_id) && $item->id == $produits->categorie_id || old('categorie_id') == $item->id)
                <option selected value="{{ $item->id }}">{{ $item->libelle }}</option>
           @else
                <option value="{{ $item->id }}">{{ $item->libelle }}</option>
           @endif
   @endforeach

select option in laravel

<select name="like_to" id="like_to" class="form-control">
  <option value="giveaway" {{$data->like_to=='giveaway' ? 'selected' : ''}}>Give Away</option>
  <option value="lend" {{$data->like_to=='lend' ? 'selected' : ''}}>Lend</option>
  <option value="borrow" {{$data->like_to=='borrow' ? 'selected' : ''}}>Borrow</option>
</select>

laravel select

<div class="col-12 form-group">
            {{ Form::label('name', __('choose'),['class'=>'form-label']) }}
            <select class="form-select" aria-label="Default select example"name="type"id="type">
            <option value="{{$formBuilder->type}}" hidden disabled selected>{{$formBuilder->type_name}}</option>
            <option value="1">choose1</option>
            <option value="2">choose2</option>
            <option value="3">choose3</option>
          </select>
        </div>

laravel with select

$books = Book::with('author:id,name,book_id')->get();