comparing time in if statement

[cloudll]

Does anybody know how I would turn this into functioning code.

 

if $_SERVER[REQUEST_TIME] is 15 minutes greater than $time_in_database;

 

echo 'time is 15 minutes greater';

 

Thanks for any help

[dragon_sa]

if the time in the database is a timestamp you can do this

 

<?php
$st = $row['time'] + (15*60); // database time plus 15 mins
$t = time(); // current time
if ($t >= $st) {
  // do this
} else {
  // do this
}
?>

// if you want exactly 15min change >= to ==

[AyKay47]

Depending on your logic, you might want to do this in the query itself.

Format request_time as yyyy-mm-dd, then use timestampdiff();

 

[cloudll]

thanks  your a star