PHP/MYSQL IP 检查/记录器

Question

好的，我有一个我的世界服务器，我正在为其制作一个投票脚本。

我需要一种方法来检查 mySQL 中的用户 ip。 如果不存在，则会将该 IP 放入数据库中，并在数据库中 24 小时后将其删除。

如果有人可以帮助我做到这一点，那就太好了，谢谢

Answer 1

网上有很多关于如何实现这一点的教程，因此我不会给你代码。只需一些提示即可帮助您入门。

在 PHP 中，您可以从 $_SERVER 超全局中获取用户的 ip 地址

$ip = $_SERVER['REMOTE_ADDR'];

来检查它是否存在于您的表中

$query = sprintf("SELECT COUNT(*) FROM yourtable WHERE `ip` = '%s'", mysql_real_escape_string($ip));

如果不存在，则使用 INSERT 命令存储它带有时间戳。

至于 24 小时后删除，您可以设置一个 cron 作业，每小时左右运行一次表，并删除所有已过期的条目。但是，不删除这些条目会更容易。相反，当用户投票时，只需检查他上次投票的时间戳即可。如果距离上次投票已经过去了 24 小时，则只需更新时间戳即可。

基本上，工作流程是：

1. Get users's IP address.
2. Does this IP exist in table? 
  2a. If no, let user vote, and enter his ip in the table along with the current time in the timestamp column
  2b. If yes, get the timestamp of his last vote. Has it been 24 hours since his last vote?
    2b.a. If yes, let user vote and update timestamp column with current time.
    2b.b. If no, do not let user vote / reject his vote. Leave timestamp column unchanged.

Answer 2

最简单的方法是执行以下

$ip = $_SERVER['REMOTE_ADDR'];
// Run cleanup for given IP
$result = mysql_query("SELECT * FROM table 
             WHERE `ip`='$ip' AND `timestamp` > NOW() - 24*3600");  
if (mysql_num_rows($result)==0) 
// there is no record within the last 24h, let insert a new one
{  
 mysql_query("INSERT INTO table SET `ip`='$ip', `timestamp` = NOW()");  
 echo "Thank you for your vote!";
}
else echo "You may vote only once in 24 hours";
// run total cleanup query from time to time
if (rand(1,5)<2) mysql_query("DELETE FROM table 
                             WHERE `timestamp` < NOW() - 24*3600");  

操作：如果您有不同的投票，则每个投票都应该有不同的唯一 ID。例如，MySQL 表之前有两列 ip 和 timestamp，应该再多一列 voteid。在这种情况下，上面的代码将更改为

// voteid should be somehow set to the id of the voting. 
// for example by GET request
$voteid = intval($_GET['voteid']);
$ip = $_SERVER['REMOTE_ADDR'];
// Run cleanup for given IP
$result = mysql_query("SELECT * FROM table 
   WHERE `ip`='$ip' AND `voteid`='$voteid` AND `timestamp` > NOW() - 24*3600");  
if (mysql_num_rows($result)==0) 
// there is no record within the last 24h, let insert a new one
{  
   mysql_query("INSERT INTO table SET `ip`='$ip', 
                `voteid`='$voteid', `timestamp` = NOW()");  
   echo "Thank you for your vote!";
}
  else echo "You may vote only once in 24 hours";
  // run total cleanup query from time to time
 if (rand(1,5)<2) mysql_query("DELETE FROM table 
                                 WHERE `timestamp` < NOW() - 24*3600");