In this article, i will let you know how to make unique validation with soft delete in laravel 5.6 application.
Actually, when i was new with soft delete and i require to add unique validation with my email column at that time i fetched this type of issue. At that time i just plane to write manually database query for check unique validation and i done my task. But after some day i was free on Saturday and i search on google about this, after some research i found best solution for unique validation with soft delete.
I added both example below code, One is for create time and another is on edit time on controller validation.
On Create Method:
public function store(Request $request)
{
$request->validate([
'name'=>'required|unique:form_types,name,NULL,id,deleted_at,NULL',
]);
// Write your code here
}
On Update Method:
public function update(Request $request, $id)
{
$request->validate([
'name'=>'required|unique:form_types,name,'.$id.',id,deleted_at,NULL',
]);
// Write Code here
}
You can see both way.
I hope you found your best....