php限制24小时,将函数的访问限制为每24小时PHP + MySQL一次(Limit the access of a function to once every 24 hours PHP + My...-CSDN博客

将函数的访问限制为每24小时PHP + MySQL一次(Limit the access of a function to once every 24 hours PHP + MySQL)

我想根据用户的IP地址将我创建的功能的访问限制为每24小时一次。如果超过24小时，我还希望PHP脚本删除MySQL记录。

如果用户已在24小时内使用过该功能，请向他们显示一条消息并阻止脚本继续运行。

如果用户已经使用了该功能但是自从使用该功能已经过去了24小时，则删除MySQL记录并让脚本继续运行。

我迷路了，你可以看到我也遗漏了一些删除旧记录的陈述(-24小时)。

有人能为我提供一个如何做到这一点的例子吗？谢谢

I would like to limit the access of a function i've created to once every 24 hour based on the users IP address. I would also like the PHP script to delete the MySQL record if it's older than 24 hours.

If the user already has used the function within 24 hours, show them a message and prevent the script from continue running.

If the user already has used the function but 24 hours has passed since he used the function, delete the MySQL record and let the script continue running.

I'm lost and as you can see i am also missing some statements for deleting old records (-24 hours)..

Could anyone provide me with an example of how to do this? Thanks

原文：https://stackoverflow.com/questions/41288794

更新时间：2020-02-14 07:05

最满意答案

获取客户端的IP地址，并在记录不存在时将其与当前日期和时间一起存储。

获取记录并将24小时添加到其日期和时间值，并在每次执行脚本时使用当前日期和时间进行检查。

您需要if else条件语句来检查24小时时间是否结束。基于此，您将控制您想要的功能的执行。

我想我不想写很多理论。在这里，我编写了代码看起来像这样的模式：

if(!$record_in_db) {

// create record with the client's ip address and the current date and time

// invoke the function you want - This is the code to trigger the function first time for the new IP address

} else {

// fetch_record_from_db

// add 24 hours to its date and time value

// check it with current date and time

$record_date_time = new DateTime('22-12-2016 22:45:20'); // this value should be fetched from database

$record_date_time_by_24_hours = $record_date_time->modify('+1 day');

$current_date_time = new DateTime(date('d-m-Y H:i:s', strtotime('now')));

$date_time_diff = $current_date_time->diff($record_date_time_by_24_hours);

if($date_time_diff->invert == 0) {

// Do something

} else {

// update the date and time of the record to NOW which is current date and time

// invoke the function you want

}

我不能写你整个代码。我只能给你一些提示。您需要从中构建代码。希望我给你正确的提示，可以帮助你。

Get client's IP address and store it with current date and time if the record doesn't exist.

Fetch the record and add 24 hours to its date and time value and check it with the current date and time every time the script is executed.

You need if else conditional statements to check if the 24 hours time is over or not. Based on that, you will control the execution of the function you want to.

I think I don't want to write much of theory. Here, I've written the pattern what the code looks like:

if(!$record_in_db) {

// create record with the client's ip address and the current date and time

// invoke the function you want - This is the code to trigger the function first time for the new IP address

} else {

// fetch_record_from_db

// add 24 hours to its date and time value

// check it with current date and time

$record_date_time = new DateTime('22-12-2016 22:45:20'); // this value should be fetched from database

$record_date_time_by_24_hours = $record_date_time->modify('+1 day');

$current_date_time = new DateTime(date('d-m-Y H:i:s', strtotime('now')));

$date_time_diff = $current_date_time->diff($record_date_time_by_24_hours);

if($date_time_diff->invert == 0) {

// Do something

} else {

// update the date and time of the record to NOW which is current date and time

// invoke the function you want

}

I can't write you the whole code. I could only give you some hints. You need to build the code from it. Hope I've given you right hints that could help you.

2016-12-22