<? //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 "<html><head><title>计数器</title></head>"; echo "你是第" .$num."访问者<BR>"; echo "今天你第".$click."次点击<BR>"; echo "今天总点击".$total."次<BR>";
/* 表： 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) ); */ ?>
