PHP Session入库【练习】

最新推荐文章于 2021-03-26 14:33:01 发布

橡皮擦Mid

最新推荐文章于 2021-03-26 14:33:01 发布

阅读量642

点赞数

分类专栏：知识点整理文章标签： php session 入库

本文链接：https://blog.csdn.net/listen_for/article/details/53033046

版权

知识点整理专栏收录该内容

57 篇文章 1 订阅

订阅专栏

<?php 
   function connect(){
      $dsn=[
         'localhost'=> '127.0.0.1',
         'username' => 'root',
          'password' => 'root',
          'charset'  => 'utf-8',
          'dbname'   => "ten",
       ];
      $localhost=$dsn['localhost'];
      $username=$dsn['username'];
      $password=$dsn['password'];
      $dbname=$dsn['dbname'];
      $mysqli = new mysqli("$localhost","$username","$password","$dbname");
       if ($mysqli->connect_error) {
           die('Error : ('. $mysqli->connect_errno .') '. $mysqli->connect_error);
       }
      $charset=$dsn['charset'];
       $mysqli->query("set names $charset");
       return $mysqli;
    }



   function sess_open(){
       //echo __FUNCTION__."\r\n";
      connect();
   }

   function sess_close(){
     //echo __FUNCTION__."\r\n";
   }

   function sess_read($sess_id){
    // echo __FUNCTION__."\r\n";
     $mysql=connect();
     $sql = "select sess_data from `session` where sess_id = '$sess_id'";
     $result = $mysql->query($sql);  // $link 可以自己找到，或可以声明为全局变量
     if($rows = mysqli_fetch_assoc($result)){
       return $rows['sess_data'];
     }else{
       return '';
     }
   }

   function sess_write($sess_id, $sess_data){
     //echo __FUNCTION__."\r\n";
     $mysql=connect();
     //当前 session 存在则更新 sess_data
     //获得时间戳，mysql函数：unix_timestamp(); 
     //获得时间戳，php函数：time(); 
     $sql = "replace into `session` values('$sess_id', '$sess_data', now())";
     //on duplicate key update sess_data = '$sess_data'，times = now()";  //这是为了gc()
     return $mysql->query($sql);
   }

   function sess_destroy($sess_id){
     //echo __FUNCTION__."\r\n";
     $mysql=connect();
     $sql = "delete from `session` where sess_id = '$sess_id'"; 
     return $mysql->query($sql);
   }
   function sess_gc(){
    // echo __FUNCTION__."\r\n";
   }

   session_set_save_handler(
     'sess_open', 
     'sess_close',
     'sess_read',
     'sess_write',
     'sess_destroy',
     'sess_gc'
   );



//ibraries/session.inc.php at line 79  // session.save_handler 
// ini_set('session.save_handler', 'files');
// session_save_path("D:\web\session");
session_start();
if (!empty($path)) {
    session_save_path($path);
}
$_SESSION['name']=张三;
var_dump($_SESSION);

张三已存入数据库

关于PHP7.0 开启session session_start();报错：Fatal error: session_start(): Failed to initialize storage module: files（致命错误 :session_start():未能初始化存储模块）最后也没能解决，如果好心人看到请给我留个言该怎么做，谢谢！谢谢！