Requesting help with time format

tryinToLearn

Hello,

Below are two examples of different ways to display and compute time.
The first one is in use now. It works fine except, when I go to log the session - last_action, the current format does not match what mysql db requires (0000-00-00 00:00:00)

Any ideas on how I can make this right or achieve something like the second example? I am stumped and could really use your advice on how to do this.

Thank you in advance for your valued time~

[code=php]

// Top example is what I use now..
// Display format = 1209139197

$sessionTimeout= 30; // 30 seconds til timeout

$_SESSION['last_action'] = time(); // Session is set at login

if ((time() - $_SESSION['last_action']) > $sessionTimeout) // Condition for timeout, in members.php

// Second example is how I would like to use it.
// Display format = 0000-00-00 00:00:00

$sessionTimeout= 0000-00-00 00:00:30 // 30 seconds til timeout

$timeNow = date('Y-m-d h:i:s'); // Modified timestamp

$_SESSION['last_action'] = date("Y-m-d h:i:s"); // Session is set at login

if (($timeNow - $_SESSION['last_action']) > $sessionTimeout ) // Condition for timeout, in members.php

[/code]

Kudose

Check out the MySQL function FROM_UNIXTIME

ucffool

TO convert your $SESSION['last_action'] from its current form (unix timestamp), you can use the date function again:

$last_action = date('Y-m-d h:i:s', $_SESSION['last_action'])

Kudose

Promoting paid products in your signature is against PHPBuilder's ToS.

ucffool

According to the board guidelines there is no such rule (Sticky at the top of each forum). Secondly, Searching PHPBUILDER.com I find nothing regarding this either. Care to substantiate?

Kudose

You will not post advertisements, chain letters, pyramid schemes, or solicitations, all of which are inappropriate and prohibited in the Forums. You will not, furthermore, collect personal information about forum members for the purpose of sending them any such advertisements, chain letters, pyramid schemes, or solicitations through other means (email, messaging programs, etc.).

Your signature is a part of the forum.

http://www.jupitermedia.com/corporate/privacy/aup.html

edit

You will not post any copyrighted material, nor link to any copyrighted material (with the exception of publicly available sites and pages that the legal owners of the copyrights have created to make that material freely available to the general public), unless that copyright is owned by you or by these Forums.

Is why I can post the link to phpDealer and IPingdom, cause they are completely free