PHP编程:php session 写入数据库
发布时间:2020-12-13 03:07:42 所属栏目:PHP教程 来源:网络整理
导读:《php session 写入数据库》要点: 本文介绍了php session 写入数据库,希望对您有用。如果有疑问,可以联系我们。 本文实例介绍了php session 写入数据库的办法,供大家参考研究,具体内容如下 PHP实例 ?php ## codeMaker Alpha 0.1.1 ( haowei.me )# T
《php session 写入数据库》要点: 本文实例介绍了php session 写入数据库的办法,分享给大家供大家参考,具体内容如下PHP实例 <?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"),"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; $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']),$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,$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,$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,$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实例 《php session 写入数据库》是否对您有启发,欢迎查看更多与《php session 写入数据库》相关教程,学精学透。编程之家 52php.cn为您提供精彩教程。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |