加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > PHP教程 > 正文

PHP编程:php session 写入数据库

发布时间:2020-12-13 03:07:42 所属栏目:PHP教程 来源:网络整理
导读:《php session 写入数据库》要点: 本文介绍了php session 写入数据库,希望对您有用。如果有疑问,可以联系我们。 本文实例介绍了php session 写入数据库的办法,供大家参考研究,具体内容如下 PHP实例 ?php ## codeMaker Alpha 0.1.1 ( haowei.me )# T

《php session 写入数据库》要点:
本文介绍了php session 写入数据库,希望对您有用。如果有疑问,可以联系我们。

本文实例介绍了php session 写入数据库的办法,分享给大家供大家参考,具体内容如下PHP实例

<?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"),"read"),"write"),"destroy"),"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']),$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,$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,$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,$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));

以上就是本文的全部内容,希望对大家的学习有所赞助.PHP实例

《php session 写入数据库》是否对您有启发,欢迎查看更多与《php session 写入数据库》相关教程,学精学透。编程之家 52php.cn为您提供精彩教程。

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读