Php session write to database, phpsession

Source: Internet
Author: User
Tags php session php example

Php session write to database, phpsession

This article introduces the php session Writing Method to the database and shares it with you for your reference. The specific content is as follows:

<?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"),    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 = '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']),     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 = 'REPLACE INTO `%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($this->link, $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,     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 FROM `%s` WHERE `session_expires` < "%u"';    $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 $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));

The above is all the content of this article, hoping to help you learn.

Articles you may be interested in:
  • PHP uses the mysql database to store session code
  • Session: Share the php class stored in the database
  • Php example of writing session into database
  • PHP independent Session database storage operation sharing
  • Use the session_set_save_handler () function in php to save the session to the MySQL database instance.
  • PHP stores session information to database class instances
  • Php writes sessions to the database
  • Php session-based database interaction class instances

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.