Search
 
SCRIPT & CODE EXAMPLE
 

PHP

laravel validation unique two columns

[
     'column_1' => 'required|unique:TableName,column_1,' . $this->id . ',id,colum_2,' . $this->column_2
]
Comment

unique check with multiple columns laravel validation

'name' => 'unique:table,field,NULL,id,field1,value1,field2,value2,field3,value3'
Comment

laravel unique validation on multiple columns

'mobile_no' 
  => 'unique:users,mobile_no,NULL,id,country_id,'.request('country_id');
Comment

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',
Comment

unique check two clolumn in laravel validation

'data.ip' => ['required', 'unique:servers,ip,'.$this->id.',NULL,id,hostname,'.$request->input('hostname')]
Comment

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
);
Comment

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>"
Comment

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,
    ];
}
Comment

unique check two clolumn in laravel validation

'data.ip' => ['required', 'unique:servers,ip,'.$this->id.','.$request->input('id').',id,hostname,'.$request->input('hostname')]
Comment

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);
})
Comment

PREVIOUS NEXT
Code Example
Php :: laravel observer check if field changed 
Php :: join multiple tables in laravel eloquent 
Php :: wordpress get page number 
Php :: laravel composite unique key 
Php :: How to JSON encode a PHP array 
Php :: print only some characters of a string in php 
Php :: laravel handle queryexception 
Php :: delete multiple row by model in laravel 
Php :: how to get last id in database codeigniter 4 
Php :: comment in php 
Php :: laravel log path 
Php :: php cheatsheet 
Php :: php curl get response body 
Php :: php convert to boolean 
Php :: remove element from xml on php 
Php :: subdomain in laravel and xampp 
Php :: factory laravel 
Php :: reset array keys php 
Php :: laravel where multiple conditions on single colmn 
Php :: send data from php to python 
Php :: laravel use function from another controller 
Php :: update laravel .env variables dynamically 
Php :: php get all in object as array 
Php :: htmlspecialchars (PHP 4, PHP 5, PHP 7, PHP 8) htmlspecialchars — Convert special characters to HTML entities 
Php :: Wordpress disable admin bar to users except admin 
Php :: failed to open stream permission denied in php 
Php :: laravel db raw query execute 
Php :: php artisan storage:link not working 
Php :: Update Query in Codeigniter Using Multiple Where Condition 
Php :: heredoc php 
ADD CONTENT
Topic
Content
Source link
Name
8+2 =