\u5728\u505aecshop\u7684\u4e8c\u6b21\u5f00\u53d1\u8fc7\u7a0b\u4e2d,\u867d\u7136\u4ee3\u7801 \u592a\u8001\u592a\u4e71\u592a\u5197\u4f59\uff0c\u4f46ec\u7684\u4f1a\u8bdd\u5904\u7406\u7684\u8bbe\u8ba1\u611f\u89c9\u8fd8\u662f\u4e0d\u9519\u7684,\u5c31\u4f7f\u7528\u4e86$_SESSION\u8fd9\u4e2a\u5168\u5c40\u53d8\u91cf\u800c\u5df2,\u8fd9\u4e2a\u8bbe\u8ba1\u662f\u6700\u597d\u6539\u5584\u539f\u6765\u7684\u4f1a\u8bdd\u5904\u7406\u65b9\u5f0f\u7684\u5b58\u6570\u636e\u5e93\u8868\u7684\u8bdd,\u67092\u5f20\u8868,sessions \u8868\u4f7f\u7528\u5185\u5b58\u5b58\u50a8\u5f15\u64ce\uff0c\u4f1a\u8bdd\u5c5e\u4e8e\u4e34\u65f6\u6570\u636e\uff0c\u8fd9\u6837\u5b58\u53d6\u901f\u5ea6\u5f88\u5feb,\u5f53\u7136\u5f53\u4e34\u65f6\u6570\u636e\u5f88\u591a\u65f6,\u4f1a\u5360\u7528\u5185\u5b58\u7a7a\u95f4,\u5bf9\u4e8e\u8f83\u591a\u7684\u6570\u636e \u8fd8\u662f\u9700\u8981\u5b58\u5728\u78c1\u76d8\u4e0a,\u8fd9\u662f\u5c31\u9700\u8981sessions_data \u505a\u4e00\u4e2asessions\u8868\u7684\u5173\u8054\u6765\u5b58\u50a8\u8f83\u591a\u7684\u989d\u5916\u6570\u636e.register_shutdown_function \u53ef\u4ee5\u6ce8\u518c\u4e00\u4e2a\u81ea\u5b9a\u4e49\u7684\u51fd\u6570\uff0c\u5728\u7a0b\u5e8f\u8fd0\u884c\u7ed3\u675f\u4e4b\u524d \u6267\u884c\u3002 \u8868\u7ed3\u6784 CREATE TABLE `sessions` ( `sesskey` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ”, `expiry` int(10) unsigned NOT NULL DEFAULT ‘0’, `userid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’, `adminid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’, `ip` char(15) NOT NULL DEFAULT ”, `user_name` varchar(60) NOT NULL, `user_rank` tinyint(3) NOT NULL, `discount` decimal(3,2) NOT NULL, `email` varchar(60) NOT NULL, `data` char(255) NOT NULL DEFAULT ”, PRIMARY KEY (`sesskey`), KEY `expiry` (`expiry`) ) ENGINE=MEMORY DEFAULT CHARSET=utf8; CREATE TABLE `sessions_data` ( `sesskey` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ”, `expiry` int(10) unsigned NOT NULL DEFAULT ‘0’, `data` longtext NOT NULL, PRIMARY KEY (`sesskey`), KEY `expiry` (`expiry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; \u590d\u5236\u4ee3\u7801 \u7a0b\u5e8f\u6587\u4ef6\u6839\u636eecshop\u7684\u7c7b\u6709\u6539\u52a8 cls_session.php db.php \u6570\u636e\u5e93\u5904\u7406 fun.php \u7528\u5230\u7684\u51fd\u6570 init.php \u521d\u59cb\u5316\u7a0b\u5e8f\u6587\u4ef6 ————– \u4e24\u4e2ademo\u7a0b\u5e8f set.php get.php \u7a0b\u5e8f\u6587\u4ef6\u5185\u5bb9 cls_session.php <?php class cls_session { public $db = NULL; public $session_table = ”; public $max_life_time = 1800; public $session_name = ”; public $session_id = ”; public $session_expiry = ”; public $session_md5 = ”; public $session_cookie_path = ‘\/’; public $session_cookie_domain = ”; public $session_cookie_secure = false; public $_ip = ”; public $_time = 0; public function __construct(&$db, $session_table, $session_data_table, $session_name = ‘ECS_ID’, $session_id = ”) { $_SESSION = array(); $this->session_cookie_path = !empty($GLOBALS[‘cookie_path’]) ? $GLOBALS[‘cookie_path’] : “\/”; $this->session_cookie_domain = !empty($GLOBALS[‘cookie_domain’]) ? $GLOBALS[‘cookie_domain’] : ”; $this->session_cookie_secure = !empty($GLOBALS[‘cookie_secure’]) ? $GLOBALS[‘cookie_secure’] : false; $this->session_name = $session_name; $this->session_table = $session_table; $this->session_data_table = $session_data_table; $this->db = &$db; $this->_ip = real_ip(); $this->_time = time(); $this->session_id = $session_id == ” && !empty($_COOKIE[$this->session_name]) ? $_COOKIE[$this->session_name] : $session_id; if ($this->session_id) { $tmp_session_id = substr($this->session_id, 0, 32); if ($this->gen_session_key($tmp_session_id) == substr($this->session_id, 32)) { $this->session_id = $tmp_session_id; } else { $this->session_id = ”; } } if ($this->session_id) { $this->load_session(); } else { $this->gen_session_id(); setcookie($this->session_name, $this->session_id . $this->gen_session_key($this->session_id), 0, $this->session_cookie_path, $this->session_cookie_domain, $this->session_cookie_secure); } register_shutdown_function(array(&$this, ‘close_session’)); } public function gen_session_id() { $this->session_id = md5(uniqid(mt_rand(), true)); return $this->insert_session(); } public function gen_session_key($session_id) { static $ip = ”; if ($ip == ”) { $ip = substr($this->_ip, 0, strrpos($this->_ip, ‘.’)); } return sprintf(‘%08x’, crc32(ROOT_PATH . $ip . $session_id)); } public function insert_session() { return $this->db->exec(‘INSERT INTO ‘ . $this->session_table . ” (sesskey, expiry, ip, data) VALUES (‘” . $this->session_id . “‘, ‘” . $this->_time . “‘, ‘” . $this->_ip . “‘, ‘a:0:{}’)”); } public function load_session() { $session = $this->db->getOne(‘SELECT userid, adminid, user_name, user_rank, discount, email, data, expiry FROM ‘ . $this->session_table . ” WHERE sesskey = ‘” . $this->session_id . “‘”); if (empty($session)) { $this->insert_session(); $this->session_expiry = 0; $this->session_md5 = ’40cd750bba9870f18aada2478b24840a’; $_SESSION = array(); } else { if (!empty($session[‘data’]) && $this->_time – $session[‘expiry’] <= $this->max_life_time) { $this->session_expiry = $session[‘expiry’]; $this->session_md5 = md5($session[‘data’]); $_SESSION = unserialize($session[‘data’]); $_SESSION[‘user_id’] = $session[‘userid’]; $_SESSION[‘admin_id’] = $session[‘adminid’]; $_SESSION[‘user_name’] = $session[‘user_name’]; $_SESSION[‘user_rank’] = $session[‘user_rank’]; $_SESSION[‘discount’] = $session[‘discount’]; $_SESSION[’email’] = $session[’email’]; } else { $session_data = $this->db->getOne(‘SELECT data, expiry FROM ‘ . $this->session_data_table . ” WHERE sesskey = ‘” . $this->session_id . “‘”); if (!empty($session_data[‘data’]) && $this->_time – $session_data[‘expiry’] <= $this->max_life_time) { $this->session_expiry = $session_data[‘expiry’]; $this->session_md5 = md5($session_data[‘data’]); $_SESSION = unserialize($session_data[‘data’]); $_SESSION[‘user_id’] = $session[‘userid’]; $_SESSION[‘admin_id’] = $session[‘adminid’]; $_SESSION[‘user_name’] = $session[‘user_name’]; $_SESSION[‘user_rank’] = $session[‘user_rank’]; $_SESSION[‘discount’] = $session[‘discount’]; $_SESSION[’email’] = $session[’email’]; } else { $this->session_expiry = 0; $this->session_md5 = ’40cd750bba9870f18aada2478b24840a’; $_SESSION = array(); } } } } public function update_session() { $adminid = !empty($_SESSION[‘admin_id’]) ? intval($_SESSION[‘admin_id’]) : 0; $userid = !empty($_SESSION[‘user_id’]) ? intval($_SESSION[‘user_id’]) : 0; $user_name = !empty($_SESSION[‘user_name’]) ? trim($_SESSION[‘user_name’]) : 0; $user_rank = !empty($_SESSION[‘user_rank’]) ? intval($_SESSION[‘user_rank’]) : 0; $discount = !empty($_SESSION[‘discount’]) ? round($_SESSION[‘discount’], 2) : 0; $email = !empty($_SESSION[’email’]) ? trim($_SESSION[’email’]) : 0; unset($_SESSION[‘admin_id’]); unset($_SESSION[‘user_id’]); unset($_SESSION[‘user_name’]); unset($_SESSION[‘user_rank’]); unset($_SESSION[‘discount’]); unset($_SESSION[’email’]); $data = serialize($_SESSION); $this->_time = time(); if ($this->session_md5 == md5($data) && $this->_time < $this->session_expiry + 10) { return true; } $data = addslashes($data); if (isset($data{255})) { $this->db->autoReplace($this->session_data_table, array(‘sesskey’ => $this->session_id, ‘expiry’ => $this->_time, ‘data’ => $data), array(‘expiry’ => $this->_time, ‘data’ => $data)); $data = ”; } return $this->db->exec(‘UPDATE ‘ . $this->session_table . ” SET expiry = ‘” . $this->_time . “‘, ip = ‘” . $this->_ip . “‘, userid = ‘” . $userid . “‘, adminid = ‘” . $adminid . “‘, user_name='” . $user_name . “‘, user_rank='” . $user_rank . “‘, discount='” . $discount . “‘, email='” . $email . “‘, data = ‘$data’ WHERE sesskey = ‘” . $this->session_id . “‘ LIMIT 1″); } public function close_session() { $this->update_session(); if (mt_rand(0, 2) == 2) { $this->db->query(‘DELETE FROM ‘ . $this->session_data_table . ‘ WHERE expiry < ‘ . ($this->_time – $this->max_life_time)); } if ((time() % 2) == 0) { return $this->db->query(‘DELETE FROM ‘ . $this->session_table . ‘ WHERE expiry < ‘ . ($this->_time – $this->max_life_time)); } return true; } public function delete_spec_admin_session($adminid) { if (!empty($_SESSION[‘admin_id’]) && $adminid) { return $this->db->query(‘DELETE FROM ‘ . $this->session_table . ” WHERE adminid = ‘$adminid'”); } return false; } public function destroy_session() { $_SESSION = array(); setcookie($this->session_name, $this->session_id, 1, $this->session_cookie_path, $this->session_cookie_domain, $this->session_cookie_secure); $this->db->query(‘DELETE FROM ‘ . $this->session_data_table . ” WHERE sesskey = ‘” . $this->session_id . “‘ LIMIT 1″); return $this->db->query(‘DELETE FROM ‘ . $this->session_table . ” WHERE sesskey = ‘” . $this->session_id . “‘ LIMIT 1″); } public function get_session_id() { return $this->session_id; } public function get_users_count() { return $this->db->getOne(‘SELECT count(*) FROM ‘ . $this->session_table); } } ?> db.php <?php class db{ protected $pdo; public function __construct($dsn,$user,$pwd,$opt=”){ $this->pdo= new PDO($dsn,$user,$pwd,$opt); } public function getRow($sql, $limited = false){ $sql=$limited==true?trim($sql . ‘ LIMIT 1’):$sql; $pdo_statement = $this->pdo->query($sql); if($pdo_statement){ $res=$pdo_statement->fetchAll(PDO::FETCH_ASSOC); if($limited) return $res[0]; return $res; } return false; } public function getOne($sql){ $sql=trim($sql . ‘ LIMIT 1’); $pdo_statement = $this->pdo->query($sql); if($pdo_statement){ $res=$pdo_statement->fetch(PDO::FETCH_ASSOC); return $res; } return false; } public function autoReplace($table, $field_values, $update_values, $where = ”) { $field_descs = $this->getAll(‘DESC ‘ . $table); $primary_keys = array(); foreach ($field_descs AS $value) { $field_names[] = $value[‘Field’]; if ($value[‘Key’] == ‘PRI’) { $primary_keys[] = $value[‘Field’]; } } $fields = $values = array(); foreach ($field_names AS $value) { if (array_key_exists($value, $field_values) == true) { $fields[] = $value; $values[] = “‘” . $field_values[$value] . “‘”; } } $sets = array(); foreach ($update_values AS $key => $value) { if (array_key_exists($key, $field_values) == true) { if (is_int($value) || is_float($value)) { $sets[] = $key . ‘ = ‘ . $key . ‘ + ‘ . $value; } else { $sets[] = $key . ” = ‘” . $value . “‘”; } } } $sql = ”; if (empty($primary_keys)) { if (!empty($fields)) { $sql = ‘INSERT INTO ‘ . $table . ‘ (‘ . implode(‘, ‘, $fields) . ‘) VALUES (‘ . implode(‘, ‘, $values) . ‘)’; } } else { if (empty($where)) { $where = array(); foreach ($primary_keys AS $value) { if (is_numeric($value)) { $where[] = $value . ‘ = ‘ . $field_values[$value]; } else { $where[] = $value . ” = ‘” . $field_values[$value] . “‘”; } } $where = implode(‘ AND ‘, $where); } if ($where && (!empty($sets) || !empty($fields))) { $count=$this->getOne(“SELECT COUNT(*) as count FROM $table WHERE $where”); $count=$count[‘count’]; if (intval($count) > 0) { if (!empty($sets)) { $sql = ‘UPDATE ‘ . $table . ‘ SET ‘ . implode(‘, ‘, $sets) . ‘ WHERE ‘ . $where; } } else { if (!empty($fields)) { $sql = ‘REPLACE INTO ‘ . $table . ‘ (‘ . implode(‘, ‘, $fields) . ‘) VALUES (‘ . implode(‘, ‘, $values) . ‘)’; } } } } return $sql?$this->exec($sql):false; } public function getAll($sql) { $res = $this->pdo->query($sql); if ($res !== false) { $arr = array(); while ($row = $res->fetch(PDO::FETCH_ASSOC)) { $arr[] = $row; } return $arr; } return false; } public function __call($method,$args){ return call_user_func(array($this->pdo,$method),$args[0]); } } fun.php <?php function real_ip() { static $realip = NULL; if ($realip !== NULL) { return $realip; } if (isset($_SERVER)) { if (isset($_SERVER[‘HTTP_X_FORWARDED_FOR’])) { $arr = explode(‘,’, $_SERVER[‘HTTP_X_FORWARDED_FOR’]); \/* \u53d6X-Forwarded-For\u4e2d\u7b2c\u4e00\u4e2a\u975eunknown\u7684\u6709\u6548IP\u5b57\u7b26\u4e32 *\/ foreach ($arr AS $ip) { $ip = trim($ip); if ($ip != ‘unknown’) { $realip = $ip; break; } } } elseif (isset($_SERVER[‘HTTP_CLIENT_IP’])) { $realip = $_SERVER[‘HTTP_CLIENT_IP’]; } else { if (isset($_SERVER[‘REMOTE_ADDR’])) { $realip = $_SERVER[‘REMOTE_ADDR’]; } else { $realip = ‘0.0.0.0’; } } } else { if (getenv(‘HTTP_X_FORWARDED_FOR’)) { $realip = getenv(‘HTTP_X_FORWARDED_FOR’); } elseif (getenv(‘HTTP_CLIENT_IP’)) { $realip = getenv(‘HTTP_CLIENT_IP’); } else { $realip = getenv(‘REMOTE_ADDR’); } } preg_match(“\/[\\d\\.]{7,15}\/”, $realip, $onlineip); $realip = !empty($onlineip[0]) ? $onlineip[0] : ‘0.0.0.0’; return $realip; } init.php <?php define(“ROOT_PATH”,__DIR__); include “db.php”; include “fun.php”; include “cls_session.php”; $dsn=’mysql:dbname=test;host=127.0.0.1′; $user=”root”; $passwd=””; $opt=array( PDO :: ATTR_PERSISTENT => true ); $db=new db($dsn,$user,$passwd,$opt); $cls=new cls_session($db,’sessions’,”sessions_data”); \u590d\u5236\u4ee3\u7801 \u4e0b\u9762\u662f2\u4e2a\u8fd0\u884c\u6d4b\u8bd5\u7a0b\u5e8f set.php <?php include “init.php”; $_SESSION[‘a’]=”aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaajax”; \/\/$_SESSION[‘b’]=”aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaajax11212312333333333333333333333333333333333333333333333333333333333333333″; \/\/$_SESSION[‘c’]=”aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaajax11212312333333333333333333333333333333333333333333333333333333333333333″; \/\/$_SESSION[‘d’]=”aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaajax11212312333333333333333333333333333333333333333333333333333333333333333″; \/\/$_SESSION[‘e’]=”aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaajax11212312333333333333333333333333333333333333333333333333333333333333333″; \/\/$_SESSION[‘f’]=”aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaajax11212312333333333333333333333333333333333333333333333333333333333333333″; \/\/$_SESSION[‘g’]=”aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaajax11212312333333333333333333333333333333333333333333333333333333333333333″; $_SESSION[‘h’]=”aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaajax11212312333333333333333333333333333333333333333333333333333333333333333″; $_SESSION[‘i’]=”aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaajax11212312333333333333333333333333333333333333333333333333333333333333333″; unset($_SESSION[‘b’]); unset($_SESSION[‘c’]); unset($_SESSION[‘d’]); unset($_SESSION[‘e’]); unset($_SESSION[‘f’]); \/\/unset($_SESSION[‘h’]); \/\/unset($_SESSION[‘i’]); unset($_SESSION[‘g’]); var_dump($_SESSION); \u590d\u5236\u4ee3\u7801 get.php <?php include “init.php”; var_dump($_SESSION); \u6700\u91cd\u8981\u7684\u662fcls_session.php session\u5b58\u5e93 \u6709\u5229\u4e8e\u7edf\u8ba1\u5f53\u524d\u7f51\u7ad9\u5728\u7ebf\u7528\u6237 \u56e0\u4e3aecshop\u81f3\u59cb\u81f3\u7ec8\u6ca1\u7528session_start,session\u7684\u5b58\u53d6\u8fd8\u662f\u548c\u4ee5\u524d\u4e00\u6837\u76f4\u63a5\u64cd\u4f5c$_SESSION\u6570\u7ec4\uff0c\u6240\u4ee5\uff0c\u5982\u679c\u539f\u6765\u7684session\u662f\u5b58\u5728\u6587\u4ef6\u91cc,\u73b0\u5728\u53ef\u4ee5\u4e0d\u4fee\u6539\u4ee3\u7801\u7684\u4f7f\u7528\u8fd9\u79cd\u65b9\u5f0f <\/p>\n","protected":false},"excerpt":{"rendered":"
\u5728\u505aecshop\u7684\u4e8c\u6b21\u5f00\u53d1\u8fc7\u7a0b\u4e2d...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4925],"tags":[],"class_list":["post-199468","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199468","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/comments?post=199468"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199468\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}