3 namespace Friendica\Core\Session;
5 use Friendica\BaseObject;
6 use Friendica\Core\Logger;
7 use Friendica\Core\Session;
8 use Friendica\Database\DBA;
9 use SessionHandlerInterface;
12 * SessionHandler using database
14 * @author Hypolite Petovan <hypolite@mrpetovan.com>
16 class DatabaseSessionHandler extends BaseObject implements SessionHandlerInterface
18 public function open($save_path, $session_name)
23 public function read($session_id)
25 if (empty($session_id)) {
29 $session = DBA::selectFirst('session', ['data'], ['sid' => $session_id]);
30 if (DBA::isResult($session)) {
31 Session::$exists = true;
32 return $session['data'];
34 Logger::log("no data for session $session_id", Logger::TRACE);
40 * @brief Standard PHP session write callback
42 * This callback updates the DB-stored session data and/or the expiration depending
43 * on the case. Uses the Session::expire global for existing session, 5 minutes
44 * for newly created session.
46 * @param string $session_id Session ID with format: [a-z0-9]{26}
47 * @param string $session_data Serialized session data
48 * @return boolean Returns false if parameters are missing, true otherwise
51 public function write($session_id, $session_data)
61 $expire = time() + Session::$expire;
62 $default_expire = time() + 300;
64 if (Session::$exists) {
65 $fields = ['data' => $session_data, 'expire' => $expire];
66 $condition = ["`sid` = ? AND (`data` != ? OR `expire` != ?)", $session_id, $session_data, $expire];
67 DBA::update('session', $fields, $condition);
69 $fields = ['sid' => $session_id, 'expire' => $default_expire, 'data' => $session_data];
70 DBA::insert('session', $fields);
76 public function close()
81 public function destroy($id)
83 DBA::delete('session', ['sid' => $id]);
87 public function gc($maxlifetime)
89 DBA::delete('session', ["`expire` < ?", time()]);