php session 寫入數(shù)據(jù)庫
更新時間:2016年02月13日 16:12:12 投稿:lijiao
這篇文章主要介紹了php session 寫入數(shù)據(jù)庫的相關(guān)資料,需要的朋友可以參考下
本文實例介紹了php session 寫入數(shù)據(jù)庫的方法,分享給大家供大家參考,具體內(nèi)容如下
<?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));
以上就是本文的全部內(nèi)容,希望對大家的學(xué)習(xí)有所幫助。
您可能感興趣的文章:
- 將PHP的session數(shù)據(jù)存儲到數(shù)據(jù)庫中的代碼實例
- php基于session實現(xiàn)數(shù)據(jù)庫交互的類實例
- php實現(xiàn)將Session寫入數(shù)據(jù)庫
- PHP將session信息存儲到數(shù)據(jù)庫的類實例
- php中使用session_set_save_handler()函數(shù)把session保存到MySQL數(shù)據(jù)庫實例
- PHP獨立Session數(shù)據(jù)庫存儲操作類分享
- php把session寫入數(shù)據(jù)庫示例
- Session保存到數(shù)據(jù)庫的php類分享
- PHP用mysql數(shù)據(jù)庫存儲session的代碼
- PHP封裝的數(shù)據(jù)庫保存session功能類
相關(guān)文章
php select,radio和checkbox默認選擇的實現(xiàn)方法
radio和checkbox默認選擇的實現(xiàn)方法,大家參考下原理就知道了,不論asp,asp.net,jsp都是這個原理。2010-05-05
學(xué)習(xí)php設(shè)計模式 php實現(xiàn)門面模式(Facade)
這篇文章主要介紹了php設(shè)計模式中的門面模式,使用php實現(xiàn)門面模式,感興趣的小伙伴們可以參考一下2015-12-12
深入解讀php中關(guān)于抽象(abstract)類和抽象方法的問題分析
這篇文章主要介紹了php中關(guān)于抽象(abstract)類和抽象方法的問題分析,有需要的朋友可以參考一下2014-01-01
phpstudy中MySQL數(shù)據(jù)庫無法啟動的解決方法
自己在電腦上安裝了MySQL數(shù)據(jù)庫,MySQL的服務(wù)名為MySQL,這會與phpstudy的數(shù)據(jù)庫的服務(wù)名發(fā)生沖突,從而造成phpstudy中的數(shù)據(jù)庫無法啟動,所以本文給大家介紹了phpstudy中MySQL數(shù)據(jù)庫無法啟動的解決方法,需要的朋友可以參考下2024-06-06
PHP常見數(shù)學(xué)函數(shù)及BC高精度數(shù)學(xué)函數(shù)用法示例
這篇文章主要介紹了PHP常見數(shù)學(xué)函數(shù)及BC高精度數(shù)學(xué)函數(shù)用法,簡單列舉了php常見數(shù)學(xué)運算函數(shù)并結(jié)合實例形式給出了bc高精度函數(shù)的功能與使用技巧,需要的朋友可以參考下2017-11-11

