<div class="form-group col-md-12"> <label>Pilih Pengguna</label> <select class="form-control selectpicker" data-live-search="true" name="id_pengguna"> @foreach ($penggunas as $id_pengguna => $nama_pengguna) <option value="{{ $id_pengguna }}">{{ $nama_pengguna}}</option> @endforeach </select> </div>
public function __construct()
    {
        $this->Pengguna = new Pengguna();
        $this->Order = new Order();
    }
 public function index() {
    $sql="select * from tb_pendaftaran ";	
		$pendaftarans = DB::select($sql); 
  
        $evens = DB::table('tb_even as a')
            ->select(DB::raw("CONCAT(a.nama_even) AS nama_even"), 'a.id_even')
            ->pluck('nama_even', 'id_even')
            ->all();
        $relawans = DB::table('tb_relawan as c')
            ->select(DB::raw("CONCAT(c.nama_relawan) AS nama_relawan"), 'c.id_relawan')
            ->pluck('nama_relawan', 'id_relawan')
            ->all();
        return view('admin.pendaftaran.index', ['pendaftarans' => $pendaftarans, 'evens' => $evens, 'relawans' => $relawans]);
    }

 
0 Komentar