I've started storing sessions in a database and for the most part it's working well but I've run across one problem. The garbage collection function that I feed to session_set_save_handler() doesn't seem to be doing it's job. My function looks like this:
function session_gc($life)
{
session_log("session_gc");
if(!mysql_select_db(session_db()))
{
session_log("session_gc select database error: " . mysql_error());
return(false);
}
$sql = "delete from " . session_table() . " where time < '" . date("YmdHis", time() - $life) . "'";
if($result = mysql_query($sql))
{
session_log("session_gc deleted " . mysql_affected_rows() . " rows.");
return(true);
}
else
{
session_log("session_gc error: " . mysql_error() . " with SQL: " . $sql);
return(false);
}
}
any idea where I'm going wrong here? Thanks for your help 🙂
