I trying to make a CRUD called Usuarios(Users) with a foreing key from the table Perfiles(profiles) , the foreing key is the id from Profiles, but I donot know how to make it with a select
tHIS IS MY FORM.BLADE.PHP
<select name="idPerfil" id="idPerfil" class="form-control">
<option value="">Eliga un nombre de perfil </option>
@foreach ($perfiles as $perfil)
<option value="{{ $perfil['id'] }}"
@if ($perfil->id === $usuario->idPerfil)
selected
@endif
> {{ $perfil['NombrePerfil'] }}
</option>
@endforeach
</select>
PerfilesContoller.php
public function edit($id)
{
$perfil= Perfiles::findOrFail($id);
return view('perfiles.edit',compact('perfil'));
}
public function create() {
return view('perfiles.create');
}
THIS IS MY USUARIOSCONTROLLER.PHP
public function create()
{
//
$perfiles = Perfiles::all();
return view('usuarios.create',compact('perfiles'));
}
public function edit($id) { //
$usuario= Usuarios::findOrFail($id);
$perfiles = Perfiles::all();
return view('usuarios.edit',compact('usuario','perfiles'));
}
Table Pefiles
public function up()
{
Schema::create('perfiles', function (Blueprint $table) {
$table->increments('id');
$table->string('NombrePerfil')->unique();
$table->timestamps();
});
}
table usuarios
public function up()
{
Schema::create('usuarios', function (Blueprint $table) {
$table->increments('id');
$table->unsignedInteger('idPerfil');
$table->string('Nombre');
$table->string('UserName')->unique();
$table->string('Email')->unique();
$table->string('Password');
$table->foreign('idPerfil')->references('id')->on('perfiles');
$table->rememberToken();
$table->timestamps();
});
}