Is it possible to use mysqls NOW() function and add seconds to or from it?
Like so;
$q = $dbc -> prepare ("UPDATE account SET time = NOW() + $seconds WHERE id = ?"); Thanks
Add a comment |
5 Answers
If you want to do this in MySql, you can either use
DATE_ADD(NOW(), INTERVAL $seconds SECOND) or
UNIX_TIMESTAMP() + $seconds Source
Comments
You can add seconds to it with DATE_ADD():
$q = $dbc -> prepare ("UPDATE account SET time = DATE_ADD(NOW(), INTERVAL $seconds SECONDS) WHERE id = ?"); answered Dec 14, 2011 at 17:18
Michael Berkowski
271k47 gold badges450 silver badges395 bronze badges
1 Comment
berkes
Beware though that if I get $seconds = "little johhny tables;" into your PHP, you've a gaping hole. You probably want to use your DB-layers placeholder system (the ?) instead of simply injecting $seconds.
$q = $dbc -> prepare ("UPDATE account SET time = date_add(NOW() + INTERVAL $seconds SECOND) WHERE id = ?"); 
Comments
No it is not possible.
You can just do:
$time = date('Y-m-d H:i:s', strtotime("+2 seconds")); $q = $dbc->prepare ("UPDATE account SET time = '$time' WHERE id = ?"); 
Comments
I don't know your exact dbc class usage, but most probably, you want to simply add another parameter:
$q = $dbc->prepare ("UPDATE account SET time = NOW() + ? WHERE id = ?"); $q->execute($seconds, $id);