如何在laravel5中对名字和姓氏的组合添加唯一的验证? [英] How to add unique validation on combination of firstname and lastname in laravel5?

问题描述

我需要验证用户表中没有重复组合的(名字和姓氏).例如:-表中已经存在firstname = dc lastname = patel.我下次必须阻止相同的条目.

I need to validate user table in which not repeated combination of (firstname and lastname). for example:- firstname=dc lastname=patel already exist in table. i need to prevent same entry next time.

推荐答案

最后，我对此有一个完美的解决方案.

Finally I have perfect solution for this.

$validationRule = ['first_name' => 'required','last_name'=>'required'];
            $validationMsg = ['first_name.required' => 'First Name is required', 'last_name.required' => 'Last Name is required'];

            $validation = Validator::make(['first_name' => $firstName, 'last_name' => $lastName], $validationRule, $validationMsg);

                $validation->after(function ($validation) use ($firstName, $lastName) {
                    $checkName = User::where('first_name', $firstName)->where('last_name', $lastName)->get();
                    if (count($checkName) > 0) {
                        $validation->errors()->add('first_name', 'User already exists, please enter another user.');
                    }
                });

            if ($validation->fails()) {
                foreach ($validation->errors()->all() as $error) {
                    $message = $error;
                }
                return response(\Helpers::makeAjaxResponse(false, $message));
            } else {
               //Save record code here
            }

这篇关于如何在laravel5中对名字和姓氏的组合添加唯一的验证?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！