## 实现接口类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(); ~~~ 本地环境测试成功