Breaking News: Grepper is joining You.com. Read the official announcement!

Laravel Request validation Multiple column Unique

Add Answer

Yucky Yak answered on October 23, 2020 Popularity 2/10 Helpfulness 1/10

answer Laravel Request validation Multiple column Unique

related laravel unique validation on multiple columns

related Laravel Unique Multiple Column validation

related unique validations for multiple columns laravel

Laravel Request validation Multiple column Unique

Comment

return [
    'supplier_id' => 'required|exists:suppliers,id',
    'invoice_number' => 'required|string|unique:your_table_name,invoice_number,NULL,id,invoice_date,' . request('invoice_date'),
    'invoice_date' => 'required|date|date_format:Y-m-d',
    'remark' => 'nullable|string',
    'total_ramle' => 'required|numeric',
    'total_labor_usd' => 'required|numeric',
    'with_gold' => 'required|boolean',
    'with_silver' => 'required|boolean',
    'with_diamond' => 'required|boolean',
    'cash_usd' => 'required|numeric',
    'ramle_gold' => 'required|numeric',
    'ramle_usd' => 'required|numeric',
], [
    'invoice_number.unique' => 'An invoice with this number and date already exists.',
];

Popularity 2/10 Helpfulness 1/10 Language php

Source: chat.openai.com

Tags: php unique

Link to this answer
Share Copy Link

Contributed on Apr 04 2024

Yucky Yak

0 Answers Avg Quality 2/10

Closely Related Answers

laravel unique validation on multiple columns

Comment

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

Popularity 7/10 Helpfulness 4/10 Language php

Source: laracasts.com

Tags: laravel multiple-columns m

Link to this answer
Share Copy Link

Contributed on Sep 22 2022

Inquisitive Ibis

0 Answers Avg Quality 2/10

laravel unique validation on multiple columns

Comment

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

Popularity 9/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Oct 23 2020

Lokesh003

0 Answers Avg Quality 2/10

Laravel Unique Multiple Column validation

Comment

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

Popularity 10/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on May 29 2022

Hasan Rahman

0 Answers Avg Quality 2/10

unique validations for multiple columns laravel

Comment

public function rules(): array
{
  return [
        'date' => [
                    'required',
                    'unique:expenses,date',
                    Rule::unique('expenses', 'date')->where('user_id', $this->input('user_id')),
                ],
        ];
        
}

public function messages()
{
    return [
        'date.unique' => 'Expense for selected user on selected date already exists.',
    ];
}

Popularity 5/10 Helpfulness 2/10 Language php

Source: laraveldaily.com

Tags: laravel multiple-columns php unique

Link to this answer
Share Copy Link

Contributed on May 30 2023

Isaac

0 Answers Avg Quality 2/10

Laravel Request validation Multiple column Unique

Contents

More Related Answers

Laravel Request validation Multiple column Unique

Closely Related Answers

laravel unique validation on multiple columns

laravel unique validation on multiple columns

Laravel Unique Multiple Column validation

unique validations for multiple columns laravel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.