Session handler og LOCK TABLE problem.
<?# -----------------------------------------------------------------------------------------------------------
# Database functions
# -----------------------------------------------------------------------------------------------------------
function databaseConnection() {
mysql_connect("x", "x", "x") or trigger_error(mysql_error());
mysql_select_db("x") or trigger_error(mysql_error());
return true;
}
function query($query) {
return mysql_query($query) or trigger_error(mysql_error());
}
# -----------------------------------------------------------------------------------------------------------
# Session handler
# -----------------------------------------------------------------------------------------------------------
function sessionOpen() {
return databaseConnection();
}
function sessionClose() {
return true;
}
function sessionRead($identifier) {
$maxage = time() - ini_get("session.gc_maxlifetime");
$result = mysql_query("SELECT data FROM session WHERE identifier = '$identifier' AND time >= $maxage") or trigger_error(mysql_error());
$array = mysql_fetch_array($result);
return $array['data'] ? $array['data'] : "";
}
function sessionWrite($identifier, $data) {
$result = mysql_query("REPLACE session SET identifier = '$identifier', data = '$data', time = ".time()) or trigger_error(mysql_error());
return true;
}
function sessionDestroy($identifier) {
$result = mysql_query("DELETE FROM session WHERE identifier = '$identifier'") or trigger_error(mysql_error());
return true;
}
function sessionGc($maxlifetime) {
$maxage = time() - $maxlifetime;
$result = mysql_query("DELETE FROM session WHERE time < $maxage") or trigger_error(mysql_error());
return true;
}
# -----------------------------------------------------------------------------------------------------------
# Error handler
# -----------------------------------------------------------------------------------------------------------
function errorHandler($errno, $errstr, $errfile, $errline, $context) {
switch($errno) {
case E_ERROR:
break;
case E_WARNING:
break;
case E_PARSE:
break;
case E_NOTICE:
break;
case E_CORE_ERROR:
break;
case E_CORE_WARNING:
break;
case E_COMPILE_ERROR:
break;
case E_COMPILE_WARNING:
break;
case E_USER_ERROR:
break;
case E_USER_WARNING:
break;
case E_USER_NOTICE:
break;
default:
break;
}
echo "<h1>Oh my God - Error!</h1>";
while (list($key, $val) = each($context)) {
echo $key."=".$val."<p>";
}
die("errno: ".$errno."<p>errstr: ".$errstr."<p>errfile: ".$errfile."<p>errline: ".$errline."<p>error_reporting() says: ".error_reporting());
}
# -----------------------------------------------------------------------------------------------------------
# Formatting functions
# -----------------------------------------------------------------------------------------------------------
function htmlout($string) {
return htmlentities(stripslashes($string), ENT_QUOTES);
}
# -----------------------------------------------------------------------------------------------------------
# PHP configuration
# -----------------------------------------------------------------------------------------------------------
if (set_error_handler("errorHandler") === FALSE)
die("Could not set custom error handler 'errorHandler'");
if (!ini_get("magic_quotes_gpc"))
trigger_error("'magic_quotes_gpc' must be on");
if (ini_get("register_globals"))
trigger_error("'register_globals' must be off");
if (!ini_set("session.save_handler", "user"))
trigger_error("Could not set 'session.save_handler' = 'user'");
if (!session_set_save_handler("sessionOpen", "sessionClose", "sessionRead", "sessionWrite", "sessionDestroy", "sessionGc"))
trigger_error("Could not set custom session handler");
# -----------------------------------------------------------------------------------------------------------
# Global calls
# -----------------------------------------------------------------------------------------------------------
session_start();
query("LOCK tables enHeltAndenTabel READ");
?>
Nogle der kan fortælle mig, hvorfor ovenstående giver følgende fejl:
"Table 'session' was not locked with LOCK TABLES"
(line 36)
Fejlen opstår fra sessionWrite query'en. Retter jeg denne fra en REPLACE til REPLACE DELAYED,
så fungerer ovenstående uden fejl.
Og uden query("LOCK tables enHeltAndenTabel READ"); fungerer scriptet naturligvis i sig selv fint.
Men hvorfor har en READ LOCK på enHeltAndenTabel noget som helst med session tabellen at gøre, som
session handleren anvender?
