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 孟德尔随机化结果不一致
  • ¥15 深度学习残差模块模型
  • ¥50 怎么判断同步时序逻辑电路和异步时序逻辑电路
  • ¥15 差动电流二次谐波的含量Matlab计算
  • ¥15 Can/caned 总线错误问题,错误显示控制器要发1,结果总线检测到0
  • ¥15 C#如何调用串口数据
  • ¥15 MATLAB与单片机串口通信
  • ¥15 L76k模块的GPS的使用
  • ¥15 请帮我看一看数电项目如何设计
  • ¥23 (标签-bug|关键词-密码错误加密)