/
Session.php
129 lines (102 loc) · 3.11 KB
/
Session.php
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
123
124
125
126
127
128
129
<?php
namespace Li;
class session {
private static $_session;
public static function session()
{
if(!(self::$_session instanceof self))
{
self::$_session = new self();
}
return self::$_session;
}
public static function init()
{
if(isset(App::app()->config['session']))
{
if(isset(App::app()->config['session']['driver'])
&& App::app()->config['session']['driver'] = 'mysql')
{
$driver = 'Session'.ucfirst(App::app()->config['session']['driver']);
$handler = new SessionMysql(App::app()->config['session']['config']);
session_set_save_handler($handler, true);
}
}
session_start();
}
}
class SessionMysql implements \SessionHandlerInterface
{
private $_config;
private $_gc_maxlifetime;
private function getTimeout()
{
return (int)ini_get('session.gc_maxlifetime');
}
public function __construct($config)
{
$this->_config = $config;
$this->_gc_maxlifetime = $this->getTimeout();
}
public function close ()
{
return true;
}
public function destroy ($session_id)
{
$dbName = $this->_config['dbName'];
$db = Db::db()->$dbName;
$sql = 'DELETE FROM `'.$this->_config['tableName'].'` WHERE `id`=:0';
Db::db()->$dbName->prepare($sql);
Db::db()->$dbName->bindValues(array(
array(':0', $session_id),
));
Db::db()->$dbName->execute();
return true;
}
public function gc ($maxlifetime)
{
$dbName = $this->_config['dbName'];
$db = Db::db()->$dbName;
$sql = 'DELETE FROM `'.$this->_config['tableName'].'` WHERE `expire`<:0';
Db::db()->$dbName->prepare($sql);
Db::db()->$dbName->bindValues(array(
array(':0', NOW),
));
Db::db()->$dbName->execute();
return true;
}
public function open ($savePath, $sessionName)
{
return true;
}
public function read ($session_id)
{
$dbName = $this->_config['dbName'];
$db = Db::db()->$dbName;
$sql = 'SELECT `data` FROM `'.$this->_config['tableName'].'` WHERE `id`=:0 AND `expire`>:1 limit 1';
Db::db()->$dbName->prepare($sql);
Db::db()->$dbName->bindValues(array(
array(':0', $session_id),
array(':1', NOW),
));
$data = Db::db()->$dbName->fetch();
if($data===false)
return '';
return $data['data'];
}
public function write ($session_id,$session_data)
{
$dbName = $this->_config['dbName'];
$db = Db::db()->$dbName;
$sql = 'REPLACE INTO `'.$this->_config['tableName'].'` (`id`, `data`, `expire`) VALUES (:0,:1,:2)';
Db::db()->$dbName->prepare($sql);
Db::db()->$dbName->bindValues(array(
array(':0', $session_id),
array(':1', $session_data),
array(':2', NOW+$this->_gc_maxlifetime),
));
Db::db()->$dbName->execute();
return true;
}
}