How would I do DateTime add seconds

[c-o-d-e]

I am creating an Expire Ban section in the database.

I have setup this

		$bantime = date("d m y, G:i:s");
	//setup time of expire
	$q = "INSERT INTO ".TBL_BANNED_USERS." VALUES ('$username', '$bantime', '$time', '$expire')";

 

The length of ban, is $time. How would I do

$expire = $bantime + $time;

$time value is in seconds. Would that be right.

I know timestamps are best done in MySQL. I prefer it this way though.

 

I like PHPFreaks new design.

[waynew]

Could you give us all the schema (structure - column types etc) of your database table?

 

In PHP, you can get the current timestamp by using the function mktime()

Then, you could add whatever seconds onto the current timestamp.

[c-o-d-e]

I just made it like this..

CREATE TABLE Banned (
Username varchar(40) primary key,
BanDate text not null,
Banlength varchar(50) null,
ExpireDate varchar(50) null
);

[waynew]

You should be using the proper MySQL column types. Datetime is available to you. If you use the function mktime() properly, this will be pretty easy to accomplish. Also, your column Banlength is a bit redundant, seeing as you could get the ban length from the BanDate and ExpireDate columns, unless I'm mistaken otheriwse.

[c-o-d-e]

Well.. the banlength isn't needed in the database. It is however, needed to add onto the current timestamp, to make the ExpireDate.

 

If I change the BanDate from text, to Datetime...

What would I do for the rest, would mktime() be..

mktime(month day year hour:minute:second);

I'm not sure.

Then If I set that as a variable. How would I add the $time onto the mktime?

 

Sorry, I'm not so understanding.

[waynew]

To get a datetime from PHP, use this:

 

$datetime = date("Y-m-d H:i:s");

 

You can also use the mktime() function to specific a date in the future.

[c-o-d-e]

Ok, thanks.

So.. from $datetime and $time

How would I add them together to get the expire?

[waynew]

You can convert a datetime into a timestamp by doing this:

 

$timestamp = strtotime($datetime);

[c-o-d-e]

Okay, but that doesn't explain how I'd get the expire date?