您好,欢迎访问一九零五行业门户网

使用session_set_save_handler函数重载SESSION存储方式之MYSQL_PHP教程

$db_server = server; /* database server hostname */
   $db_name = dbname; /* database name */
   $db_user = root; /* database user */
   $db_pass = *************; /* database password */
   $db_select_db = ;
   $sess_life = get_cfg_var(session.gc_maxlifetime);
   function sess_open($save_path, $session_name) {
   global $db_server, $db_name, $db_user, $db_pass, $db_select_db;
   if (! $db_select_db = mysql_pconnect($db_server, $db_user, $db_pass)) {
   echo sorry! mysql error : cant connect to $db_server as $db_user;
   echo mysql error: , mysql_error();
   die;
   }
   if (! mysql_select_db($db_name, $db_select_db)) {
   echo sorry! mysql error : unable to select database $db_name;
   die;
   }
   return true;
   }
   function sess_close() {
   return true;
   }
   function sess_read($sessionkey){
global $db_select_db, $sess_life;
$query = select sessionarray from cdb_global_sessions where sessionkey = .$sessionkey. and sessionexptime > . time();
$result = mysql_query($query, $db_select_db);
   if (list($sessionarray) = mysql_fetch_row($result)) {
   return $sessionarray;
   }
   return false;
   }
   function sess_write($sessionkey, $varray) {
   global $db_select_db, $sess_life;
   $sessionexptime = time() + $sess_life;
   $sessionarray = addslashes($varray);
   $query = insert into cdb_global_sessions (sessionkey,sessionexptime,sessionarray) values (.$sessionkey.,.$sessionexptime.,.$sessionarray.);
   $result = mysql_query($query, $db_select_db);
   if (!$result){
   $query = update cdb_global_sessions set sessionexptime = .$sessionexptime., sessionarray = .$sessionarray. where sessionkey = .$sessionkey. and sessionexptime > . time();
   $result = mysql_query($query, $db_select_db);
   }
   return $result;
   }
   function sess_destroy($sessionkey) {
   global $db_select_db;
   $query = delete from cdb_global_sessions where sessionkey = .$sessionkey.;
   $result = mysql_query($query, $db_select_db);
   return $result;
   }
   function sess_gc($maxlifetime) {
   global $db_select_db;
   $query = delete from cdb_global_sessions where sessionexptime    $result = mysql_query($query, $db_select_db);
   return mysql_affected_rows($db_select_db);
   }
   session_set_save_handler(
   sess_open,
   sess_close,
   sess_read,
   sess_write,
   sess_destroy,
   sess_gc);
session_start();
   ?>
http://www.bkjia.com/phpjc/508230.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/508230.htmltecharticle? $db_server = server; /* database server hostname */ $db_name = dbname; /* database name */ $db_user = root; /* database user */ $db_pass = *************; /* database pass...
其它类似信息

推荐信息