|
定制php4的session功能(7) 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"); ?> ========================================================================= test.php ==========================================================================
|