Time + Duration

[Senseh]

Hi,

I've been trying to figure this out for 2 days.

I have 2 tables. One with opening times in and the other with the duration of the even in. Both fields are type time (> duration time not null,)

I want to get the opening time from the database then add the duration from the other table to it using php. The idea is it will create a menu in a form displaying all the possible event times from opening time to close.

i.e.

opening time = 09:00:00
duration = 00:20:00
close time = 23:00:00

09:00:00
09:20:00
09:40:00
10:00:00
10:20:00
...
22:40:00

I have no problem accessing the times from the tables or looping the script its just adding them together. It either subtracts from it or seems to add the difference of the duration from 01:00:00 to it.

My failed attempts:
1.

$duration = $myrow["duration"];

$result = mysql_query("SELECT * FROM park",$db);
$myrow = mysql_fetch_array($result);
$time = $myrow["open"];

$time = $time + $duration;
echo $time;

echos 9 😕

2.

$duration = strtotime($myrow["duration"],0);

$result = mysql_query("SELECT * FROM park",$db);
$myrow = mysql_fetch_array($result);
$time = strtotime($myrow["open"],0);

$addition = strtotime('01:00:00',0) + $duration;
$time = $time + $addition;
echo date("H:i:s",$time);

echos 08:20:00 😕

Any help is gratefuly recieved, thanks in advance.

[vornn]

Mmmm,

Do you know what I would do?

I'd store the duration as text, maybe, if the duration could be different, use a drop down form to set the duration and store the result.

Then use the strtotime function to add the start time and the duration together

Here's the php manual example:

Example 1. strtotime() examples

<?php
echo strtotime ("now"), "\n";
echo strtotime ("10 September 2000"), "\n";
echo strtotime ("+1 day"), "\n";
echo strtotime ("+1 week"), "\n";
echo strtotime ("+1 week 2 days 4 hours 2 seconds"), "\n";
echo strtotime ("next Thursday"), "\n";
echo strtotime ("last Monday"), "\n";
?>

We can see that we could add 20 minites to a time, example:

echo strtotime ("+20 minutes"), "\n";

so why not use this?
We also have another built in function the date function, which will let use add units to the date.

I feel another example coming on....

Example 3. date() and mktime() example

<?php
$tomorrow = mktime (0,0,0,date("m") ,date("d")+1,date("Y"));
$lastmonth = mktime (0,0,0,date("m")-1,date("d"), date("Y"));
$nextyear = mktime (0,0,0,date("m"), date("d"), date("Y")+1);
?>

Has the penny dropped yet?

Have a think about this, maybe use both functions to achive the desired result.

Hope this helps...

🙂

PS, it's always fun to read the manual

😃

[Senseh]

Thanks dude got it working now.

I did read the manual and spent ages looking for a solution, guess i never made the connection.