Time

[cheechm]

How would I add one hour to the time and echo it in the following format:

 

date("H:i:s")

 

Thanks

[.josh]

time

[akitchin]

$timestamp_plushour = time() + 3600;
$formatted_date = date('H:i:s', $timestamp_plushour);
echo $formatted_date;

 

there are a zillion ways to skin the cat when it comes to dates and times; this is but one of them.

 

EDIT:  CV's brief post has beaten me to the punch - thine fingers are brisk, CV.

[cheechm]

Thanks, so I have this in my database:

 

time_visited = 21:00:00

 

How would I compare the current time using

        $time = time() + 3600;
        $expire_time = date('H:i:s', $time);

 

to time_visited?

 

Thanks

[.josh]

EDIT:  CV's brief post has beaten me to the punch - thine fingers are brisk, CV.

haha nope, just shorter post.

[akitchin]

Thanks, so I have this in my database:

 

time_visited = 21:00:00

 

How would I compare the current time using

        $time = time() + 3600;
        $expire_time = date('H:i:s', $time);

 

to time_visited?

 

Thanks

 

that only works for UNIX timestamps, which time() generates.  if your time is in the database in TIME format, you can simply use:

 

DATE_ADD(time_visited, INTERVAL 1 HOUR)

 

in MySQL itself.

[cheechm]

Doesn't work.. Hmmm....

 

        $time = time() + 3600;
        $expire_time = date('H:i:s', $time);
        $sql = "SELECT username FROM login WHERE DATE_ADD(last_visit_time, INTERVAL 1 HOUR) < $expire_time" or die(mysql_error
            ());
$result = db_query($sql);
        $users_online = array();
        while ($row = db_fetch_array($result)) {
        	echo $row['username'];
}

 

Thanks

 

 

[The Little Guy]

echo date("H:i:s",strtotime("now + 1 hour"));

[akitchin]

what field type is the last_visit_time field?

[cheechm]

last_visit_time is type "time"

[akitchin]

you were performing the calculation on the incorrect field:

 

SELECT username FROM login WHERE last_visit_time < TIME(NOW() + INTERVAL 1 HOUR)

 

it needed to change slightly since you're using the time fieldtype.