PHP 세션 교차 도메인 영구 스토리지 솔루션

CREATE TABLE sessions (
    id varchar(255) NOT NULL,
    data text NOT NULL,
    last_accessed int(11) DEFAULT NULL,
    PRIMARY KEY (id)
);

<?php
class CustomSessionHandler implements SessionHandlerInterface {
    private $db;

    public function open($savePath, $sessionName) {
        // 连接到数据库
        $this->db = new PDO('mysql:host=localhost;dbname=mydatabase', 'username', 'password');
        return true;
    }

    public function close() {
        // 关闭数据库连接
        $this->db = null;
        return true;
    }

    public function read($id) {
        // 从数据库中读取 Session 数据
        $stmt = $this->db->prepare('SELECT data FROM sessions WHERE id = ?');
        $stmt->execute([$id]);
        $result = $stmt->fetch(PDO::FETCH_ASSOC);
        return $result ? $result['data'] : '';
    }

    public function write($id, $data) {
        // 将 Session 数据写入数据库
        $stmt = $this->db->prepare('REPLACE INTO sessions (id, data, last_accessed) VALUES (?, ?, ?)');
        $stmt->execute([$id, $data, time()]);
        return true;
    }

    public function destroy($id) {
        // 从数据库中删除 Session 数据
        $stmt = $this->db->prepare('DELETE FROM sessions WHERE id = ?');
        $stmt->execute([$id]);
        return true;
    }

    public function gc($maxlifetime) {
        // 清理过期的 Session 数据
        $stmt = $this->db->prepare('DELETE FROM sessions WHERE last_accessed < ?');
        $stmt->execute([time() - $maxlifetime]);
        return true;
    }
}

// 注册自定义 Session 处理程序
$handler = new CustomSessionHandler();
session_set_save_handler($handler, true);

<?php
session_start();