本文实例介绍了PHP session 写入数据库的方法,分享给大家供大家参考,具体内容如下
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"),"read"),"write"),"destroy"),"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;
$<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a> = 'SELECT `session_data` AS `data` FROM `%s` WHERE `session_id` = "%s" AND `session_expires` > "%u"';
$<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a> = sprintf($<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>,<a href="https://www.jb51.cc/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_real_escape_string($this->link,$this->config['table']),$session_id),time());
$result = <a href="https://www.jb51.cc/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_query($this->link,$<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>);
$row = <a href="https://www.jb51.cc/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_fetch_assoc($result);
return $row['data'];
}
public function write($session_id,$session_data) {
if(empty($session_id)) return null;
$newExpires = time() + $this->maxlifetime;
$<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a> = 'REPLACE INTO `%s` SET `session_id` = "%s",`session_data` = "%s",`session_expires` = "%u"';
$<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a> = sprintf($<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>,$session_data),$newExpires);
$result = <a href="https://www.jb51.cc/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_query($this->link,$<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>);
return <a href="https://www.jb51.cc/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_affected_rows($this->link);
}
public function destroy($session_id) {
$sql = 'DELETE FROM %s
WHERE session_id
= "%s"';
$sql = sprintf($sql,$session_id));
$result = <a href="https://www.jb51.cc/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_query($this->link,$<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>);
return <a href="https://www.jb51.cc/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_affected_rows($this->link);
}
public function gc() {
$sql = 'DELETE FROM %s
WHERE session_expires
< "%u"';
$sql = sprintf($sql,$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));
以上就是本文的全部内容,希望对大家的学习有所帮助。
原文链接:https://www.f2er.com/php/20386.html