php – 检查CodeIgniter中的重复数据尝试创建回调函数

我有一份登记表.在这里,我可以通过我的自定义检查重复的电子邮件是唯一的回调函数(不要尝试使用is_unique).但它不会返回任何东西.这是我的代码.

控制器 –

public function add_member () {

    $this->load->library('form_validation');

    $post_email = $this->input->post('email_id');
    $this->form_validation->set_rules('email_id', 'Email ID/ Username', 'required|trim|xss_clean|valid_email|callback_check_duplicate_email[' . $post_email . ']');
    $this->form_validation->set_rules('password', 'Your password', 'required|min_length[5]|max_length[12]|matches[confirm_password');
    $this->form_validation->set_rules('confirm_password', 'Password Confirmation', 'required');

    $this->form_validation->set_message('check_duplicate_email', 'This email is already exist. Please write a new email.');

    if ($this->form_validation->run() == FALSE) {
        // validation failed then do that

        $this->load->view('member/reg_form');

    } else {

        $data['email_id'] = $post_email;
        $data['password'] = MD5($this->input->post('password'));

        $insert = $this->Model_member->insert_data_to_db($data);

        if ($insert) {
            $success = "Wao ! You are successfully added to our community.";
            $this->session->set_flashdata('message_success', $success);
            $this->load->view('member/success_page');
        } else {
            $error = "Hey this email is already exists in our community.";
            $this->session->set_flashdata('message_error', $error);
            $this->load->view('member/reg_form');
        }
    }

}

// My callback function
public function check_duplicate_email($post_email) {

    return $this->Model_member->checkDuplicateEmail($post_email);

}

型号 –

 //for checking email existance
 public function checkDuplicateEmail($post_email) {

    $this->db->where('email_id', $email_id);

    $query = $this->db->get('my_registration_table');

    $count_row = $query->num_rows();

    if ($count_row > 0) {
        return TRUE;
    } else {
        return FALSE;
    }
}

// insert data to DB
public function insert_data_to_db($data) {
    return $this->db->insert('my_registration_table', $data);
}

当我尝试使用已存在的电子邮件提交表单时.此功能不会阻止我,也不会显示验证错误消息.有谁会在这里看到有什么问题?等待你的帮助.

解决方法:

您的问题出在模型功能中.看看下面的模型功能.

public function checkDuplicateEmail($post_email) {

    $this->db->where('email_id', $email_id);

    $query = $this->db->get('my_registration_table');

    $count_row = $query->num_rows();

    if ($count_row > 0) {
      //if count row return any row; that means you have already this email address in the database. so you must set false in this sense.
        return FALSE; // here I change TRUE to false.
     } else {
      // doesn't return any row means database doesn't have this email
        return TRUE; // And here false to TRUE
     }
}

试试这个.希望有效.

上一篇:mysql – ON DUPLICATE KEY UPDATE导致外键约束错误


下一篇:mysql – INSERT … ON DUPLICATE KEY UPDATE(要比较的两个键)