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

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();