## 實現接口類SessionHandlerInterface ~~~ <?php /** * Created by gather * Email: chenruiqiang@yd-x.com * Phone: 16601180687 * Copyright:源動互通（北京）科技有限公司 * Create Time: 2018/5/28 19:12 * 使用Mysql管理session */ class CustomSession implements SessionHandlerInterface{ private $link = null; //數據庫連接 private $lifetime; //聲明周期 /* 方法 */ public function close(){ return mysqli_close($this->link); } public function destroy($session_id){ //刪除session $session_id = mysqli_real_escape_string($this->link,$session_id); $sql = "DELETE FROM sessions WHERE session_id='{$session_id}'"; mysqli_query($this->link,$sql); return mysqli_affected_rows($this->link) == 1; } public function gc($maxlifetime){ $sql = "DELETE FROM sessions WHERE session_expires < ".time(); mysqli_query($this->link,$sql); return mysqli_affected_rows($this->link) > 0; } public function open($save_path,$session_name){ $this->lifetime = get_cfg_var("session.gc_maxlifetime"); //默認24分鐘 $this->link = mysqli_connect('localhost','root','xyq07041103'); mysqli_set_charset($this->link,'utf8'); mysqli_select_db($this->link,'email'); if ($this->link){ return true; } return false; } public function read($session_id){ $id = mysqli_real_escape_string($this->link,$session_id); $sql = "SELECT * from sessions WHERE session_id='{$id}' AND session_expires > ".time(); $result = mysqli_query($this->link,$sql); if (mysqli_num_rows($result) == 1){ return mysqli_fetch_assoc($result)['session_data']; } return ''; } public function write($session_id,$session_data){ //首先查詢是否存在指定的session_id,如果存在更新數據，否自寫入數據 $session_id = mysqli_real_escape_string($this->link,$session_id); $newExp = time() + $this->lifetime; $sql = "SELECT * from sessions WHERE session_id='{$session_id}'"; $result = mysqli_query($this->link,$sql); $rows = mysqli_num_rows($result); if ($rows == 1){ $sql = "UPDATE sessions SET session_expires='{$newExp}',session_data='{$session_data}' WHERE session_id='{$session_id}'"; }else{ $sql = "INSERT INTO sessions VALUES('{$session_id}','{$session_data}','{$newExp}')"; } mysqli_query($this->link,$sql); return mysqli_affected_rows($this->link) == 1; } } ~~~ ## 創建session ~~~ <?php /** * Created by gather * Email: chenruiqiang@yd-x.com * Phone: 16601180687 * Copyright:源動互通（北京）科技有限公司 * Create Time: 2018/5/28 20:00 */ require_once "CustomSession.php"; $CustomSession = new CustomSession(); ini_set('session.save_handler','user'); //自定義管理session session_set_save_handler($CustomSession,true); session_start(); $_SESSION['username'] = 'king'; $_SESSION['age'] = '23'; $_SESSION['email'] = 'aaaaaa5474@126.com'; ~~~ ## 刪除session ~~~ <?php /** * Created by gather * Email: chenruiqiang@yd-x.com * Phone: 16601180687 * Copyright:源動互通（北京）科技有限公司 * Create Time: 2018/5/28 20:22 */ require_once "CustomSession.php"; $CustomSession = new CustomSession(); ini_set('session.save_handler','user'); //自定義管理session session_set_save_handler($CustomSession,true); session_start(); print_r($_SESSION); session_destroy(); ~~~ 本地環境測試成功