Codeigniter用户组Id在数据库中显示错误

Question

在我的codeigniter数据库中，我有2个表，称为user和user_group。当我创建新用户时，我需要它能够从user_group(即administrator)获得第一个id。user_group_id为1

当前获取的第二行是user_group_id number '10'

问题无法获取用户组的第一行ID

这是我的插入模型

public function insert() {
  $password = $this->input->post('password');
  $username = $this->input->post('username');
  $email = $this->input->post('email');
  $data = array(
    'username' => $username,
    'password' => $this->hash($password),
    'status' => "1",
    'ip' => $this->input->ip_address(),
    'user_group_id' => $this->db->insert_id(),
    'date_added' => mdate('%Y-%m-%d %H:%i:%s', now())
  );
  $this->db->set($data);
  $this->db->insert('user');
  return $this->db->insert_id('user_id');
}

Answer 1

我能够按照正常方式获得用户id，并硬编码user_group_id，这就是我在下面的模型上的做法。

public function user() {
            $this->db->escape($username = $this->input->post('username'));
            $this->db->escape($email = $this->input->post('email'));
            $this->db->escape($salt = substr(md5(uniqid(rand(), true)), 0, 9));
            $this->db->escape($password = sha1($salt . sha1($salt . sha1($this->input->post('password')))));    
            $data = array(
                  'username' => $username,
                  'password' => $password,
                  'status' => "1",
                  'salt' => $salt,
                  'ip' => $this->input->ip_address(),
                  'user_group_id' => "1",
                  'date_added' => mdate('%Y-%m-%d %H:%i:%s', now())
            );
            $this->db->set($data);
            $this->db->insert('user');
            return $this->db->insert_id();
      }