phpsession存數據庫

2020-03-22 20:21:16

字體：大中小

來源：轉載

供稿：網友

這個sesison存到數據庫很簡單，就是根據session_id進行對數據庫的CRUD操作，主要是用到了，session_set_save_handler這個方法，自定義session的執行方法，

首先創建數據表

CREATE TABLE `sessions` ( `session_id` varchar(255) NOT NULL, `session_expires` int(11) DEFAULT NULL, `session_data` text, PRIMARY KEY (`session_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

然后封裝操作session的工具類：

<?php//error_reporting(0);html' target='_blank'>class session {     var $lifeTime;     var $dbHandle;   function open($savePath, $sessName) {              $this->lifeTime = get_cfg_var("session.gc_maxlifetime");              $dbHandle = mysql_connect("localhost","root","root");       $dbSel = mysql_select_db("mysession",$dbHandle);              if(!$dbHandle || !$dbSel)           return false;       $this->dbHandle = $dbHandle;       return true;   }   function close() {       $this->gc(ini_get('session.gc_maxlifetime'));             return @mysql_close($this->dbHandle);   }   function read($sessID) {              $res = mysql_query("SELECT session_data AS d FROM sessions                           WHERE session_id = '$sessID'                           AND session_expires > ".time(),$this->dbHandle);              if($row = mysql_fetch_assoc($res))           return $row['d'];       return "";   }   function write($sessID,$sessData) {	   	              $newExp = time() + $this->lifeTime;              $res = mysql_query("SELECT * FROM sessions                           WHERE session_id = '$sessID'",$this->dbHandle);      	          if($res) {          		              mysql_query("UPDATE sessions SET session_expires = '{$newExp}',session_data = '{$sessData}' WHERE session_id = '{$sessID}'",$this->dbHandle);				                      if(mysql_affected_rows($this->dbHandle))               return true;       }              else {                    mysql_query("INSERT INTO sessions (                         session_id,                         session_expires,                         session_data)                         VALUES(                         '{$sessID}',						 '{$newExp}',						 '{$sessData}')",$this->dbHandle);                      if(mysql_affected_rows($this->dbHandle))               return true;       }              return false;   }   function destroy($sessID) {              mysql_query("DELETE FROM sessions WHERE session_id = '$sessID'",$this->dbHandle);             if(mysql_affected_rows($this->dbHandle))           return true;              return false;   }   function gc($sessMaxLifeTime) {              mysql_query("DELETE FROM sessions WHERE session_expires < ".time(),$this->dbHandle);              return mysql_affected_rows($this->dbHandle);   }}#對session進行測試，發現數據庫中并沒有存入數據只有session_id,和session_expires的數值,其實session_data是存在的只是我們看不到$session = new session();	session_set_save_handler(array(&$session,"open"),							 array(&$session,"close"),							 array(&$session,"read"),							 array(&$session,"write"),							 array(&$session,"destroy"),							 array(&$session,"gc"));			session_start();			$session->write(session_id(),json_encode(array("name"=>"gxx","pass"=>"123")));				echo $session->read(session_id());?>  這里居然不支持插圖。。

數據庫數據:

s430j9t480ocbovq6a7a0rlk22 1435054078

session查詢數據:
JSON