Mysql Timestamp mere eller mindre end 24 timer
Prover paa at faa mit script til at goere noget hvis et timestamp er over 24 timer og goere noget andet hvis under 24 timer.Men kan ski ikke faa det til at virke
Script:
<?php
error_reporting(E_ALL ^ E_NOTICE);
define('IN_SCRIPT',1);
/* Get settings from the settings.php file */
require 'settings.php';
/* Get database connection from the database.php file */
require 'database.php';
/* Start user session or output an error */
session_name('CCOUNT');
if (!session_start()) {
error('Cannot start a new PHP session. Please contact server administrator or webmaster!');
}
function curPageURL() {
$pageURL = 'http';
if ($_SERVER["HTTPS"] == "on") {$pageURL .= "s";}
$pageURL .= "://";
if ($_SERVER["SERVER_PORT"] != "80") {
$pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"];
} else {
$pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];
}
return $pageURL;
}
mysql_select_db("awc24h_links", $con);
$user_id = $settings['user_id'];
if ($result = mysql_query("Select * FROM Log where user_id='".$user_id."' AND url='".curPageURL()."' AND last_visit='< NOW() - INTERVAL 1 DAY'"))
// now() -interval 1 day
echo '24 hours have passed';
// $result = mysql_query("SELECT * FROM Click order by RANDOM() LIMIT 1");
else
// header("Location: show.php");
echo 'under 24 hours since last click';
?>
Databasen last_visit er = 2012-10-10 16:54:29, altsaa under 24 timer siden.
Min side siger 24 hours have passed