Laravel注册误差未知字段

Question

脚本返回一个我认为我不包括在代码中的错误。

    SQLSTATE[HY000]: General error: 1364 Field 'phone' doesn't have a default 
value (SQL: insert into `users` (`name`, `email`, `location`, `password`, 
`steps`, `incubation_days`, `updated_at`, `created_at`) values (ilamini 
Ayebatonye Dagogo, [e-mail], Uniben Road, Ugbowo, Benin City, Nigeria, 
$2y$10$aoJRS61Bn/q1eNcUFALjne8erLXD11y1.OmHhurlQJDrex73DPWJW, settings, 8, 
2017-03-01 14:11:54, 2017-03-01 14:11:54))

有人可以将我指向此手机字段的来源。在我的注册控制器类下方。

<?php
namespace AppHttpControllersAuth;
use AppUser;
use Appparing_by_location; 
use AppHttpControllersController;
use IlluminateSupportFacadesValidator;
use IlluminateFoundationAuthRegistersUsers;
class RegisterController extends Controller
{
    /*
    |--------------------------------------------------------------------------
    | Register Controller
    |--------------------------------------------------------------------------
    |
    | This controller handles the registration of new users as well as their
    | validation and creation. By default this controller uses a trait to
    | provide this functionality without requiring any additional code.
    |
    */
    use RegistersUsers;
    /**
     * Where to redirect users after registration.
     *
     * @var string
     */
    protected $redirectTo = '/home';
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function __construct()
    {
        $this->middleware('guest');
    }
    /**
     * Get a validator for an incoming registration request.
     *
     * @param  array  $data
     * @return IlluminateContractsValidationValidator
     */
    protected function validator(array $data)
    {
        return Validator::make($data, [
            'location'  => 'required|min:5',
            'name'      => 'required|max:255',
            'password'  => 'required|min:6|confirmed',
            'email'     => 'required|email|max:255',
        ]);
    }
    /**
     * Create a new user instance after a valid registration.
     *
     * @param  array  $data
     * @return User
     */
    protected function create(array $data)
    {
    $phDay = rand(2,8);
       $user = User::create([
            'name'              => $data['name'],
            'email'             => $data['email'],
            'location'          => $data['location'],
            'password'          => bcrypt($data['password']),
            'steps'             => 'settings',
            'incubation_days'   => $phDay
        ]);
       paring_by_location::create([
            'name'      => $data['name'],
            'email'     => $data['email'],
            'location'  => $data['location'],
        ]);
      event(new AppEventsUserReferred(request()->cookie('ref'), $user));
        return $user;
    }
}

及以下是我认为可能正在干扰寄存器控制器的homecontroller。

public function AccountSettings(Request $request)
    {
        $id = Auth::user()->id;
        $user = User::findOrFail($id);
        $this->validate($request, [
            'account_name'      => 'required|string|min:5',
            'account_number'    => 'required|digits:10',
            'bank_name'         => 'required|string|min:3',
            'phone'             => 'required|digits:11'
        ]);
        $input = $request->all();
        $user->update(array('steps' => 'notification'));
        $update = $user->fill($input)->save(); 


        return redirect()->route('home');
    }  

也是我的用户模型taht具有受保护的字段

 protected $fillable = [
        'name', 'email', 'password', 'location','steps','incubation_days','phone','bank_name','account_name','account_number',
    ];

所以我想了解为什么当我不将手机包含在寄存器控制器中

Answer 1

您应该为phone字段设置nullable()或default()值。users表的迁移中应该看起来像这样：

$table->string('phone')->nullable();

或进行phone字段：

protected function validator(array $data)
{
    return Validator::make($data, [
        'location'  => 'required|min:5',
        'name'      => 'required|max:255',
        'password'  => 'required|min:6|confirmed',
        'email'     => 'required|email|max:255',
        'phone'  => 'required'
    ]);
}

并将其添加到create()方法：

create([
    'name'      => $data['name'],
    'email'     => $data['email'],
    'location'  => $data['location'],
    'phone'     => $data['phone']
]);