antriver/laravel-unique-email-validator

Laravel validation rule to check an email address is really unique.

1.0.0 2020-12-31 21:11 UTC

Requires

• laravel/framework: ^5.6

Requires (Dev)

• ext-pdo: *
• phpunit/phpunit: ^9.5

MIT

• Anthony Kuske

README

This provides a Laravel validation rule that improves upon the built in 'unique' rule when preventing the same email address being used more than once.

Some email providers (Gmail) allow you to use + in the email address to create 'aliases'. For example if your email address is [e-mail] you can also use:

• [e-mail]
• [e-mail]
• [e-mail]

and they all work. The normal 'unique' rule would allow these as they are all different. This rule sees these all as the same and will disallow using the same '[e-mail]' account.

Some email providers (Gmail) also allow you to place periods anywhere before the @ sign in the email address and these will all work. For example if your email address is [e-mail] you can also use:

• [e-mail]
• [e-mail]

Requirements

Your MySQL server must support the non-greedy regex operator. This has been tested with MySQL 8 and MariaDB 10.2 so those versions or newer should work.

Installation

composer require antriver/laravel-unique-email-validator

Usage

    $this->validate(
        $request,
        [
            // Check for other use of the same email address in the users.email column.
            'email' => [new \Antriver\LaravelUniqueEmailValidator\UniqueEmailRule('users', 'email')],
        ]
    );

Like the original unique rule you can specify certain rows should be excluded. This is useful when updating a user and that should not reject the user's existing registered email address:

    $this->validate(
        $request,
        [
            'email' => [new \Antriver\LaravelUniqueEmailValidator\UniqueEmailRule('users', 'email', ['id' => 123])],
            // Where 123 is the 'id' of the existing user.
        ]
    );