Laravel different validation doesn't work with strings containing numbers

Question

I want to validate a value that I got from a certain form. The value type is text. I want it to match a specific username from the database from the users table, but also to not match the current user's username.

To achieve that, I used the following validation rules:

'username' => [
    'required',
    'string',
    'exists:App\User,username',
    'different:' . auth()->user()->username
]

What I've discovered is that whenever the auth()->user()->username value includes a digit, it passes the validation even if request()->username = auth()->user()->username. Is there anything I can do to prevent this from happening?

Thanks in advance.

Saurabh Gupte · Accepted Answer · 2020-06-17 23:14:39Z

4

Use unique like -

Considering id is your user's id.

'username' => 'required|string|unique:username,id,'.auth()->user()->username,

This will check if username is unique or not except this userId.

edited Jun 17, 2020 at 23:14

Saurabh Gupte

2601 gold badge6 silver badges17 bronze badges

answered Jun 17, 2020 at 23:08

Abhishek Honrao

84511 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

RCRalph Over a year ago

I'm afraid this won't work for me. I want it to refer to an existing record in the database, which unique doesn't support.

Abhishek Honrao Over a year ago

unique will consider in exsting records as well. refer - laravel.com/docs/7.x/validation

Abhishek Honrao Over a year ago

Chekout this - stackoverflow.com/questions/52335632/…

Abhishek Honrao Over a year ago

What do you mean? I am not getting you. Can your elaborate, please?

Abhishek Honrao Over a year ago

This may help you - stackoverflow.com/questions/26121417/…

|

RCRalph · Accepted Answer · 2020-10-01 18:16:26Z

2

The answer to this issue was creating own Rule::exists validation, which is shown below:

'username' => [
    'required',
    'string',
    Rule::exists('users')->where(function ($query) {
        $query->where('username', '<>', auth()->user()->username);
    })
],

edited Oct 1, 2020 at 18:16

answered Jun 17, 2020 at 23:49

RCRalph

4049 silver badges19 bronze badges

Comments

pinokyov · Accepted Answer · 2020-12-20 17:32:41Z

1

I solved a similar problem as follows.

$request->validate([
            'email' => ['required', 'email','unique:users,email,'.Auth::id()],
            'phone' => ['required', 'unique:users,phone,'.Auth::id()],
        ]);

answered Dec 20, 2020 at 17:32

pinokyov

364 bronze badges

Collectives™ on Stack Overflow

Laravel different validation doesn't work with strings containing numbers

3 Answers 3

11 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

11 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related