-
UID:2
-
- 注册时间2004-11-08
- 最后登录2024-01-27
- 在线时间6994小时
-
- 发帖11224
- 搜Ta的帖子
- 精华61
- 金钱140531
- 威望9948
- 贡献值701
- 好评度8170
-
访问TA的空间加好友用道具
|
默認配置都不變。 建立一個Session數據表: CREATE TABLE sessions ( sesskey char(32) not null, expiry int(11) unsigned not null, value text not null, PRIMARY KEY (sesskey) );
然後建立文件:session_inc.php <?php $SESS_DBHOST = "localhost"; /* database server hostname */ $SESS_DBNAME = "test"; /* database name */ $SESS_DBUSER = "root"; /* database user */ $SESS_DBPASS = "123456"; /* database password */
$SESS_DBH = ""; $SESS_LIFE = get_cfg_var("session.gc_maxlifetime");
function sess_open($save_path, $session_name) { global $SESS_DBHOST, $SESS_DBNAME, $SESS_DBUSER, $SESS_DBPASS, $SESS_DBH;
if (! $SESS_DBH = mysql_pconnect($SESS_DBHOST, $SESS_DBUSER, $SESS_DBPASS)) { echo "<li>Can't connect to $SESS_DBHOST as $SESS_DBUSER"; echo "<li>MySQL Error: " . mysql_error(); die; }
if (! mysql_select_db($SESS_DBNAME, $SESS_DBH)) { echo "<li>Unable to select database $SESS_DBNAME"; die; }
return true; }
function sess_close() { return true; }
function sess_read($key) { global $SESS_DBH, $SESS_LIFE;
$qry = "SELECT value FROM sessions WHERE sesskey = '$key' AND expiry > " . time(); $qid = mysql_query($qry, $SESS_DBH);
if (list($value) = mysql_fetch_row($qid)) { return $value; }
return false; }
function sess_write($key, $val) { global $SESS_DBH, $SESS_LIFE;
$expiry = time() + $SESS_LIFE; //过期时间 $value = addslashes($val);
$qry = "INSERT INTO sessions VALUES ('$key', $expiry, '$value')"; $qid = mysql_query($qry, $SESS_DBH);
if (! $qid) { $qry = "UPDATE sessions SET expiry = $expiry, value = '$value' WHERE sesskey = '$key' AND expiry > " . time(); $qid = mysql_query($qry, $SESS_DBH); }
return $qid; }
function sess_destroy($key) { global $SESS_DBH;
$qry = "DELETE FROM sessions WHERE sesskey = '$key'"; $qid = mysql_query($qry, $SESS_DBH);
return $qid; }
function sess_gc($maxlifetime) { global $SESS_DBH;
$qry = "DELETE FROM sessions WHERE expiry < " . time(); $qid = mysql_query($qry, $SESS_DBH);
return mysql_affected_rows($SESS_DBH); }
session_set_save_handler( "sess_open", "sess_close", "sess_read", "sess_write", "sess_destroy", "sess_gc");
session_start(); ?>
然後其它文件就可以引用它了,在原來session_start()的地方改為require("session_inc.ph")就行了 [ 此贴被XChinux在2005-09-18 22:22重新编辑 ]
|