seeing how long session has been active?

Ashleek007 · April 19th, 2005, 06:00 AM

ok, its me again!

Ive set a session variable called '$_SESSION['subject']' which is alive all the time a user is on a certain subject page.

I need to know how long this session is alive for, so i can judge how long someone is on this subject page for.

how can i view the length of time the session has been set?

does that make sense?

cheers
Ash

My new web design domain
www.askmultimedia.co.uk

Ashleek007 · April 19th, 2005, 06:10 AM

ok, ive found that you can view the timestamp of a session using this:-

$start = time('subject');

which will set the variable $start to the initial timestamp.

What i need now is to kno how to manipulate these timestamps, into a real time value such as 1minute 34seconds!

ill have a go, but anything in the mean time will be a big help!
cheers
ash

My new web design domain
www.askmultimedia.co.uk

BobbyFisher · April 19th, 2005, 10:17 AM

Try something like this

Code:

function elapsed_time($timestring)
{
  //Get the time difference.
  $x = split(",", date("Y,m,d,H,i,s", time() - strtotime($timestring)));

  //Return an associative array.  Subtract 01.01.1970 because
  //time() and strtotime() return time values WRT the Unix Epoch.
  return array("years" => $x[0] - 1970,
               "months" => $x[1] - 1,
               "days" => $x[2] - 1,
               "hours" => $x[3],
               "minutes" => $x[4],
               "seconds" => $x[5]);
}

Everything is temporary, some things are just more temporary than others... except for death, that seems to be pretty permanent

Ashleek007 · April 19th, 2005, 10:25 AM

hey, ive done it now, just compared the timestamps and calculated the difference, it works, so im happy!lol

another little problem ive got,(sorry!) i want to select all items from a record in a MySQL db which = 0.

so say there is a record with 20 1's or 0's in.

I want to select all the zeros!

how would i do this?

cheers
Ash

My new web design domain
www.askmultimedia.co.uk

BobbyFisher · April 19th, 2005, 10:28 AM

use a where clause in your sql statment.

Everything is temporary, some things are just more temporary than others... except for death, that seems to be pretty permanent

Ashleek007 · April 19th, 2005, 10:42 AM

would it be like

SELECT * FROM questions WHERE value = '0'?

would this return all fields that contain a zero? like i said, there are 20 fields in the table and i only want the ones with 0 in them!

cheers
Ash

My new web design domain
www.askmultimedia.co.uk

BobbyFisher · April 19th, 2005, 01:05 PM

more complicated then that. You have to use the field names. Is is also not a good practice to use SELECT *. What you can do is have all the field names in an array then use a foreach statment for the select and the while clause and appending to the sql statment. WHERE clasuses are formated in "WHERE `Field_Name` = 0 OR `Field_Name_2` = 0 AND `Field_Name_3` != 1"

Now that what I read more into what you are doing, where clauses are for returning only specified rows. Not fields within the rows. Sounds like you want to only collect the zero value fields within the same row. Is that correct? If so I would suggest pulling all fields that you want to check aggenst and check them for zero in the result with php. The best way to do that really depends on what you are doing with the values. No matter how you are doing it the value is always going to be zero.

Everything is temporary, some things are just more temporary than others... except for death, that seems to be pretty permanent