Discussion :

[samsso2005]

A chaque que l'utilisateur fournit son login et son password, une session est créee et je recupère l'id de la session.

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
 
session_start(); 
  $_SESSION['login'] = $login;
  $_SESSION['pass'] = $pass1;
  $a= $_SESSION['login'] ;
  $id = session_id();

J'aimerais avoir en temps réel le nombre de session actives.
merci de votre aide.

[dj-julio]

tu peux tjr stocker ces idSession dans un tableaun et faire un count(tableau)

[Invité]

tu ne peux pas savoir à quel moment précis un utilisateur se déconnecte ou n'utilise pas sa session.

il faut donc instaurer un système de timeout au bout duquel tu comptes une session comme inactive (meme si le gars est simplement parti se chercher un café et qu'apres il revient sur sa session)

[marcha]

Je te conseil d'utiliser ton propre gestionnaire de session

voici celui de Ying Zhang qui utilise mysql, ainsi, pour savoir
qui est en ligne, une simple requête suffit.

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
<?
/* ------------------------------------------------------------------------
* session_mysql.php
* ------------------------------------------------------------------------
* PHP4 MySQL Session Handler
* Version 1.00
* by Ying Zhang (ying@zippydesign.com)
* Last Modified: May 21 2000
*
* ------------------------------------------------------------------------
* TERMS OF USAGE:
* ------------------------------------------------------------------------
* You are free to use this library in any way you want, no warranties are
* expressed or implied.  This works for me, but I don't guarantee that it
* works for you, USE AT YOUR OWN RISK.
*
* While not required to do so, I would appreciate it if you would retain
* this header information.  If you make any modifications or improvements,
* please send them via email to Ying Zhang <ying@zippydesign.com>.
*
* ------------------------------------------------------------------------
* DESCRIPTION:
* ------------------------------------------------------------------------
* This library tells the PHP4 session handler to write to a MySQL database
* instead of creating individual files for each session.
*
* Create a new database in MySQL called "sessions" like so:
*
* CREATE TABLE sessions (
*      sesskey char(32) not null,
*      expiry int(11) unsigned not null,
*      value text not null,
*      PRIMARY KEY (sesskey)
* );
*
* ------------------------------------------------------------------------
* INSTALLATION:
* ------------------------------------------------------------------------
* Make sure you have MySQL support compiled into PHP4.  Then copy this
* script to a directory that is accessible by the rest of your PHP
* scripts.
*
* ------------------------------------------------------------------------
* USAGE:
* ------------------------------------------------------------------------
* Include this file in your scripts before you call session_start(), you
* don't have to do anything special after that.
*/
 
$SESS_DBHOST = "localhost";            /* database server hostname */
$SESS_DBNAME = "";    /* database name */
$SESS_DBUSER = "";            /* database user */
$SESS_DBPASS = "";                    /* database password */
 
$SESS_DBH = "";
//$SESS_LIFE = get_cfg_var("session.gc_maxlifetime");
$SESS_LIFE = 3600;
 
function sess_open($save_path, $session_name) {
    global $SESS_DBHOST, $SESS_DBNAME, $SESS_DBUSER, $SESS_DBPASS, $SESS_DBH;
 
    if (! $SESS_DBH = mysql_pconnect($SESS_DBHOST, $SESS_DBUSER, $SESS_DBPASS)) {
        echo "<li>Can't connect to $SESS_DBHOST as $SESS_DBUSER";
        echo "<li>MySQL Error: ", mysql_error();
        die;
    }
 
    if (! mysql_select_db($SESS_DBNAME, $SESS_DBH)) {
        echo "<li>Unable to select database $SESS_DBNAME";
        die;
    }
 
    return true;
}
 
function sess_close() {
    return true;
}
 
function sess_read($key) {
    global $SESS_DBH, $SESS_LIFE;
    $qry = "SELECT value FROM sessions WHERE sesskey = '$key' AND expiry > " . time();
    $qid = mysql_query($qry, $SESS_DBH);
    if (list($value) = mysql_fetch_row($qid)) return $value;
    return false;
}
 
function sess_write($key, $val) {
    global $SESS_DBH, $SESS_LIFE;
    $expiry = time() + $SESS_LIFE;
    $value = addslashes($val);
    $qry = "UPDATE sessions SET expiry = $expiry, value = '$value' WHERE sesskey = '$key'"; // AND expiry > " . time();
    $qid = mysql_query($qry, $SESS_DBH);
    if(mysql_affected_rows()<1) {
        $qry = "INSERT INTO sessions (sesskey, expiry, value) VALUES ('$key', $expiry, '$value')";
        $qid = mysql_query($qry, $SESS_DBH);        
    }
    return $qid;
}
 
function sess_destroy($key) {
    global $SESS_DBH;
    $qry = "DELETE FROM sessions WHERE sesskey = '$key'";
    $qid = mysql_query($qry, $SESS_DBH);
    return $qid;
}
 
function sess_gc($maxlifetime) {
    global $SESS_DBH;
    $qry = "DELETE FROM sessions WHERE expiry < " . time();
    $qid = mysql_query($qry, $SESS_DBH);
    return mysql_affected_rows($SESS_DBH);
}
 
session_set_save_handler(
    "sess_open",
    "sess_close",
    "sess_read",
    "sess_write",
    "sess_destroy",
    "sess_gc");
?>