php session 寫入數(shù)據(jù)庫
本文實(shí)例介紹了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ù)庫中的代碼實(shí)例
- php基于session實(shí)現(xiàn)數(shù)據(jù)庫交互的類實(shí)例
- php實(shí)現(xiàn)將Session寫入數(shù)據(jù)庫
- PHP將session信息存儲到數(shù)據(jù)庫的類實(shí)例
- php中使用session_set_save_handler()函數(shù)把session保存到MySQL數(shù)據(jù)庫實(shí)例
- PHP獨(dú)立Session數(shù)據(jù)庫存儲操作類分享
- php把session寫入數(shù)據(jù)庫示例
- Session保存到數(shù)據(jù)庫的php類分享
- PHP用mysql數(shù)據(jù)庫存儲session的代碼
- PHP封裝的數(shù)據(jù)庫保存session功能類
相關(guān)文章
PHP高級編程之消息隊(duì)列原理與實(shí)現(xiàn)方法詳解
這篇文章主要介紹了PHP高級編程之消息隊(duì)列原理與實(shí)現(xiàn)方法,結(jié)合實(shí)例形式詳細(xì)分析了PHP消息隊(duì)列相關(guān)概念、原理、使用場景及相關(guān)操作注意事項(xiàng),需要的朋友可以參考下2020-01-01Nginx環(huán)境下PHP flush失效的解決方法
最近在工作中發(fā)現(xiàn)了一個問題,PHP的flush居然失效了,從網(wǎng)上找了一些資料,發(fā)現(xiàn)是Nginx的原因,所以這篇文章就給大家介紹了問題與解決辦法,有需要的朋友們下面來一起看看吧。2016-10-10gearman中任務(wù)的優(yōu)先級和返回狀態(tài)實(shí)例分析
這篇文章主要介紹了gearman中任務(wù)的優(yōu)先級和返回狀態(tài),結(jié)合實(shí)例形式分析了gearman任務(wù)的優(yōu)先級以及獲取返回狀態(tài)相關(guān)操作技巧,需要的朋友可以參考下2020-02-02PHP 獲取MySQL數(shù)據(jù)庫里所有表的實(shí)現(xiàn)代碼
獲取某個MySQL數(shù)據(jù)庫中所有表的PHP代碼如下,需要的朋友可以參考下。2011-07-07php中強(qiáng)制下載文件的代碼(解決了IE下中文文件名亂碼問題)
以下這段代碼作用是:瀏覽器提交excel格式的數(shù)據(jù)和文件名到服務(wù)器上,PHP將請求轉(zhuǎn)化為可下載的excel文件,并要求瀏覽器彈出文件下載提示窗口2011-05-05PHP 實(shí)現(xiàn) WebSocket 協(xié)議原理與應(yīng)用詳解
這篇文章主要介紹了PHP 實(shí)現(xiàn) WebSocket 協(xié)議,結(jié)合具體實(shí)例形式較為詳細(xì)的分析了websocket協(xié)議原理、以及PHP具體應(yīng)用相關(guān)操作技巧,需要的朋友可以參考下2020-04-04