1
|
<?php
|
2
|
|
3
|
session_set_save_handler('db_connect',
|
4
|
'db_disconnect',
|
5
|
'sess_get',
|
6
|
'sess_put',
|
7
|
'sess_del',
|
8
|
'sess_clean');
|
9
|
|
10
|
function db_connect()
|
11
|
{
|
12
|
mysql_connect('myhost', 'myuser', 'mypass');
|
13
|
mysql_select_db('sessions');
|
14
|
}
|
15
|
|
16
|
function db_disconnect()
|
17
|
{
|
18
|
mysql_close();
|
19
|
}
|
20
|
|
21
|
function sess_get($unique_id)
|
22
|
{
|
23
|
$sess_get_sql ="select session_data from sessions
|
24
|
where unique_id='$unique_id'";
|
25
|
|
26
|
if ($sess_get_result = mysql_query($sess_get_sql))
|
27
|
{
|
28
|
$record=mysql_fetch_assoc($sess_get_result);
|
29
|
return $record['session_data'];
|
30
|
}
|
31
|
}
|
32
|
|
33
|
function sess_put($unique_id, $session_data)
|
34
|
{
|
35
|
$curr_timestamp = time();
|
36
|
$session_data = mysql_escape_string($session_data);
|
37
|
$sess_put_sql = "replace into sessions
|
38
|
values ('$unique_id', '$curr_timestamp', $'$session_data',)";
|
39
|
|
40
|
mysql_query($sess_put_sql);
|
41
|
}
|
42
|
|
43
|
function sess_del($unique_id)
|
44
|
{
|
45
|
$sess_del_sql =
|
46
|
"delete from sessions where unique_id='$unique_id'";
|
47
|
mysql_query($sess_del_sql);
|
48
|
}
|
49
|
|
50
|
function sess_clean($session_lifetime)
|
51
|
{
|
52
|
$min_timestamp = time() - $session_lifetime;
|
53
|
$sess_clean_sql =
|
54
|
"delete from sessions where last_access < '$min_timestamp'";
|
55
|
mysql_query($sess_clean_sql);
|
56
|
}
|
57
|
|
58
|
?>
|
Devenir membre Dernière actualité du site: Nouvelle interface et nouvelles fonctionnalités en préparation
20 / 20 
