Laravel 通过数据库记录进行验证

Question

Problem is how to validate by Database model, I have model "Emails". I just want to people can register if their email already in our Email model.

电子邮件数据库表

Schema::create('emails', function (Blueprint $table) {
        $table->increments('id');
        $table->text('username')->nullable();
        $table->text('fullname')->nullable();
        $table->text('description')->nullable();
        $table->text('email')->nullable();
        $table->timestamps();
});

Auth@RegisterController

protected function validator(array $data)
{
    return Validator::make($data, [
        'name'     => 'required|max:255',
        'email'    => 'required|max:255|unique:users',         here i guess
        'password' => 'required|min:6|confirmed',
    ]);
}**strong text**

Answer 1

您必须使用unique验证 users 中的唯一电子邮件表和exists验证以检查 emails 中是否存在电子邮件表。

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

假设您有email领域 users和emails表格