复制代码 代码如下:
$result = mysqli_query($this->link, $sql);
return mysqli_affected_rows($this->link);
}
public function gc() {
$sql = 'DELETE FROM `%s` WHERE `session_expires` < "%u"';
$sql = sprintf($sql,
mysqli_real_escape_string($this->link, $this->config['table']),
time());
$result = mysqli_query($this->link, $sql);
return mysqli_affected_rows($this->link);
}
}
class session {
public static $collection = null;
public static function open($clean = false, $token = false) {
if($clean) ob_end_clean();
if($token) session_id($token);
session_start();
self::$collection = $_SESSION;
}
public static function id() {
$num_args = func_num_args();
if($num_args) {
$args = func_get_arg(0);
return session_id($args);
}else{
return session_id();
}
}
public static function get($name) {
return isset($_SESSION[$name]) ? $_SESSION[$name] : null;
}
public static function set($name, $value) {
$_SESSION[$name] = $value;
return true;
}
public static function delete($name) {
if(!isset($_SESSION[$name])) return null;
unset($_SESSION[$name]);
return true;
}
public static function destroy() {
session_destroy();
}
}
$config = array(
"host"=> "127.0.0.1",
"user"=> "root",
"password"=> "123456",
"database"=> "test",
"charset"=> "utf8",
"table"=> "user_session");
session_handler::init($config);
session::open();
session::set("profile", array("id"=> 1, "user"=> "haowei", "vip-level"=> 6));
本文原创发布php中文网,转载请注明出处,感谢您的尊重!
PHP会话管理与数据操作:清理过期会话
本文介绍了如何使用PHP进行数据库操作,包括查询和删除过期的会话记录。作者展示了如何设置session handler、初始化配置并操作user_session表,同时演示了session的开启、获取、设置和删除功能。
3483

被折叠的 条评论
为什么被折叠?



