~~~
<?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;
}
?>
~~~
