我有一个带有唯一列的表。
我的表单验证规则如下所示:
return Validator::make($data, [
'nameEN' => 'required|string',
'nameHE' => 'required|string',
'address' => 'required|string|min:10|unique:clients'
]);
我的问题是,当我编辑一行时,如果我没有更改地址列,则会收到验证错误。
我的编辑功能如下所示:
public function editPost(Request $request,$id){
$client = new Client();
$client->editValidation($request->all())->validate();
$row = $client->where('id',$id)->get()->first();
$update = array();
if(!empty($request->input("nameEN")) && $request->input("nameEN") != $row->nameEN) $update["nameEN"] = $request->input("nameEN");
if(!empty($request->input("nameHE")) && $request->input("nameHE") != $row->nameHE) $update["nameHE"] = $request->input("nameHE");
if(!empty($request->input("address")) && $request->input("address") != $row->address) $update["address"] = $request->input("address");
if(empty($update)) $message = $this->message("info", "Notic: Client {$row->nameEN} was not updated because nothing was changed.");
else if($client->where("id",$row->id)->update($update)){
$message = $this->message("success", "Client {$row->nameEN} was updated.");
} else {
$message = $this->message("danger", "Error: Client {$row->nameEN} was not updated.");
}
$redirect = redirect("clients");
if(isset($message)) $redirect->with("message",$message);
return $redirect;
}
如果我删除unique
根据我的验证规则,我可能会遇到 mysql 错误。
如何解决这个问题?
先感谢您。
来自docs https://laravel.com/docs/5.5/validation#rule-unique:
有时,您可能希望在唯一检查期间忽略给定的 ID,
指示验证器忽略对象的 ID
'address' => 'required|string|min:10|unique:clients,address,'.$id
或者你可以使用Rule
class
use Illuminate\Validation\Rule;
Validator::make($data, [
'address' => [
Rule::unique('clients')->ignore($id),
]
]);
如果你的表使用了 id 以外的主键列名,你可以在调用ignore方法时指定列名:
'address' => Rule::unique('clients')->ignore($id, 'primary_key')
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)