Location: PHPKode > scripts > Todolist.php > Todolist.php-0.9.15.4/include/session_handler_db.php
<?
/* ------------------------------------------------------------------------
 * session_mysql.php
 * ------------------------------------------------------------------------
 * PHP4 MySQL Session Handler
 * Version 1.00
 * by Ying Zhang (hide@address.com)
 * Last Modified: May 21 2000
 *
 * ------------------------------------------------------------------------
 * TERMS OF USAGE:
 * ------------------------------------------------------------------------
 * You are free to use this library in any way you want, no warranties are
 * expressed or implied.  This works for me, but I don't guarantee that it
 * works for you, USE AT YOUR OWN RISK.
 *
 * While not required to do so, I would appreciate it if you would retain
 * this header information.  If you make any modifications or improvements,
 * please send them via email to Ying Zhang <hide@address.com>.
 *
 * ------------------------------------------------------------------------
 * DESCRIPTION:
 * ------------------------------------------------------------------------
 * This library tells the PHP4 session handler to write to a MySQL database
 * instead of creating individual files for each session.
 *
 * Create a new database in MySQL called "sessions" like so:
 *
 * CREATE TABLE todo_sessions (
 *      sesskey char(32) not null,
 *      expiry int(11) unsigned not null,
 *      value text not null,
 *      PRIMARY KEY (sesskey)
 * );
 *
 * ------------------------------------------------------------------------
 * INSTALLATION:
 * ------------------------------------------------------------------------
 * Make sure you have MySQL support compiled into PHP4.  Then copy this
 * script to a directory that is accessible by the rest of your PHP
 * scripts.
 *
 * ------------------------------------------------------------------------
 * USAGE:
 * ------------------------------------------------------------------------
 * Include this file in your scripts before you call session_start(), you
 * don't have to do anything special after that.
 */

$SESS_DBHOST = $GLOBALS['DB_SERVER'];			/* database server hostname */
$SESS_DBNAME = $GLOBALS['DB_INSTANCE'];			/* database name */
$SESS_DBUSER = $GLOBALS['DB_USER'];		/* database user */
$SESS_DBPASS = $GLOBALS['DB_PASS'];		/* database password */

$SESS_DBH  = "";
$SESS_LIFE = get_cfg_var("session.gc_maxlifetime");

function sess_open($save_path, $session_name) {
	global $GLOBALS;

	if (! $GLOBALS['SESS_DBH'] = mysql_pconnect($GLOBALS['SESS_DBHOST'], $GLOBALS['SESS_DBUSER'], $GLOBALS['SESS_DBPASS'])) {
		echo "<li>Can't connect to" .  $GLOBALS['SESS_DBHOST'] . " as ".$GLOBALS['SESS_DBUSER'];
		echo "<li>MySQL Error: ", mysql_error();
		die;
	}

	if (! mysql_select_db($GLOBALS['SESS_DBNAME'], $GLOBALS['SESS_DBH'])) {
		echo "<li>Unable to select database ". $GLOBALS['SESS_DBNAME'];
		die;
	}

	return true;
}

function sess_close() {
	return true;
}

function sess_read($key) {
	global $GLOBALS;

	$qry = "SELECT value FROM todo_sessions WHERE sesskey = '$key' AND expiry > " . time();
	$qid = mysql_query($qry, $GLOBALS['SESS_DBH']);

	if (list($value) = mysql_fetch_row($qid)) {
		return $value;
	}

	//return false;
	return "";
}

function sess_write($key, $val) {
	global $GLOBALS;

	$expiry = time() + $GLOBALS['SESS_LIFE'];
	$value = addslashes($val);

	$qry = "INSERT INTO todo_sessions VALUES ('$key', $expiry, '$value')";
	$qid = mysql_query($qry, $GLOBALS['SESS_DBH']);

	if (! $qid) {
		$qry = "UPDATE todo_sessions SET expiry = $expiry, value = '$value' WHERE sesskey = '$key' AND expiry > " . time();
		$qid = mysql_query($qry, $GLOBALS['SESS_DBH']);
	}

	return $qid;
}

function sess_destroy($key) {
	global $GLOBALS;

	$qry = "DELETE FROM todo_sessions WHERE sesskey = '$key'";
	$qid = mysql_query($qry, $GLOBALS['SESS_DBH']);

	return $qid;
}

function sess_gc($maxlifetime) {
	global $GLOBALS;

	$qry = "DELETE FROM todo_sessions WHERE expiry < " . time();
	$qid = mysql_query($qry, $GLOBALS['SESS_DBH']);

	return mysql_affected_rows($GLOBALS['SESS_DBH']);
}

session_set_save_handler(
	"sess_open",
	"sess_close",
	"sess_read",
	"sess_write",
	"sess_destroy",
	"sess_gc");
?>
Return current item: Todolist.php