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'];
35 Logger::notice('no data for session', ['session_id' => $session_id, 'uri' => $_SERVER['REQUEST_URI']]);
41 * @brief Standard PHP session write callback
43 * This callback updates the DB-stored session data and/or the expiration depending
44 * on the case. Uses the Session::expire global for existing session, 5 minutes
45 * for newly created session.
47 * @param string $session_id Session ID with format: [a-z0-9]{26}
48 * @param string $session_data Serialized session data
49 * @return boolean Returns false if parameters are missing, true otherwise
52 public function write($session_id, $session_data)
62 $expire = time() + Session::$expire;
63 $default_expire = time() + 300;
65 if (Session::$exists) {
66 $fields = ['data' => $session_data, 'expire' => $expire];
67 $condition = ["`sid` = ? AND (`data` != ? OR `expire` != ?)", $session_id, $session_data, $expire];
68 DBA::update('session', $fields, $condition);
70 $fields = ['sid' => $session_id, 'expire' => $default_expire, 'data' => $session_data];
71 DBA::insert('session', $fields);
77 public function close()
82 public function destroy($id)
84 DBA::delete('session', ['sid' => $id]);
88 public function gc($maxlifetime)
90 DBA::delete('session', ["`expire` < ?", time()]);