控制器中
$this->load->helper('captcha');$ip = $this->input->ip_address();
//$check_ip_address = $this->User_model->check_ip_address($res['uid']);
//$ip_info是一个对象country province city 存入数据库
$this->User_model->getipaddress($ip,$res);
model中
public function getipaddress($ip,$res)
{
$ipContent = file_get_contents("http://int.dpool.sina.com.cn/iplookup/iplookup.php?format=js&ip=".$ip);
$jsonData = explode("=",$ipContent);
$jsonAddress = substr($jsonData[1], 0, -1);
$ip_info=json_decode($jsonAddress);
//var_dump($ip_info->country);exit;
//return $ip_info;
$data = array(
'uid' => $res['uid'],
'ip' => ip2long($ip),
'country' => $ip_info->country,
'province' => $ip_info->province,
'city' => $ip_info->city
);
$this->db->insert('ip_address', $data);
}
//需要修改 判断是否是第一次登陆 避免重复插入 如果需要 非首次登陆可以进行update
public function check_ip_address($uid)
{
$res = $this->db->where('uid',$uid)
// ->$this->db->select('login_ip')
->get('ip_address');
$info = $res->row_array();
//若不存在返回null
return $info;
}