php 留言板防重新整理

<?php
     
      php 留言板防重新整理效果
      $ip = $_SERVER['REMOTE_ADDR'];
      $conn = mysql_connect($mysql_server_name, $mysql_username, $mysql_password);
      $sql = "SELECT * FROM `my_counter` WHERE ip = '$ip'";
      mysql_select_db($mysql_database, $conn);
      $result = mysql_query($sql);
      $row = mysql_fetch_row($result);
      print_r($row);
     
      if(!$row)   //如果IP沒有出現過就新增
      {
       $sql = "INSERT INTO `my_counter` ( `new`, `ip`, `time_at`) VALUES ('1', '$ip', NOW())";
       $result = mysql_query($sql);
      }
      else        //如果IP出現過
      {
       $sql = "SELECT TIME_TO_SEC( NOW( ) ) - TIME_TO_SEC( time_at ) FROM `my_counter` WHERE `ip` = '$ip'ORDER BY `TIME_TO_SEC( NOW( ) ) - TIME_TO_SEC( time_at )` ASC ";
       $result = mysql_query($sql);
       $row = mysql_fetch_row($result);
       print_r($row);
      
       if($row[0]>5)   //如果IP出現過，則看他有沒有超過5秒
       {
         $sql = "INSERT INTO `my_counter` ( `new`, `ip`, `time_at`) VALUES ('1', '$ip', NOW())";
         $result = mysql_query($sql);
       }
      }
     
       $sql = "SELECT COUNT(*) FROM `my_counter`";
       $result = mysql_query($sql);
       $row = mysql_fetch_row($result);
       print_r($row);
       mysql_free_result($result);
       mysql_close($conn);
?>