dbsession.inc.php

套中小型企业网站建设

<?php
//====================================================
//		FileName:DBSession.class.php
//		Summary: session存入数据库的管理类
//		Author: ice_berg16(寻梦的稻草人)
//		CreateTime: 2004-11-09     
//		LastModifed:2004-11-09
//		copyright(c)2004 [e-mail]
//====================================================

class DBSession
{
	var $sessName;	//要使用的session名字	
	var $tblname;	//保存session的表名
	var $db;		//数据库访问层

	/* 函数 DBSession($db) 
	** 功能 构造函数
	** 参数 $db 数据库访问层
	*/
	function DBSession($db)
	{
		/*
		$this->db = $db;
		$this->tblName = "IB_session";
		$this->sessName= "IBID";
		$this->lifeTime= ini_get("session.gc_maxlifetime");	//超时的时间
		*/
		//session_name($this->sessName);
		//session_save_path($this->tblName);
		session_set_save_handler("IBOpen", "IBClose", "IBRead", "IBWrite", "IBDestroy", "IBgc");
		session_start();
	}

	/* 函数 set()
	** 功能 
	** 参数 
	*/
	function set()
	{
		
	}
}

define("SESSION_TABLE", "IB_session");
define("SESSION_EXPIRE_TIME", ini_get("session.gc_maxlifetime"));

//=====================================================
//  session操作系列函数
//  author: ice_berg16 
//  time:   2004-11-09
//  iceberg networks studio 
//=====================================================
function IBOpen($sessPath, $sessName)
{
	global $db;

	$db->connect(DB_HOST,DB_USER,DB_PWD,DB_NAME);

	return true;
}

function IBClose()
{
	return true;
}

function IBead($sessID)
{
	global $db;
	$sql = "SELECT sessData FROM " . SESSION_TABLE . " 
			WHERE sessID = '$sessID' AND expireTime > " . time();
	$db->query($sql);
	$db->fetchRow();	

	return $db->getValue("sessData");
}

function IBWrite($sessID, $sessData)
{
	global $db;
	$expireTime = time() + SESSION_EXPIRE_TIME;
	$sql = "REPLACE INTO " . SESSION_TABLE . "
			VALUES('$sessID', '$expireTime', '$sessData')";
	$db->query($sql);

	return $db->affectedRows();
}

function IBDestory($sessID)
{
	global $db;
	$sql = "DELETE FROM " . SESSION_TABLE . " 
			WHERE sessID = '$sessID'";
	$db->query($sql);

	return $db->affectedRows();
}

function IBgc()
{

	$sql = "DELETE FROM " . SESSION_TABLE . " 
			WHERE expireTime < " . time();
	$db->query($sql);

	return $db->affectedRows();
}
?>