CI数据库的相关操作&获取客户端IP

来源：互联网发布：itudou官方下载mac 编辑：程序博客网时间：2024/05/20 15:39

1.插入操作

$data = array(    'uid' => $res['uid'],    'login_ip' => $res['login_ip'],    'login_time' => $res['login_time'],    'logout_ip' => $res['login_ip'],    'logout_time' => $res['login_time']);// $this->db->where('uid', $res['uid']);$this->db->insert('login_history', $data);

2.更新操作

$data2 = array(    // 'uid' => $res['uid'],    'login_ip' => $res['login_ip'],    'login_time' => $res['login_time'],    'logout_ip' => $old_ip['0']['login_ip'],    'logout_time' => $old_time['0']['login_time']);$this->db->where('uid',$res['uid']);$this->db->update('login_history', $data2);

3. 查询操作

$res = $this->db->where('uid',$uid)   // ->$this->db->select('login_ip')    ->get('login_history');$info = $res->row_array();return $info;

$res = $this->db->where('uid', $uid)    ->get('login_history');return $res->row_array();

4.获取客户端IP

$this->load->helper('captcha');$res['login_ip'] = $this->input->ip_address();

0 0