How to properly validate a unique field?

Question

Yii

I'm trying to make the phone unique, following the example of other validation rules

['phone', 'trim'],
            ['phone_repeat', 'trim'],
            ['phone', 'required'],
            ['phone_repeat', 'required'],
            ['phone', 'string', 'min' => 10],
            ['phone_repeat', 'compare', 'compareAttribute' => 'phone'],
            ['phone', 'unique', 'targetClass' => '\app\models\User', 'message' => 'Телефон занят'],

But when I try to record a phone that is already in the database, I get an exception ..

Answer 1

You can write your own validator. Something like:

public function validatePhone($attribute, $params)
    {
        if (!$this->hasErrors()) {
            $user = User::findOne(['phone' => $this->$attribute]);

            if ($user ) {
                $this->addError($attribute, 'Телефон занят');
        }
    }

In rules:
['phone', 'validatePhone'],