DekGenius.com
PHP
laravel validation unique two columns
[
'column_1' => 'required|unique:TableName,column_1,' . $this->id . ',id,colum_2,' . $this->column_2
]
unique check with multiple columns laravel validation
'name' => 'unique:table,field,NULL,id,field1,value1,field2,value2,field3,value3'
laravel unique validation on multiple columns
'mobile_no'
=> 'unique:users,mobile_no,NULL,id,country_id,'.request('country_id');
laravel 8 validation unique 2 columns
// in my case, just add more unique rule
'phone1' =>'string|unique:tbl_users,phone1|unique:tbl_users,phone2|different:phone2|min:2',
'phone2' =>'string|unique:tbl_users,phone2|unique:tbl_users,phone1|different:phone1|min:2',
unique check two clolumn in laravel validation
'data.ip' => ['required', 'unique:servers,ip,'.$this->id.',NULL,id,hostname,'.$request->input('hostname')]
laravel validation two columns unique
$messages = [
'data.ip.unique' => 'Given ip and hostname are not unique',
];
Validator::make($data, [
'data.ip' => [
'required',
Rule::unique('servers')->where(function ($query) use($ip,$hostname) {
return $query->where('ip', $ip)
->where('hostname', $hostname);
}),
],
],
$messages
);
Laravel Unique Multiple Column validation
'name' => 'required|max:150|unique:course_lessons,name,NULL,id,course_id,' . request('course_id'),
"<input_filed_name>" => "valiadtionRule"|"ValidationRule"|"unique:<tableName>,<validateableField>,<ignoreableID>,<tablePrimaryKey>,<column1>,<column1Value>,<column2>,<column2Value>"
Laravel unique cheque using multiple column
public function rules()
{
return [
'column_1' => 'required|unique:TableName,column_1,' . $this->id . ',id,colum_2,' . $this->column_2 . ',colum_3,' . $this->column_3,
];
}
unique check two clolumn in laravel validation
'data.ip' => ['required', 'unique:servers,ip,'.$this->id.','.$request->input('id').',id,hostname,'.$request->input('hostname')]
laravel unique validation on multiple columns
'exam_category_id' => Rule::unique('exams')->where(function ($query) use ($request) {
return $query->where('exam_name', $request->exam_name)
->where('exam_year', $request->exam_year)
->where('student_id', $request->student_id);
})
© 2022 Copyright:
DekGenius.com