改进的IP计数器

//require (’common.inc’);  

$arr_request=array();  

if (count($HTTP_GET_VARS))  

    {  

    while (list($key,$value)=each($HTTP_GET_VARS))  

    {  

        $arr_request[strtolower($key)]=$value;  

    }  

}  

if (count($HTTP_POST_VARS))  

{  

    WHILE (list($key,$value)=each($HTTP_POST_VARS))  

    {  

        $arr_request[strtolower($key)]=$value;  

    }  

}  

$link=@mysql_connect("localhost","kong","kong");  

mysql_select_db("mywebdb");

$ip=$REMOTE_ADDR;  

$current=getdate(time());  

$day=$current["mday"];  

$query="select * from addcount where day=\"$day\"";

$result=@mysql_query($query);

if(!$num=@mysql_num_rows($result))

    $num=1;

while($row=@mysql_fetch_row($result))

{  

    if (strcmp($ip,$row[1])==0)  

    {  

        $i=1;

        $id=$row[0];

        $click=$row[3]+1;

        $up="update addcount set click_count=click_count+1 where id=$id";  

        $result2=@mysql_query($up);

//        break;

    }  

    $total+=$row[3];

}  

$total++;

if(!$i){

    $query1="insert into addcount (ip,day,click_count )values ('$ip','$day',1)";  

    mysql_db_query("mywebdb",$query1,$link);  

    $click=1;

}

echo "";

    echo "你是第" .$num."访问者
";

    echo "今天你第".$click."次点击
";

    echo "今天总点击".$total."次
";



/*

表：  

addcount  

CREATE TABLE addcount (

   id int(6) DEFAULT '0' NOT NULL auto_increment,

   ip char(20) NOT NULL,

   day int(2) NOT NULL,

   click_count int(3) NOT NULL,

   PRIMARY KEY (id)

);

*/

?>