Jump to content

Archived

This topic is now archived and is closed to further replies.

Baiba

php, mysql and timestamps

Recommended Posts

i am stuck with this:
[code]

$id = (int)$_REQUEST['id'];
$blocktime = (int)$_REQUEST['blocktime'];
$blocktimesec =60*$blocktime;
$time=$db->GetOne("SELECT NOW()+".$blocktimesec);
$db->Execute("UPDATE useri SET user_perm='blocked',user_blocked_till= ".$time.", user_block_tot =".$blocktime." WHERE user_id=".$id."");

[/code]

$blocktime is amount of minutes user will be blocked for
user_block_tot is db field where amount of minutes user will be blocked for is stored (as integer)
user_blocked_till is db field where time whom till user will be blocked is stored (as timestamp)

problem is that something is stored in user_blocked_till but seems that it is not the time of present moment increased by the minutes user is blocked for, maybe someone could help what is not right in my code to make this happen?

Share this post


Link to post
Share on other sites
using mysql INTERVAL might help you out, it's much easier.
Storing time using NOW() + INTERVAL add or sub

example:
[code]
mysql_query("select * from table where stampedtime < date_sub(now(), interval 5 minute)");
[/code]

[a href=\"http://www.mysqlfreaks.com/statements/53.php\" target=\"_blank\"]http://www.mysqlfreaks.com/statements/53.php[/a]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.