laravel-null列

n53p2ov0  于 2021-07-26  发布在  Java
关注(0)|答案(1)|浏览(425)

我在我的位置加了两列 users table、viber和whatsapp,带有两个artisan命令 php artisan make:migration add_viber_to_users 以及 php artisan make:migration add_whatsapp_to_users . 以下是我的迁移:
viber迁移:

  1. /**
  2. * Run the migrations.
  3. *
  4. * @return void
  5. */
  6. public function up()
  7. {
  8. Schema::table('users', function (Blueprint $table) {
  9. $table->integer('viber')->after('status')->nullable();
  10. });
  11. }

whatsapp迁移:

  1. /**
  2. * Run the migrations.
  3. *
  4. * @return void
  5. */
  6. public function up()
  7. {
  8. Schema::table('users', function (Blueprint $table) {
  9. $table->integer('whatsapp')->after('viber')->nullable();
  10. });
  11. }

在我的心里 RegisterController :

  1. /**
  2. * Get a validator for an incoming registration request.
  3. *
  4. * @param array $data
  5. * @return \Illuminate\Contracts\Validation\Validator
  6. */
  7. protected function validator(array $data)
  8. {
  9. return Validator::make($data, [
  10. 'name' => ['required', 'string', 'max:255'],
  11. 'email' => ['required', 'string', 'email', 'max:255', 'unique:users'],
  12. 'password' => ['required', 'string', 'min:8', 'confirmed'],
  13. 'telefon' => ['required', 'numeric', 'unique:users', 'min:6'],
  14. 'drzava' => ['required'],
  15. 'grad' => ['required'],
  16. 'status' => ['required'],
  17. 'viber' => ['required', 'numeric'],
  18. 'whatsapp' => ['required', 'numeric'],
  19. ]);
  20. }
  21. /**
  22. * Create a new user instance after a valid registration.
  23. *
  24. * @param array $data
  25. * @return \App\User
  26. */
  27. protected function create(array $data)
  28. {
  29. return User::create([
  30. 'name' => $data['name'],
  31. 'email' => $data['email'],
  32. 'password' => Hash::make($data['password']),
  33. 'telefon' => $data['telefon'],
  34. 'drzava' => $data['drzava'],
  35. 'grad' => $data['grad'],
  36. 'status' => $data['status'],
  37. 'viber' => $data['viber'],
  38. 'whatsapp' => $data['whatsapp'],
  39. ]);
  40. }

另外,这是我的表单选择字段 viber 以及 whatsapp :

  1. <select class="form-control{{ $errors->has('viber') ? ' is-invalid' : '' }}" required name="viber" id="inputGroupSelect01">
  2. <option selected>Viber</option>
  3. <option value="1">Da</option>
  4. <option value="0">Ne</option>
  5. </select>
  6. @if($errors->has('viber'))
  7. <div class="invalid-feedback">
  8. {{ $errors->first('viber') }}
  9. </div>
  10. @endif
  1. <select class="form-control{{ $errors->has('whatsapp') ? ' is-invalid' : '' }}" required name="whatsapp" id="inputGroupSelect01">
  2. <option selected>Viber</option>
  3. <option value="1">Da</option>
  4. <option value="0">Ne</option>
  5. </select>
  6. @if($errors->has('whatsapp'))
  7. <div class="invalid-feedback">
  8. {{ $errors->first('whatsapp') }}
  9. </div>
  10. @endif

这里有问题吗
我在这里的问题是每当我注册一个新用户,我选择两者 viber 以及 whatsapp 的字段 Da 所以价值是 1 在我的数据库中 NULL . 我看不出有什么问题?我怎样才能解决这个问题?

yb3bgrhw

yb3bgrhw1#

确保你跑步 php artisan migrate 已经迁移到你的table上了
确保将新列添加到 fillable 模型中的数组。

相关问题