Home > Web Front-end > HTML Tutorial > Use the session_set_save_handler function to save the session in the database. After that, the session cannot cross pages_html/css_WEB-ITnose

Use the session_set_save_handler function to save the session in the database. After that, the session cannot cross pages_html/css_WEB-ITnose

WBOY
Release: 2016-06-24 11:48:12
Original
1267 people have browsed it

<?php/*============================文件说明========================================@filename:     session.class.php@description:  数据库保存在线用户session,实现在线用户功能!@notice:       session过期时间一个小时,因为我们的站点是使用cookie(有效时间是1小时)登录。               因此我们只记录用户登录的时间,而不是刷新一次更新一次               删除数据库中session记录的动作发生在用户超时后执行这个文件或正常退出(session_destory)@database:     database:sessions  field:sessionid(char32),uid(int10),last_visit(int10)=============================================================================*/class session {     private $db; 	private $lasttime=3600;//超时时间:一个小时    function session(&$db) {         $this->db = &$db;        session_module_name('user'); //session文件保存方式,这个是必须的!除非在Php.ini文件中设置了        session_set_save_handler(             array(&$this, 'open'), //在运行session_start()时执行            array(&$this, 'close'), //在脚本执行完成或调用session_write_close() 或 session_destroy()时被执行,即在所有session操作完后被执行            array(&$this, 'read'), //在运行session_start()时执行,因为在session_start时,会去read当前session数据            array(&$this, 'write'), //此方法在脚本结束和使用session_write_close()强制提交SESSION数据时执行            array(&$this, 'destroy'), //在运行session_destroy()时执行            array(&$this, 'gc') //执行概率由session.gc_probability 和 session.gc_divisor的值决定,时机是在open,read之后,session_start会相继执行open,read和gc        );         session_start(); //这也是必须的,打开session,必须在session_set_save_handler后面执行    }       function unserializes($data_value) {         $vars = preg_split(             '/([a-zA-Z_\x7f-\xff][a-zA-Z0-9_\x7f-\xff]*)\|/',             $data_value, -1, PREG_SPLIT_NO_EMPTY |             PREG_SPLIT_DELIM_CAPTURE         );         for ($i = 0; isset($vars[$i]); $i++) {             $result[$vars[$i++]] = unserialize($vars[$i]);         }         return $result;     }     function open($path, $name) {         return true;     }     function close() { 	    $this->gc($this->lasttime);        return true;     }    function read($SessionKey){	    $sql = "SELECT uid FROM sessions WHERE session_id = '".$SessionKey."' limit 1"; 		$query =$this->db->query($sql);		if($row=$this->db->fetch_array($query)){		  return $row['uid'];		}else{            return ""; 		}		    }     function write($SessionKey,$VArray) { 	   require_once(MRoot.DIR_WS_CLASSES .'db_mysql_class.php');	   $db1=new DbCom();	  // make a connection to the database... now	   $db1->connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE);	   $db1->query("set names utf8");	   $this->db=$db1;       $SessionArray = addslashes($VArray);		$data=$this->unserializes($VArray);	  	    	 		$sql0 = "SELECT uid FROM sessions WHERE session_id = '".$SessionKey."' limit 1"; 		$query0 =$this->db->query($sql0);		if($this->db->num_rows($query0)<=0){			if (isset($data['webid']) && !empty($data['webid'])) { 			   $this->db->query("insert into `sessions` set `session_id` = '$SessionKey',uid='".$data['webid']."',last_visit='".time()."'");			} 		  			return true;		}else{			/*$sql = "update `sessions` set "; 			if(isset($data['webid'])){			$sql .= "uid = '".$data['webid']."', " ;			}			$sql.="`last_visit` = null " 				  . "where `session_id` = '$SessionKey'"; 				 			$this->db->query($sql); */			return true; 		}	    }   function destroy($SessionKey) {      $this->db->query("delete from `sessions` where `session_id` = '$SessionKey'");      return true;    }    function gc($lifetime) {       $this->db->query("delete from `sessions` where unix_timestamp(now()) -`last_visit` > '".$this->lasttime."'");       return true;   }   } ?>
Copy after login

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template