douyi8732 2013-09-09 03:56
浏览 485
已采纳

时间戳:检查是否已有30分钟

I have setup this code, and it does not seem to be working. Basically I put a timestamp in the database, and whenever someone tries to submit something, I check their IP and then the last time they submitted with the timestamp Basically I need to make sure that it has been MORE that 30 minutes before they can post. Here is the code I have soo far...

$ip = $_SERVER["REMOTE_ADDR"];
$chkquery = "SELECT * FROM faucet where ip='$ip' ORDER BY timestamp DESC LIMIT 1;";
$chk = mysql_query($chkquery) or die($chkquery."<br/><br/>".mysql_error());
while($row = mysql_fetch_array($chk, MYSQL_ASSOC)){
    $timestamp = $row['timestamp'];
}
$timenow = time();
$chktime = strtotime($timestamp);
if($chktime <= ($timenow - 1800)) {
    echo "Yay! It has been 30 minutes!";
} else {
    echo "Wait! Its not been 30 minutes";
}

Is there anything I need to change/fix to get this to work? Thanks a lot for the help! The if statement might be reversed, but IDK, and also I end up with Yay! no matter what time it is...

  • 写回答

2条回答 默认 最新

  • dongyunwei8596 2013-09-09 04:07
    关注

    It is not safe to rely on strtotime() as it is defined by the system's timezone settings. You should adjust date.timezone setting or use the date_default_timezone_set() for example:

    date_default_timezone_set('America/New_York');
    ...
    
    if($timenow - $chktime >= 1800) {
        echo "Yay! It has been 30 minutes!";
    } else {
        echo "Wait! Its not been 30 minutes";
    }
    

    EDIT: add the remaining time

    $time_diff = $timenow - $chktime;
    if( $time_diff >= 1800) {
        echo "Yay! It has been 30 minutes!";
    
    } else {
        $remaining = (1800 - $time_diff );
        echo "Wait! Its not been 30 minutes
    ";
        echo "please come back in ".date ( "i:s" , $remaining)." minutes";
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 R语言Rstudio突然无法启动
  • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
  • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
  • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
  • ¥100 为什么这个恒流源电路不能恒流?
  • ¥15 有偿求跨组件数据流路径图
  • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值