Laravel独特的验证问题

Question

I try to make a unique validation the settings of my website but this doesn't work :

In my controller :

$rules = array(
    'username' => 'required|unique:User,username,10',
    'email'    => 'required|email|unique:User,email,10',
    'language' => 'required|in:fr,en',
);

My model:

class User extends Eloquent implements UserInterface, RemindableInterface {

    use UserTrait, RemindableTrait;
    protected $primaryKey = 'id_user';
    protected $table = 'user';

}

The problem is:

My Validator Validator::make(Input::all(), $rules, $messages); fails, it says that this username and email already exist.

Answer 1

Disagree with the answer to your own question:

"Laravel is not done to search in a custom column".

This is not true.

To be precise: There is nothing bad in using a Plugin...

---

See the important part of a migration file (app/database/migrations):

   // creates a DB-table named 'users'
    Schema::create('users', function (Blueprint $t) {
        $t->increments('id');
        $t->timestamps();
        // ... Here a unique field
        $t->string('user_email_one', 255)->unique();
        // ...
    });

And the relevant validation rules in the UserController:

     $rules = array(
        'user_email_one' => 'required|email|unique:users',
        // ...
     );

And Laravel is doing its job.

---

With unique: you have to call the DB-table name, not the model name.

BTW: the plugin you've chosen does this...

The Laravel docs about validation:

unique:table,column,except,idColumn

The field under validation must be unique on a given database table.

If the column option is not specified, the field name will be used.

---

Just as an interesting info about naming a mySQL table 'User', 'user' or 'users', which could have caused your error. Visit this question:

Is there a naming convention for MySQL? asked by StackOverflowNewbie, answered by Tom Mac (highest vote & accepted answer)