How to overwrite a record in the database if the record already exists?

Question

Laravel

There is a list of employees. Each has a unique IP address.



When editing an employee (for example, changing the name or phone number), the record is not saved, indicating that such an ip already exists (although the ip has not been changed and it is unique in the database), and I just need to resave the same ip address


here is the action that handles saving records in the database

public function update(Request $request, $id){
        $rules = [
            'vts' => 'numeric|nullable',
            'gts' => 'numeric|nullable',
            'mobile' => 'numeric|nullable',
            'ip_wks' => 'unique:workers|nullable',
            'ip_int' => 'unique:workers|nullable'
        ];

        $messages = [
            'vts.numeric' => 'Поле должно содержать только цифры',
            'gts.numeric' => 'Поле должно содержать только цифры',
            'mobile.numeric' => 'Поле должно содержать только цифры',
            'ip_wks.unique' => 'IP адрес уже существует',
            'ip_int.unique' => 'IP адрес уже существует',
        ];

        $validateData = Validator::make($request->all(), $rules, $messages)->validate();

        $worker = Worker::find($id);
        $worker->update($request->all());
        return redirect(session('links')[2])->with('success', 'Данные успешно сохранены');
    }

Answer 1

Something like

use Illuminate\Support\Facades\Validator;
use Illuminate\Validation\Rule;
///////
Validator::make($data, [
            'vts' => 'numeric|nullable',
            'gts' => 'numeric|nullable',
            'mobile' => 'numeric|nullable',
            'ip_wks' => Rule::unique('workers')->ignore($id)->nullable(),
            'ip_int' => Rule::unique('workers')->ignore($id)->nullable()
]);