I have modified the gc function of my MySQL session handler to save data from expired session records to another table, 'sessions_saved'. I can get the session data out and into the sessions_saved table okay, but i can't restore some of the saved session variables i need for field values in the sessions_saved table.
In the code below, $sess_data['pid'] is always empty even though I can see it and its value in the serialized session data. The $pid value has already been set to a session value using: session_start(); $_SESSION['pid'] = $pid
function mysql_sess_gc ($sess_maxlife) {
(code here to query session table for expired sessions)
// loop thru expired sessions and save to 'sessions_saved' table: while (list($sess_id,$data) = mysql_fetch_array($r)) { $sess_data = unserialize($data);
$pid = $sess_data['pid']; $sid = $sess_data['sid'];
//store sessions in saved_sessions table
$query = "INSERT INTO sessions_saved (id,pid,sid,data) VALUES ('$sess_id',$pid,$sid,$data)";
$result = mysql_query ($query, $mysql_sess_conn_id); }
(...now delete expired sessions from sessions table)
}
andrew
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php