Level 102
Check my answer (second solution) on how to do it
https://laracasts.com/discuss/channels/code-review/validation-rule-for-unique-on-2-fields
Mar 15, 2020
8
Level 3
Laravel unique validation rule
Hi there I have two fields one for country code and one for phone number I want to make validation to make the both fields unique together.
public function rules()
{
return [
'countryCode' => ['required', 'between:2,4'],
'phone' => ['required', 'digits:9', 'unique:devices,phone],
];
}
I have two fields in the database one for country code, one for the phone number
I need the validation to check if the combination (country code with phone) is unique e.g +200102030 not the phone number only 0102030
Level 3
I checked the second approach but I didn't understand what you mean when you're using where function? it could be better if you submit some explanation
Level 102
Give this a shot
$rules = [
'phone' => [Rule::unique('devices')->where(function ($query) use ($request) {
return $query->where('phone', $request->input('phone'))->where('countryCode', $request->input('countryCode'));
}),'required', 'digits:9']
];
Level 73
I have done this in my app Where the combination between the first and the last name of an author must be unique.
'first_name' => 'required|unique:authors,first_name,' . null . ',id,last_name,'. $request->last_name
It should be quite easy for you to change the name of the fields to suit your needs.
1 like
Level 2
@ahmednaser you need to use validator
use Illuminate\Support\Facades\Validator;
use App\users;
$validator = Validator::make($request->all(), [
'phone' => ['required', 'string', 'email', 'max:255', 'unique:users'], //users is table name and phone is column name//
]);
Level 3
Level 73
@ahmednaser Mark one of the as best reply to show that the thread is solved :)
Level 1
use this code :
$validator= $request->validate([
'title' => 'required|min:3|unique:categories,title,'.$category->id,
'description' => 'required',
]);
Please or to participate in this conversation.