Now, how does it know the table name and field name to check, have you think about it?

The problem is only for phone

Yes, of course, when did I say the opposite?

Now, how does it know the table name and field name to check, have you think about it?

Its not necessary to check that..

In my knowledge..sorry if i am mistaken

That’s why phone don’t work, because you think that

Then how the e-mail unique works???
I had not given table name nd column name for that also

How can it know the table and field name.

Thats what i am askin

Yes, you give it that data.

When you only give the table name, it use the input name as field name.

I am asking you that ..then how the email validation is working fine

I didnt specify the column and table for email

Because you provided the table name, and it use the input name as field name.

You did, just stop assuming, and read again.

Ok got it

But its not working..same

public function store(Request $request)
{
$this->validate($request, [
‘name’ => ‘required|max:255′,
’email’ => ‘required|unique:users|email|max:255’,
‘avatar’ => ‘image|max:3072’,
‘password’ => ‘required|min:6|confirmed’,
‘phone’ => ‘required|unique:users|string|min:10’,

],[
‘phone.unique’ => ‘The phone number is already registered with us’

]);
try {
$users_create_permission = check_permission(‘userscreate’,Auth::user()->role_id);
if($users_create_permission==1) {
// $User = $request->all();

$User[‘phone’] = “+”.$request->phone1.$request->phone;
$User[‘password’] = bcrypt($request->password);
$url = env(‘DO_SPACES_ENDPOINT’) . ‘/’ . env(‘DO_SPACES_BUCKET’) . ‘/’;
if($request->hasFile(‘avatar’)) {
// $User[‘avatar’] = (‘storage/’.$request->avatar->store(‘user/profile’));
$image = $request->file(‘avatar’);
$name = str_slug($image->getClientOriginalName() . uniqid()) . ‘.’ . $image->getClientOriginalExtension();
$filePath = ‘images/B2C/’ . $name;
Storage::disk(‘do_spaces’)->put($filePath, file_get_contents($image));
$User[‘avatar’] = $url . $filePath;
}
$User[‘latitude’] = 0;
$User[‘longitude’] = 0;
$User = User::create($User);

// comments on 28/09/2019
$User->notify(new UserRegisteredNotification($User));
return back()->with(‘flash_success’,trans(‘user.created_success’,[‘name’=>$User->name]));
}else{
return back()->with(‘flash_error’,’You have no permission for this task’);
}
} catch (Exception $e) {
// return redirect()->route(‘admin.users.index’)->with(‘flash_error’, ‘Whoops! something went wrong.’);
print_r($e->getMessage());
exit;
return back()->with(‘flash_error’, ‘Whoops! something went wrong.’);
}
}

Changed to this..but same error

If you are pasting that huge amount of text, at least try to paste the actual code.

The database field is called phone?

Yes

Ok, I know what is happening

What

Let’s do a exercise.

Please say

Store a valid phone in database,

Now check the database for phone

If for example you have input.
Phone= 1234567890

What you think that you will find in the database?

1234567890

Wrong

+1234567890

You are editing phone number, right?

Yes ..to +91

+91will be added

Datatype should not be varchar for phone

Not number I think you have taken datatype as number