php把session寫入資料庫的類

class session_handler {
 protected $maxlifetime = null; proted🎜> proted $dbHandle = null;
 public $config = null;
 public static function init($args) {
 return new self($args);
 } p>
公用函數__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, "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 = '如果不存在`%s`則建立表(
 `session_id` varchar(255) NOT NULL,
 `session_data` text,
 `session_expires` char(10) NOT NULL,
 PRIMARY KEY ( ` session_id`)
 ) ENGINE=InnoDB 預設字元集=utf8 COLLATE=utf8_unicode_ci;';
 $sql = sprintf($sql, $this->config['table']);
 mysqli_query( $this->config['table']);
 mysqli_query( $this ->link, $sql);
 回傳true;
 }
 public function close() {
 return true;
 }
 public function read($session_id) {
 if(empty($session_id)) return null;
 $sql = '從`%s` 選擇` session_data` AS `data`，其中`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 = '替換為`%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($sesthis-datalink, $session_s. ,
 $newExpires);
 $result = mysqli_query($this->link, $sql);
 return mysqli_affected_rows($this->link);
 return mysqli_affected_rows($this->link);
}  p>
 public function destroy($session_id) {
 $sql = '從`%s` 刪除，其中`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來自“%s”，其中“session_expires” $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 $集合= null;
 public static function open($clean = false, $token = false) {
 if($clean) ob_end_clean();
 if($token) session_id($token);
 session_start();
 self::$collection = $_SESSION;
 }
 公用靜態函數id() {
 $num_args = func_num_args();
 if($num_args) {
 $args = func_get_arg(0);
 return session_id($args);
 }else
 return session_id();
 }
 }
公用靜態函式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;
 取消設定($_SESSION[$name]); 回傳 true; }
 public static function destroy() {
 session_destroy();
 }
}
$config = array(
 "host"=> "127.0 .0.1",
"用戶"=>"root",
"密碼"=>"123456",
"資料庫"=>"測試",
 "字元集"= > "utf8",
"table"=> "user_session");
session_handler::init($config);
session::open();
session: :set( "profile", array("id"=> 1, "user"=> "haowei", "vip-level"=> 6));