Level 104
Your syntax is incorrect:
'date' => "required|unique:holidays'
The format is unique:table_name,column_name - you don't explicitly give it the value
Dec 21, 2021
9
Level 13
unique date validation
how to unique date validation on laravel
here is my code
public function store(Request $request)
{
$this->validate($request , [
'date' => "required|unique:holidays".$request->date
]);
try {
$holiday = new Holiday();
$holiday->date = $request->get('date') ?? null;
$holiday->save();
return response()->json(['message' => 'Holiday successfully added.'], 200);
} catch (Exception $e) {
return redirect()->route('holiday.index')->with('error', $e->getMessage());
}
}
i try but date cannot unique validate can you please suggest how to do it
Level 13
@tykus yes sir i change this but not getting any error
'date' => "required|unique:holidays,date"
can i missing someting to add
Level 13
@tykus i also try this way but not generate validation message
'date' => ["required", Rule::unique("holidays")->where(function ($query) use ($request){
return $query->where('id',$request->id)
->where('date', Carbon::parse($request->date)->format("Y-m-d"));
})->whereNull('deleted_at')]
1 like
Level 104
@van1310 why is the id relevant here?
Can you check how the unique query is looking? If you have debugbar; use that, otherwise dump the query:
public function store(Request $request)
{
\DB::listen(fn ($query) => dump([$query->sql, $query-bindings]));
$this->validate($request , [
'date' => "required|unique:holidays"
]);
// etc...
Level 13
here is output of query
array:2 [
0 => "select count(*) as aggregate from `holidays` where `date` = ? and `id` <> ?"
1 => array:2 [
0 => "23-12-2021"
1 => "23-12-2021"
]
]
Level 104
@van1310 you have a date string for an id binding??? What does your rule currently look like to produce that?
Level 13
@tykus no sir
here is my rule
$this->validate($request , [
'date' => "required|unique:holidays,date,".Carbon::parse($request->date)->format('Y-m-d');
]);
Level 13
@tykus i found solution
here is my code for validation
$request['date'] = Carbon::parse($request->date)->format("Y-m-d");
$this->validate($request , [
'date' => ["required", Rule::unique("holidays")->where(function ($query) use ($request){
return $query->whereDate('date', $request->date);
})->whereNull('deleted_at')]
]);
Level 9
I ran into this issue on Laravel 11 too.
I think because each database driver handle date migration datatype differently.
In my case SQLite (I think it) has smallest date datatype as YYYY-MM-DD HH:MM:SS so, the input YYYY-MM-DD will be always unique when compares to value in the table.
My solution is:
'date' => ['required', 'date', function ($attribute, $value, $fail) {
if (Holiday::query()->where('date', Carbon::create($value))->exists()) {
$fail('the date is already taken.');
}
}],
1 like
Please or to participate in this conversation.