php session 写入数据库-华尔子博-奥夏网

php session 写入数据库的方法，具体内容如下

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

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

<?php

#

# codeMaker Alpha 0.1.1 ( haowei.me )

# This framework comply with the GPL license agreement

#

class session_handler {

protected $maxlifetime = null;

protected $dbHandle = null;

public $config = null;

public static function init($args) {

return new self($args);

}

public function __construct($args) {

$this->config = $args;

$this->maxlifetime = get_cfg_var("session.gc_maxlifetime");

session_set_save_handler(

array($this, "open"),

array($this, "close"),

array($this, "read"),

array($this, "write"),

array($this, "destroy"),

array($this, "gc"));

}

public function open() {

$this->link = mysqli_connect(

$this->config['host'],

$this->config['user'],

$this->config['password'],

$this->config['database']);

mysqli_set_charset($this->link, "utf8");

$sql = 'CREATE TABLE IF NOT EXISTS `%s` (

`session_id` varchar(255) NOT NULL,

`session_data` text,

`session_expires` char(10) NOT NULL,

PRIMARY KEY (`session_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;';

$sql = sprintf($sql, $this->config['table']);

mysqli_query($this->link, $sql);

return true;

}

public function close() {

return true;

}

public function read($session_id) {

if(empty($session_id)) return null;

$sql = 'SELECT `session_data` AS `data` FROM `%s` WHERE `session_id` = "%s" AND `session_expires` > "%u"';

$sql = sprintf($sql,

mysqli_real_escape_string($this->link, $this->config['table']),

mysqli_real_escape_string($this->link, $session_id),

time());

$result = mysqli_query($this->link, $sql);

$row = mysqli_fetch_assoc($result);

return $row['data'];

}

public function write($session_id, $session_data) {

if(empty($session_id)) return null;

$newExpires = time() + $this->maxlifetime;

$sql = 'REPLACE INTO `%s` SET `session_id` = "%s", `session_data` = "%s", `session_expires` = "%u"';

$sql = sprintf($sql,

mysqli_real_escape_string($this->link, $this->config['table']),

mysqli_real_escape_string($this->link, $session_id),

mysqli_real_escape_string($this->link, $session_data),

$newExpires);

$result = mysqli_query($this->link, $sql);

return mysqli_affected_rows($this->link);

}

public function destroy($session_id) {

$sql = 'DELETE FROM `%s` WHERE `session_id` = "%s"';

$sql = sprintf($sql,

mysqli_real_escape_string($this->link, $this->config['table']),

mysqli_real_escape_string($this->link, $session_id));

$result = mysqli_query($this->link, $sql);

return mysqli_affected_rows($this->link);

}

public function gc() {

$sql = 'DELETE FROM `%s` WHERE `session_expires` < "%u"';

$sql = sprintf($sql,

mysqli_real_escape_string($this->link, $this->config['table']),

time());

$result = mysqli_query($this->link, $sql);

return mysqli_affected_rows($this->link);

}

class session {

public static $collection = null;

public static function open($clean = false, $token = false) {

if($clean) ob_end_clean();

if($token) session_id($token);

session_start();

self::$collection = $_SESSION;

}

public static function id() {

$num_args = func_num_args();

if($num_args) {

$args = func_get_arg(0);

return session_id($args);

}else{

return session_id();

}

public static function get($name) {

return isset($_SESSION[$name]) ? $_SESSION[$name] : null;

}

public static function set($name, $value) {

$_SESSION[$name] = $value;

return true;

}

public static function delete($name) {

if(!isset($_SESSION[$name])) return null;

unset($_SESSION[$name]);

return true;

}

public static function destroy() {

session_destroy();

}

$config = array(

"host"=> "127.0.0.1",

"user"=> "root",

"password"=> "123456",

"database"=> "test",

"charset"=> "utf8",

"table"=> "user_session");

session_handler::init($config);

session::open();

session::set("profile", array("id"=> 1, "user"=> "haowei", "vip-level"=> 6));

本文刊载的所有内容，包括文字、图片、音频、视频、软件、程序、以及网页版式设计等部门来源于互联网，版权均归原作者所有！本网站提供的内容服务于个人学习、研究或欣赏，以及其他非商业性或非盈利性用途，但同时应遵守著作权法及其他相关法律的规定，不得侵犯本网站及相关权利人的合法权利。
联系信息：邮箱aoxolcom@163.com或见网站底部。

THE END