当前位置：首页 → 问答吧 → php防灌水计数器，不一定好哈，大家补充

php防灌水计数器，不一定好哈，大家补充

时间：2010-01-25

来源：互联网

<?
//------[ 基本设定 ]------
         $mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "";
$mysql_database = "jackie";

//取IP
$ip=getenv('REMOTE_ADDR');
//echo $ip;

//建立连线
$conn=mysql_connect( $mysql_server_name,$mysql_username,$mysql_password );

$sql= "SELECT * FROM `counter` where ip = '$ip' and name='jackie1';";

$result=mysql_db_query($mysql_database,$sql,$conn);

$row=mysql_fetch_row($result);

//print_r($row);

mysql_free_result($result);

if(!$row)
{
//------[ 插入 ]-------
  $conn=mysql_connect( $mysql_server_name,$mysql_username,$mysql_password );

  $sql= "INSERT INTO `counter` ( `new` , `name` , `ip` , `time_at` ) VALUES ('1', 'jackie1', '$ip', NOW( ) );";

  mysql_select_db($mysql_database,$conn);

  $result=mysql_query($sql);

  mysql_close($conn);
}
else
{
  $conn=mysql_connect( $mysql_server_name,$mysql_username,$mysql_password );

$sql= "SELECT TIME_To_SEC( NOW( ) ) - TIME_TO_SEC( time_at ) FROM`counter` WHERE ip = '$ip' AND name = 'jackie1' ORDER BY `TIME_To_SEC(NOW( ) ) - TIME_To_SEC( time_at )` ASC;";

  $result=mysql_db_query($mysql_database,$sql,$conn);

  $row=mysql_fetch_row($result);

  //print_r($row);

  mysql_free_result($result);

    if($row[0]>1)
    {
     $conn=mysql_connect( $mysql_server_name,$mysql_username,$mysql_password );

     $sql= "INSERT INTO `counter` ( `new` , `name` , `ip` , `time_at` ) VALUES ('1', 'jackie1', '$ip', NOW( ) );";

     mysql_select_db($mysql_database,$conn);

     $result=mysql_query($sql);

     mysql_close($conn);
    }
}
//-----[ 查询 ]------
$conn=mysql_connect( $mysql_server_name,$mysql_username,$mysql_password );

$sql= "SELECT count(*) FROM `counter` where name='jackie1';";

$result=mysql_db_query($mysql_database,$sql,$conn);

$row=mysql_fetch_row($result);

//print_r($row);

mysql_free_result($result);

for($i=0;$i < strlen($row[0]);$i++)
{
  $number1=substr($row[0],$i,1);

  $str.="<img src=\"number/$number1.gif\" width=68 height=68>";
}
?>
<html>
<head>
<style type="text/css">

</style>
</head>
<body>
<div align="center"><span class="STYLE2">大熊网</span></div>
<p align="center"> </p>
<p align="center"><span class="STYLE7">你已经是第<?=$str?>个访问这个页面了！！！！</span></p>
<p align="center" class="STYLE5">此计数器用图片表示，时间间隔1秒，可以刷新。</p>
<p align="center"> </p>
<p> </p>
<p> </p>
<p align="center" class="STYLE3"> </p>
</body>
</html>

作者: php华南培训发布时间: 2010-01-25

呵呵,和孙仲岳老师讲的一样嘛.

作者: 刹那芳华网发布时间: 2010-01-25