php把session写入数据库示例_php实例

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了php把session写入数据库示例_php实例，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3652字，纯文字阅读大概需要6分钟。

内容图文

代码如下:
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));

内容总结

以上是互联网集市为您收集整理的php把session写入数据库示例_php实例全部内容，希望文章能够帮你解决php把session写入数据库示例_php实例所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---