Please note: I am pretty new to laravel and programming in general.
So I am working on setting up a role system on my laravel project and I followed a tutorial and did eveything the same. My problem is that when registering it should register a new user with role 'User' and that's not happening. Also my database seeding isn't saving any role ID to my users.
My users table migration:
class CreateUsersTable extends Migration
{
public function up()
{
Schema::create('users', function (Blueprint $table) {
$table->bigIncrements('id');
$table->string('name');
$table->string('email')->unique();
$table->timestamp('email_verified_at')->nullable();
$table->string('password');
$table->rememberToken();
$table->timestamps();
$table->unsignedBigInteger('roles_id')->nullable();
$table->foreign('roles_id')->references('id')->on('roles');
});
}
public function down()
{
Schema::dropIfExists('users');
}
}
My roles table migration:
class CreateRolesTable extends Migration
{
public function up()
{
Schema::create('roles', function (Blueprint $table) {
$table->bigIncrements('id');
$table->string('name');
});
}
public function down()
{
Schema::dropIfExists('roles');
}
}
My role_user table migration:
class CreateRoleUserTable extends Migration
{
public function up()
{
Schema::create('role_user', function (Blueprint $table) {
$table->bigIncrements('id');
$table->bigInteger('role_id')->unsigned();
$table->bigInteger('user_id')->unsigned();
});
}
public function down()
{
Schema::dropIfExists('role_user');
}
}
My DataBaseSeeder:
use Illuminate\Database\Seeder;
class DatabaseSeeder extends Seeder
{
public function run()
{
// Role comes before User seeder here.
$this->call(RoleTableSeeder::class);
// User seeder will use the roles above created.
$this->call(UserTableSeeder::class);
}
}
RoleTableSeeder
use Illuminate\Database\Seeder;
use App\Role;
class RoleTableSeeder extends Seeder
{
public function run()
{
$role_worker = new Role();
$role_worker->name = 'worker';
$role_worker->save();
$role_admin = new Role();
$role_admin->name = 'admin';
$role_admin->save();
$role_user = new Role();
$role_user->name = 'user';
$role_user->save();
}
}
UserTableSeeder
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\Hash;
use App\Role;
use App\User;
class UserTableSeeder extends Seeder
{
public function run()
{
$role_worker = Role::where('name', 'worker')->first();
$role_admin = Role::where('name', 'admin')->first();
$role_user = Role::where('name', 'user')->first();
$worker = new User();
$worker->name = 'Worker User';
$worker->email = 'worker@worker.com';
$worker->password = Hash::make('password');
$worker->save();
$worker->roles()->attach($role_worker);
$admin = new User();
$admin->name = 'Admin user';
$admin->email = 'admin@admin.com';
$admin->password = Hash::make('password');
$admin->save();
$admin->roles()->attach($role_admin);
$user = new User();
$user->name = 'Regular user';
$user->email = 'user@user.com';
$user->password = Hash::make('password');
$user->save();
$user->roles()->attach($role_user);
}
}
Tables after migrating/seeding
So again, my problem is that when registering it should register a new user with role 'User' and that's not happening. Also my database seeding isn't saving any roles_id to my users.
