Session-type database interaction jumps
Query ("update ". self: $ table. "set value = '$ session_data', expiry = '$ session_expire' where session_id = '$ session_id'"); self: close ();} self :: $ is_del = TRUE;}/*** destroy ***/public static function destroy () {$ session_id = self: get_session_id (); $ _ COOKIE ['wbsid '] = ''; self: open (); self: $ dbo-> query (" delete from ". self: $ table. "where session_id = '$ session_id'"); self: close ();}/*** read private **/private static f Unction read () {$ session_id = self: $ session_id; if (! $ Session_id) {$ session_id = self: get_session_id ();} if (! $ Session_id) return array (); $ user_agent = isset ($ _ SERVER ['http _ USER_AGENT '])? Md5 ($ _ SERVER ['http _ USER_AGENT ']): ''; $ client_ip = Fun: getIp (); $ session_expire = TIME-self: get_gc_maxtime (); $ rs = self: $ dbo-> fetchRow ("select session_id, value, agent, ip from ". self: $ table. "where session_id = '$ session_id' and expiry> '$ session_expire'"); if (! $ Rs | $ rs ['agent']! = $ User_agent | $ rs ['IP']! = $ Client_ip) {return FALSE;} self: $ session_id = $ rs ['session _ id']; return unserialize ($ rs ['value']);} /*** session write private **/private static function write (array $ session_data) {$ session_id = self: $ session_id; if (! $ Session_id) {$ session_id = self: get_session_id () ;}$ session_expire = TIME + self: get_gc_maxtime (); $ user_agent = isset ($ _ SERVER ['http _ USER_AGENT '])? Md5 ($ _ SERVER ['http _ USER_AGENT ']): ''; $ client_ip = Fun: getIp (); $ session_data = serialize ($ session_data); if (self:: $ session_id & self: $ session_id ==$ session_id) {self ::$ dbo-> query ("update ". self: $ table. "set value = '$ session_data', expiry = '$ session_expire', agent = '$ user_agent', ip = '$ client_ip' where session_id = '$ session_id '");} else {self ::$ session_id = $ session_id = self: create_session_id (); Self: $ dbo-> query ("insert ". self: $ table. "(session_id, value, expiry, agent, ip) values ('$ session_id', '$ session_data', '$ session_expire', '$ user_agent', '$ client_ip ') ");} return true;}/*** session update private **/private static function update () {if (! Self: $ is_update) {$ session_id = self ::$ session_id; $ session_expire = TIME + self: get_gc_maxtime (); self :: $ dbo-> query ("update ". self: $ table. "set expiry = '$ session_expire' where session_id = '$ session_id'");} self: $ is_update = TRUE;} private static function close () {if (! Self: $ is_gc & mt_rand (1, self: $ gc_rate_de) % self: $ gc_rate_co = 0) {self: gc ();} self :: $ is_gc = TRUE;}/*** randomly triggered by clearing expired sessions **/private static function gc () {$ session_expire = TIME-self: get_gc_maxtime (); self :: $ dbo-> query ("delete from ". self: $ table. "where expiry <'$ session_expire'");} private static function get_session_id () {if (isset ($ _ COOKIE ['wbsid ']) & strlen ($ _ COOKIE ['wbsid']) = 32) {$ s Id = $ _ COOKIE ['wbsid ']; setcookie ('wbsid', $ sid, TIME + self: get_gc_maxtime (), self: $ path, self :: $ domain, self ::$ secure, self ::$ httponly); return $ sid;} return null;} private static function create_session_id () {$ sid = self :: get_session_id (); if (! $ Sid) {$ sid = Fun: getIp (). TIME. microtime (TRUE ). mt_rand (0,100), mt_rand (100000,900 00000); $ sid = md5 (self: $ pre_key. $ sid); setcookie ('wbsid', substr ($ sid, 0, 32), TIME + self: get_gc_maxtime (), self: $ path, self :: $ domain, self ::$ secure, self ::$ httponly);} return $ sid;} public static function get_gc_maxtime () {return self ::$ gc_max_time ;}}