Session - How to know when it ends?

[kemp]

How can I know when a session has ended without the use of "session_unset"? (for exemple when a user close the current window but doesn't go to the log-out page)

[The New Guy]

Mabye something like this:

         if(!session_id()){
                 // No Session
             session_start();
         }
         else{
                 // Already a session
         } 

[Hartmann]

When a user closes a window (and no other windows are open) a session ends. They don't have to go to the logout page for it to end.

[kemp]

But how can I use this information (session ending) to update something on a table database?

[1337-Dev]

Assuming you have a $_SESSION set..

if(!isset($_SESSION['whatever'])) {

// connect to the database then

$query = "UPDATE table SET blah='blah' WHERE blah='blah'";

$insert = mysql_query($query)or die(mysql_error());

} 

[kemp]

But this way I can't know info from the session.
Let me explain better what I want. I wanna make a users online list. I was thinking of updating a users online table when someone logs in. But then, how can I update when he logs out, the way I said above?

[subnet_rx]

I thought they did it with cron jobs.

[reminder]

on every page refreshing u see how many logged user u have!
if u want to see it in real time u have to take some php online users script and go to javascript session and then ask there how to update in real time a number with this script.

[kemp]

on every page refreshing u see how many logged user u have!
if u want to see it in real time u have to take some php online users script and go to javascript session and then ask there how to update in real time a number with this script.

But there is no way for me to delete a user from the online users table when he logs out without hitting the Logout button, right?

How can I see the sessions created on the server and check which one is gone?

I'm kinda confused

[The New Guy]

Ah, there is no way to do that. What things like Vbulliten do is periodically check to see if the user is online.

So in steps:

1. Add user and date/time of access to DB.
2. Everytime the user performs an action update the date/time.
3. Have a regular function to test if the date/time is older than a give value. Say an hour. If it is delete user from DB. He is no longer online.

[kemp]

Ah, there is no way to do that. What things like Vbulliten do is periodically check to see if the user is online.

So in steps:

1. Add user and date/time of access to DB.
2. Everytime the user performs an action update the date/time.
3. Have a regular function to test if the date/time is older than a give value. Say an hour. If it is delete user from DB. He is no longer online.

Yeah, I didn't think it was possible but I had to ask

Thanks!

[1337-Dev]

Logout.php:

session_start();

$destroy = session_destroy();

if($destroy) {

$query = "UPDATE users SET online='no' WHERE id='blah' and online='yes'";

$update = mysql_query($query)or die(mysql_error());

header("Location: wherever");

} 

That could be a logout script. How to do what you do with when the browser closes etc, no, that isnt possible .

[Hartmann]

Yeah, I think he is wanting to know how he could do a logout when the browser is closed.

You could try some fancy Javascript and see if that works. When a user closes a window on your site, you open a very small one up, run your PHP and then close that window. It could work.

[BlueFire2k5]

Yeah, I think he is wanting to know how he could do a logout when the browser is closed.

You could try some fancy Javascript and see if that works. When a user closes a window on your site, you open a very small one up, run your PHP and then close that window. It could work.

However, that very well could be taken as a popup and killed by many different programs. >_>

[kemp]

Thanks everyone.


The JavaScript thing is not gonna happen and I'll just do it like VBulletin.


Thanks again for the help

[reminder]

u cant know when someone else close the browser window without logout!
but u can destroy the session from admin section.
example: create an admin section with select form which take all users from db and then do that script:

<select name="UserSession"><!-- php stuff -->
<option value="<?php echo $row[1]; ?>"><?php echo $row[2]; ?></option><!-- end php stuff -->
</select>

now in php

$data = $_POST["UserSession"];
$query = mysql_query("select from user where id = ".$data);
while($row = mysql_fetch_rows($query)) {
$_SESSION["id"] = $row[1];
}
mysql_free_result($query); 

put this into a form
and when u click the delete session submit button go on this function:

if(isset($_POST["your_submit_button"])) {
$_SESSION["id"] = 0;
} 

now your selected user havent a session.
hope this helps
cya