{"id":24091,"date":"2016-01-23T02:00:20","date_gmt":"2016-01-22T20:30:20","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-how-can-i-make-a-countdown-timer-that-goes-past-the-60minutes\/"},"modified":"2016-01-23T02:00:20","modified_gmt":"2016-01-22T20:30:20","slug":"solved-how-can-i-make-a-countdown-timer-that-goes-past-the-60minutes","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-can-i-make-a-countdown-timer-that-goes-past-the-60minutes\/","title":{"rendered":"[Solved] how can i make a countdown timer that goes past the 60minutes"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

The current minute is never an issue. You are concerned with the duration<\/em> since last blocked, not with “what time was that”:<\/p>\n

block_user.php:<\/p>\n

<?php\n$now = new DateTime();\nwrite_block_into_database($ip_address, $now->format('Y-m-d H:i:s'));\n?>\n<\/code><\/pre>\n
check_block.php<\/p>\n
<?php\n$sql=\"SELECT 1 FROM sometable WHERE ip_address=? AND DATE_ADD(blocked_at, INTERVAL 1 HOURS) >= NOW()\";\nif(get_result($sql, $ip_address)) { \n   \/\/ this address is blocked\n} else {\n   \/\/ no recent block found\n}\n<\/code><\/pre>\n
Or, if you want to do the comparison in PHP:<\/p>\n
check_locally.php:<\/p>\n
<?php\n$sql = \"SELECT blocked_at FROM sometable WHERE ip_address=?\";\n$db_row = get_row($sql,$ip_address);\nif ($db_row) {\n    $blocked = new DateTime($db_row->blocked_at);\n    $blocked->modify('+1 hour');\n    $now = new DateTime();\n\n    if ($blocked >= $now) {\n       \/\/ still blocked\n    } else {\n       \/\/ was blocked earlier, no more\n    }\n} else {\n    \/\/ not blocked\n}\n<\/code><\/pre>\n
In other words: “if I take the time the IP was blocked and add one hour, is now still before that point in time?”<\/p>\n
Example: <\/p>\n