ecshop的session放入memcache


本帖最后由 netaxcess 于 2012-8-20 22:38 编辑


经过很多朋友反馈,ecshop的session表在高并发下。容易提示is full错误。所以我们考虑将ecshop session放入memcache中。大概粗略写了个流程。运行目前没发现问题。把代码粘贴出来。大家一起来完善这个功能


1.  <?php
2. 3.  if (!defined('IN_ECS'))
4.  {
5.  die('Hacking attempt');
6.  }
7. 8.  class cls_session
9.  {
10.  var $db = NULL;
11.  var $session_table = '';
12. 13. 时间
14. 15.  var $session_name = '';
16.  var $session_id = '';
17. 18.  var $session_expiry = '';
19.  var $session_md5 = '';
20. 21.  var $session_cookie_path = '/';
22.  var $session_cookie_domain = '';
23.  var $session_cookie_secure = false;
24.  var $memcache = null;
25.  var $_ip = '';
26.  var $_time = 0;
27. 28.  function __c**truct(&$db, $session_table, $session_data_table, $session_name = 'ECS_ID', $session_id = '')
29.  {
30.  $this->cls_session($db, $session_table, $session_data_table, $session_name, $session_id);
31.  }
32. 33.  function cls_session(&$db, $session_table, $session_data_table, $session_name = 'ECS_ID', $session_id = '')
34.  { 
35. 36.  $this->memcache = new Memcache();
37.  $this->memcache->connect("127.0.0.1","11211");
38.  $GLOBALS['_SESSION'] = array();
39. 40.  if (!empty($GLOBALS['cookie_path']))
41.  {
42.  $this->session_cookie_path = $GLOBALS['cookie_path'];
43.  }
44.  else
45.  {
46.  $this->session_cookie_path = '/';
47.  }
48. 49.  if (!empty($GLOBALS['cookie_domain']))
50.  {
51.  $this->session_cookie_domain = $GLOBALS['cookie_domain'];
52.  }
53.  else
54.  {
55.  $this->session_cookie_domain = '';
56.  }
57. 58.  if (!empty($GLOBALS['cookie_secure']))
59.  {
60.  $this->session_cookie_secure = $GLOBALS['cookie_secure'];
61.  }
62.  else
63.  {
64.  $this->session_cookie_secure = false;
65.  }
66. 67.  $this->session_name = $session_name;
68.  $this->session_table = $session_table;
69.  $this->session_data_table = $session_data_table;
70. 71.  $this->db = &$db;
72.  $this->_ip = real_ip();
73. 74.  if ($session_id == '' && !empty($_COOKIE[$this->session_name]))
75.  {
76.  $this->session_id = $_COOKIE[$this->session_name];
77.  }
78.  else
79.  {
80.  $this->session_id = $session_id;
81.  }
82. 83.  if ($this->session_id)
84.  {
85.  $tmp_session_id = substr($this->session_id, 0, 32);
86.  if ($this->gen_session_key($tmp_session_id) == substr($this->session_id, 32))
87.  {
88.  $this->session_id = $tmp_session_id;
89.  }
90.  else
91.  {
92.  $this->session_id = '';
93.  }
94.  }
95. 96.  $this->_time = time();
97. 98.  if ($this->session_id)
99.  {
100.  $this->load_session();
101.  }
102.  else
103.  {
104.  $this->gen_session_id();
105. 106.  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);
107.  }
108. 109.  register_shutdown_function(array(&$this, 'close_session'));
110.  }
111. 112.  function gen_session_id()
113.  {
114.  $this->session_id = md5(uniqid(mt_rand(), true));
115. 116.  return $this->insert_session();
117.  }
118. 119.  function gen_session_key($session_id)
120.  {
121.  static $ip = '';
122. 123.  if ($ip == '')
124.  {
125.  $ip = substr($this->_ip, 0, strrpos($this->_ip, '.'));
126.  }
127. 128.  return sprintf('%08x', crc32(!empty($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] . ROOT_PATH . $ip . $session_id : ROOT_PATH . $ip . $session_id));
129.  }
130. 131.  function insert_session()
132.  { 
133.  $ar = array('expiry'=>$this->_time, 'ip'=>$this->_ip, 'data'=>'a:0:{}','userid'=>'0','adminid'=>'0','user_name'=>'','user_rank'=>'','discount'=>'','email'=>'');
134.  return $this->memcache->set($this->session_id, $ar, false, $this->max_life_time);
135. 136.  }
137. 138.  function load_session()
139.  { 
140.  $session = $this->memcache->get($this->session_id);
141.  //print_r($session);
142.  if (empty($session))
143.  {
144.  $this->insert_session();
145. 146.  $this->session_expiry = 0;
147.  $this->session_md5 = '40cd750bba9870f18aada2478b24840a';
148.  $GLOBALS['_SESSION'] = array();
149.  }
150.  else
151.  {
152.  if (!empty($session['data']) && $this->_time - $session['expiry'] <= $this->max_life_time)
153.  {
154.  $this->session_expiry = $session['expiry'];
155.  $this->session_md5 = md5(base64_decode($session['data']));
156. 157.  $GLOBALS['_SESSION'] = unserialize(base64_decode($session['data']));
158.  $GLOBALS['_SESSION']['user_id'] = $session['userid'];
159.  $GLOBALS['_SESSION']['admin_id'] = $session['adminid'];
160.  $GLOBALS['_SESSION']['user_name'] = $session['user_name'];
161.  $GLOBALS['_SESSION']['user_rank'] = $session['user_rank'];
162.  $GLOBALS['_SESSION']['discount'] = $session['discount'];
163.  $GLOBALS['_SESSION']['email'] = $session['email'];
164.  }
165.  else
166.  {
167.  $session_data = $this->db->getRow('SELECT data, expiry FROM ' . $this->session_data_table . " WHERE sesskey = '" . $this->session_id . "'");
168.  if (!empty($session_data['data']) && $this->_time - $session_data['expiry'] <= $this->max_life_time)
169.  {
170.  $this->session_expiry = $session_data['expiry'];
171.  $this->session_md5 = md5($session_data['data']);
172. 173.  $GLOBALS['_SESSION'] = unserialize(base64_decode($session['data']));
174.  $GLOBALS['_SESSION']['user_id'] = $session['userid'];
175.  $GLOBALS['_SESSION']['admin_id'] = $session['adminid'];
176.  $GLOBALS['_SESSION']['user_name'] = $session['user_name'];
177.  $GLOBALS['_SESSION']['user_rank'] = $session['user_rank'];
178.  $GLOBALS['_SESSION']['discount'] = $session['discount'];
179.  $GLOBALS['_SESSION']['email'] = $session['email'];
180.  }
181.  else
182.  {
183.  $this->session_expiry = 0;
184.  $this->session_md5 = '40cd750bba9870f18aada2478b24840a';
185.  $GLOBALS['_SESSION'] = array();
186.  }
187.  }
188.  }
189.  }
190. 191.  function update_session()
192.  {
193.  $adminid = !empty($GLOBALS['_SESSION']['admin_id']) ? intval($GLOBALS['_SESSION']['admin_id']) : 0;
194.  $userid = !empty($GLOBALS['_SESSION']['user_id']) ? intval($GLOBALS['_SESSION']['user_id']) : 0;
195.  $user_name = !empty($GLOBALS['_SESSION']['user_name']) ? trim($GLOBALS['_SESSION']['user_name']) : 0;
196.  $user_rank = !empty($GLOBALS['_SESSION']['user_rank']) ? intval($GLOBALS['_SESSION']['user_rank']) : 0;
197.  $discount = !empty($GLOBALS['_SESSION']['discount']) ? round($GLOBALS['_SESSION']['discount'], 2) : 0;
198.  $email = !empty($GLOBALS['_SESSION']['email']) ? trim($GLOBALS['_SESSION']['email']) : 0;
199.  unset($GLOBALS['_SESSION']['admin_id']);
200.  unset($GLOBALS['_SESSION']['user_id']);
201.  unset($GLOBALS['_SESSION']['user_name']);
202.  unset($GLOBALS['_SESSION']['user_rank']);
203.  unset($GLOBALS['_SESSION']['discount']);
204.  unset($GLOBALS['_SESSION']['email']);
205. 206.  $data = base64_encode(serialize(($GLOBALS['_SESSION'])));
207.  $this->_time = time();
208. 209.  if ($this->session_md5 == md5($data) && $this->_time < $this->session_expiry + 10)
210.  {
211.  return true;
212.  }
213. 214.  $data = addslashes($data);
215. 216.  if (isset($data{255}))
217.  {
218.  }
219. 220.  $ar = array('expiry'=>$this->_time, 'ip'=>$this->_ip, 'data'=>$data,'userid'=>$userid,'adminid'=>$adminid,'user_name'=>$user_name,'user_rank'=>$user_rank,'discount'=>number_format($discount,2,".",""),'email'=>$email);
221. 222.  return $this->memcache->replace($this->session_id, $ar, false, $this->max_life_time);
223. 224. 225.  }
226. 227.  function close_session()
228.  {
229.  $this->update_session();
230. 231. 232.  return true;
233.  }
234. 235.  function delete_spec_admin_session($adminid)
236.  {
237.  if (!empty($GLOBALS['_SESSION']['admin_id']) && $adminid)
238.  {
239. 240.  }
241.  else
242.  {
243.  return false;
244.  }
245.  }
246. 247.  function destroy_session()
248.  {
249.  $GLOBALS['_SESSION'] = array();
250. 251.  setcookie($this->session_name, $this->session_id, 1, $this->session_cookie_path, $this->session_cookie_domain, $this->session_cookie_secure);
252. 253.  /* ECSHOP 自定义执行部分 */
254.  if (!empty($GLOBALS['ecs']))
255.  {
256.  $this->db->query('DELETE FROM ' . $GLOBALS['ecs']->table('cart') . " WHERE session_id = '$this->session_id'");
257.  }
258.  /* ECSHOP 自定义执行部分 */
259. 260.  return $this->memcache->delete($this->session_id);
261.  }
262. 263.  function get_session_id()
264.  {
265.  return $this->session_id;
266.  }
267. 268.  function get_users_count()
269.  {
270.  $all_items = $this->db->getExtendedStats();
271. 272.  return $all_items['127.0.0.1:11211']['curr_items'];//由于有其他key的缓存,因此这只是个接近数值
273. 274.  }
275.  }
276. 277.  ?>



复制代码




修改记录:

编辑函数改进


1.  function delete_spec_admin_session($adminid)
2.  {
3.  if (!empty($GLOBALS['_SESSION']['admin_id']) && $adminid)
4.  {
5.  //return $this->db->query('DELETE FROM ' . $this->session_table . " WHERE adminid = '$adminid'");
6.  $list = $mem->getExtendedStats('items');
7.  foreach($list['127.0.0.1:11211']['items'] as $k => $v){
8.  //echo $key = $k;echo "--";
9.  // echo $count = $v['number'];
10.  //echo "<br>";echo "<br>";echo "<br>";
11.  $ar = $mem-> getExtendedStats("cachedump", $key, $count);
12.  foreach($ar['127.0.0.1:11211'] as $kk => $vv){
13. 14.  // echo $kk;
15.  //echo "<br>";
16.  $row = $mem->get($kk);
17.  if($row['adminid'] == $adminid){
18. 19.  $mem->delete($kk);
20. 21.  }
22. 23.  }
24.  }
25.  }
26.  else
27.  {
28.  return false;
29.  }
30.  }



复制代码



下载测试。。 

ecshop的session放入memcache_HTTP

 cls_session.rar



修改干掉管理员id下的memcache key

    1.  function delete_spec_admin_session($adminid)
    2.      {
    3.          if (!empty($GLOBALS['_SESSION']['admin_id']) && $adminid)
    4.          {
    5.             //return $this->db->query('DELETE FROM ' . $this->session_table . " WHERE adminid = '$adminid'");
    6.                      $list = $mem->getExtendedStats('items');
    7.                          foreach($list['127.0.0.1:11211']['items'] as $k => $v){
    8.                                  //echo $key = $k;echo "--";
    9.                          //        echo $count = $v['number'];
    10.                                  //echo "<br>";echo "<br>";echo "<br>";
    11.                                  $ar = $mem-> getExtendedStats("cachedump", $key, $count);
    12.                                  foreach($ar['127.0.0.1:11211'] as $kk => $vv){
    13.                                          
    14.                                  //        echo $kk;
    15.                                          //echo "<br>";
    16.                                          $row = $mem->get($kk);
    17.                                          if($row['adminid'] == $adminid){
    18.                                                  
    19.                                                  $mem->delete($kk);
    20.  
    21.                                          }
    22.  
    23.                                  }
    24.                          }
    25.          }
    26.          else
    27.          {
    28.              return false;
    29.          }
    30.      }


    复制代码