~~~
<?php
header("Content-type:text/html;charset=utf-8");
//http://bbs.125.la/forum.php?mod=viewthread&tid=13867543&highlight=php
$server='mysql服务器地址';//msyql服务器
$user_amdin='mysql登陆用户名';//mysql用户名
$password='mysql登陆密码';//mysql密码
$con = mysql_connect($server, $user_amdin, $password);//链接数据库
if (!$con){
exit(mysql_error()."数据配置错误");
}
mysql_query("set names 'utf8'");
mysql_sSELECTt_db('数据库名');
$fwzip=getIP();//获取访问的IP地址
$sql="SELECTT * FROM `数据库名`.`tj` WHERE FWIP='".$fwzip."'";
$jb=mysql_query($sql,$con)or die("Invalid query: " . mysql_error());
$num_result = mysql_num_rows($jb);
if($num_result==1){
$row=mysql_fetch_row($jb);
$jlu=$row['2']+1;
$sql="UPDATE tj SET FWCS='".$jlu."' WHERE FWIP='".$fwzip."'";
$jb=mysql_query($sql,$con)or die("Invalid query: " . mysql_error().'<br>1-1'.$sql);
mysql_close($con);
echo '<span style="color:red">《《《记录增加成功》》》<br>时间:--->'.date('Y-m-d H:i:s').'<br>I P:--->'.$fwzip.'<br>信息:--->'.getIPLoc_QQ($fwzip).'<br>访问--->'.$jlu.'次</span>';
exit;
}
$cxjl=mysql_affected_rows();
if($cxjl==0){
$sql="insert `数据库名_db`.`tj`(`ID`,`FWIP`,`FWCS`,`FWDQ`) values(null,'".$fwzip."','1','".getIPLoc_QQ($fwzip)."')";
$jb=mysql_query($sql,$con)or die("Invalid query: " . mysql_error().'<br>'.$sql);
mysql_close($con);
echo '<span style="color:red"><<<创建记录成功>>><br>当前时间:--->'.date('Y-m-d H:i:s').'<br>当前IP已访问--->1</span>';
exit;
}
function getIPLoc_QQ($queryIP){
$url = 'http://ip.qq.com/cgi-bin/searchip?searchip1='.$queryIP;
$ch = curl_init($url);
curl_setopt($ch,CURLOPT_ENCODING ,'gb2312');
curl_setopt($ch, CURLOPT_TIMEOUT, 10);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true) ;
$result = curl_exec($ch);
$result = mb_convert_encoding($result, "utf-8", "gb2312");
curl_close($ch);
preg_match("@<span>(.*)</span></p>@iU",$result,$ipArray);
$loc = $ipArray[1];
return $loc;
}
function getIP()
{
global $ip;
if (getenv("HTTP_CLIENT_IP"))
$ip = getenv("HTTP_CLIENT_IP");
else if(getenv("HTTP_X_FORWARDED_FOR"))
$ip = getenv("HTTP_X_FORWARDED_FOR");
else if(getenv("REMOTE_ADDR"))
$ip = getenv("REMOTE_ADDR");
else
$ip = "Unknow";
return $ip;
}
?>
~~~
