PHP初学之防水计数器

来源：互联网发布：matlab粒子群算法编辑：程序博客网时间：2024/06/10 02:50

这是我写的第一个计数器

<?$s_ht="127.0.0.1";$s_user="root";$s_pas="123456";$s_data="ceshi";if (empty($_SERVER['HTTP_X_FORWARDED_FOR'])) { $myip = $_SERVER['REMOTE_ADDR']; $myip = $_SERVER['REMOTE_ADDR'];} else { $myip = explode(',', $_SERVER['HTTP_X_FORWARDED_FOR']); $myip = explode(',', $_SERVER['HTTP_X_FORWARDED_FOR']); $myip = $myip[0]; $myip = $myip[0];}//------链接数据库----------$conn=mysql_connect($s_ht,$s_user,$s_pas);//-----------防止多次刷新判断，下面先进行查询-----------------$sql="select * from `ceshi`.`jishuqi` where ip = '$myip'";$result=mysql_db_query($s_data,$sql,$conn);$row=mysql_fetch_row($result);mysql_free_result($result);if(!$row){$sql="insert into `ceshi`.`jishuqi` ( `jishu`, `ip`, `time_at` ) values ( '1', '$myip', now() )";mysql_select_db($s_data,$conn);$result=mysql_query($sql);mysql_close($conn);}else{$sql="select time_to_sec(now()) - time_to_sec(time_at) from jishuqi where ip='$myip' order by time_to_sec(now()) - time_to_sec(time_at) asc";$result=mysql_db_query($s_data,$sql,$conn);$row=mysql_fetch_row($result);mysql_free_result($result);if($row[0] > 10){$sql="insert into `ceshi`.`jishuqi` ( `jishu`, `ip`, `time_at` ) values ( '1', '$myip', now() )";mysql_select_db($s_data,$conn);$result=mysql_query($sql);}}$sql="select count(*) from `ceshi`.`jishuqi`";$result=mysql_db_query($s_data,$sql,$conn);$row=mysql_fetch_row($result);mysql_free_result($result);$ss="select * from `ceshi`.`jishuqi` order by 3 desc";$cha=mysql_db_query($s_data,$ss,$conn);$guo=mysql_fetch_row($cha);?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>计数器</title><mce:style type="text/css"></mce:style><style type="text/css" mce_bogus="1">.tong {color: #F00;font-size:36px;text-align:center;}.fangwen {color: #008000;font-size:16px;}.teshu {color: #FF8000;}</style></head><body><p></p><p> </p><p class="fangwen"> </p><table width="70%" border="1" align="center"> <tr> <td align="center"><span class="tong"><strong>这是第一个计数器超简单版</strong></span></td> </tr> <tr> <td align="center"><p class="fangwen"> </p> <p class="fangwen">访问此页的有<?=$row[0];?>人(IP,防水版！)</p> <p class="fangwen">防水时间为： 10 秒，你最后访问的时间是：<span class="teshu"> <?=$guo[2];?> </span> 你的IP：<?=$myip?></p></td> </tr></table></body></html>