php - 我怎样才能确保没有重复的条目被张贴到表中

Question

值通过动态表添加到数据库并使用 codeigniter 发布:

$counter = count($this->input->post('mail_group'));
for($x = 0; $x < $counter; $x++ ){
    $this->db->insert('mail_groups_req', [
        'mail_groups_mail_group_id' => $this->input->post('mail_group')[$x],
        'requests_request_id'       => $request_id,
        'requests_uars_uars_id'     => $this->input->post('requestor_id'),
        'requests_users_user_id'    => $user_id,
    ]);
}

如何确保没有重复的条目被发布到表中？

Answer 1

有一个内置的验证规则:is_unique。 https://www.codeigniter.com/user_guide/libraries/form_validation.html#rule-reference

Returns FALSE if the form element is not unique to the table and field name in the parameter. Note: This rule requires Query Builder to be enabled in order to work.

$this->form_validation->set_rules('mail_group', 'Mail Group', 'required|is_unique[users.mail_group]');