php - is_unique 在 codeigniter 中用于编辑功能

Question

我有要求，我可以在新的添加功能中验证唯一值

$this->form_validation->set_rules('email','Email','required|valid_email||is_unique[users.Email]');

它的工作但在编辑功能它不工作..我已经写了回调函数来检查独特的电子邮件。这是我在编辑功能中编写的代码

$this->form_validation->set_rules('email','Email','required|valid_email|callback_check_email');

function check_username($email)
    { 
        $return_value = $this->user_model->check_email($email);
        if ($return_value)
        {
            $this->form_validation->set_message('email_check', 'Sorry, This username is already used by another user please select another one');
            return FALSE;
        }
        else
        {
        return TRUE;
        }
    }

和用户模型

function check_mail($email)
    { 
        $sql = "SELECT users.Email
                FROM users
                WHERE 
                $email = users.Email
                ";

        $result = $this->db->query($sql)->result_array();
        return $result;

    }

我无法验证唯一的电子邮件

Answer 1

在你的 Controller 中尝试这段代码(编辑 View )

    $original_value = $this->db->query("SELECT EMAIL FROM users WHERE id = ".$id)->row()->EMAIL ;
    if($this->input->post('username') != $original_value) {
       $is_unique =  '|is_unique[users.EMAIL]';
    } else {
       $is_unique =  '';
    }
$this->form_validation->set_rules('username', 'User Name', 'required|min_length[3]|max_length[30]|trim|xss_clean'.$is_unique);