time().... HELP!!!

[robcrozier]

Hi all, what im trying to do is add or take away one minute from a time which comes from a databes.

 

what im currently doing is calling a 'datetime' field from the database and then using the explode() function to seperate the date and the time.  once i am left with the time, how can i get PHP to treat it like a time and either add or remove one minute? 

 

I think i'm over complicating things at the minute!

 

Any help would be great!

 

Cheers!

[kenrbnsn]

A datetime file will be returned to your PHP script in the form of "yyyy-dd-mm hh:mm:ss", process that string with the strtotime() function. Then you can add or substract 60 from that value.

 

Ken

[robcrozier]

OK, thanks for the reply Ken but im a bit of a novice when it comes to time functions in PHP.  How would i process it with PHP strtotime() function.  Also, i might mention that i would also like to convert some user input in the form of HH:MM:SS to a valid php time var so that i can compare etc..

 

 

 

cheers!

[kenrbnsn]

Read the manual pages on strtotime() and date(). They are really quite helpful. They also have alot of good examples to use.

 

Ken

[robcrozier]

i just can't understand how to get PHP to treat a string (in the form of a time: HH:MM:SS) as a time var?

[kenrbnsn]

You can use the strtotime() function to convert the string to an integer containing the number of seconds since 1970-1-1.

 

<?php
$str = '16:10:24';
$tim = strtotime($str);
echo $tim ."<br>";
$tim += 60;
echo date('G:i:s',$tim) . "\n";
?>

 

Ken

 

[lemmin]

You can do this with mysql. Something like

SELECT SUBTIME(thedatetime, '01:00:00') as subbedtime FROM table...

 

Here is the documentation:

http://dev.mysql.com/tech-resources/articles/4.1/time.html

[robcrozier]

thanks Ken that's just what i was after!