用户字段在注册用户时显示为空

Question

I added couple new columns to users table like role, suspended_at and banned_at. And then added them as fillable.

But when a new user is registered, the fields seems empty (except id,created_at and updated_at).

Here is the migration file

Schema::create('users', function (Blueprint $table) {
        $table->increments('id');
        $table->string('name');
        $table->string("username", 20)->unique()->index();
        $table->string('email')->unique();
        $table->string('password');
        $table->string("role",15)->default("newbie");
        $table->rememberToken();
        $table->timestamps();
        $table->dateTime("suspended_at")->nullable();
        $table->dateTime("banned_at")->nullable();
    });

User model

protected $fillable = [
        'name', 'email', 'password', "username", "role", "suspended_at", "banned_at"
    ];

a small demo from users table.

+----+------+----------+-------+----------+------+
| id | name | username | email | password | role |
+----+------+----------+-------+----------+------+
|  4 |      |          |       |          |      |
+----+------+----------+-------+----------+------+

RegisterController

protected function create(array $data)
{
    return User::create([
        'name' => $data['name'],
        'email' => $data['email'],
        "username" => $data["username"],
        'password' => Hash::make($data['password'])
    ]);
}

Answer 1

Shouldn't you add role, suspended_at, banned_at inside User::create to register. And also in your table you don't have suspended_at, banned_at column, please check once.

Instead of using default registration I am suggesting you to create your own controller php artisan make:controller UserController then add a post-url to indicate/trigger the function like Route::post('/register', UserController@add_new_user) and then inside the controller you have to call the model by adding use App\User before class UserController extends Controller and inside the class create your own function like below:

public function add_new_user(Request $request) {
  $user = new User; //modal
  $user->name = $request->name;
  $user->username = $request->username;
  $user->email = $request->email;
  .
  .
  .
  $user->save();
}