天天躁日日躁狠狠躁AV麻豆-天天躁人人躁人人躁狂躁-天天澡夜夜澡人人澡-天天影视香色欲综合网-国产成人女人在线视频观看-国产成人女人视频在线观看

PHP獨立Session數(shù)據(jù)庫存儲操作類分享

直接上代碼:
復(fù)制代碼 代碼如下:
class DbSession
{

    const TYPE_INT = 1;
    const TYPE_STR = 2;

    /**
     * Database configration
     *
     * @var array
     */
    private $_config = array(
            ‘host' => '127.0.0.1′,
            ‘port' => 3306,
            ‘username' => ‘root',
            ‘password' => ‘root',
            ‘dbname' => ‘db_mylab',
        ‘tablename' => ‘t_sessions',
        ‘cookie_prefix' => ‘mylab_',
        ‘cookiepath' => ‘/',
        ‘cookiedomain' => ”,
        ‘cookie_timeout' => 900
    );

    /**
     * Table fields type array
     *
     * @var array
     */
    private  $_db_fields = array(
        ‘crc32sid'      => self::TYPE_INT,
                ‘sessionhash'   => self::TYPE_STR,
                ‘idhash'        => self::TYPE_STR,
                ‘userid'        => self::TYPE_INT,
                ‘ipaddress'     => self::TYPE_STR,
                ‘lastactivity'  => self::TYPE_STR,
                ‘location'      => self::TYPE_STR,
        ‘loggedin'      => self::TYPE_INT,
        ‘heartbeat'     => self::TYPE_STR
        );

        /**
         * db obj
         *
         * @var mysqli object
         */
    private $_mysqli = null;

    /**
     * Weather the session was created or existed previously
     *
     * @var bool
     */
    private $_created = false;

    /**
     * Array of changes.
     *
     * @var array
     */
    private $_changes = array();

    /**
     * @var bool
     */

    private $_db_inited = false;

    /**
     * session host
     *
     * @var string
     */
    private $_session_host = ”;

    /**
     * session idhash
     *
     * @var string
     */
    private $_session_idhash = ”;

    private $_dbsessionhash = ”;

    private $_vars = array();

        public function __construct()
        {
                $this->_dbsessionhash = addslashes($this->get_cookie(‘sessionhash'));

            $this->_session_host = substr($_SERVER[‘REMOTE_ADDR'], 0, 15);

            #This should *never* change during a session
            $this->_session_idhash = md5($_SERVER[‘HTTP_USER_AGENT'] . self::fetch_substr_ip(self::fetch_alt_ip()) );

            $this->_init_config();
            $this->init_db();

            $gotsession = false;

            if ($this->_dbsessionhash)
            {
                $sql = ‘
                        SELECT *
                        FROM ‘ . $this->_config[‘tablename'] . ‘
                        WHERE   crc32sid = ‘ . sprintf(‘%u', crc32($this->_dbsessionhash)) . ‘
                            AND sessionhash = '‘ . $this->_dbsessionhash . ‘'
                                AND idhash = '‘ . $this->_session_idhash . ‘'
                        AND heartbeat > '‘ . date(‘Y-m-d H:i:s' ,TIMENOW

主站蜘蛛池模板: 久久精品免费电影 | 欧亚一卡二卡日本一卡二卡 | 国产亚洲精品 在线视频 香蕉 | 2020精品极品国产色在线 | 多肉np一女多男高h爽文现代 | 美女视频黄色的 | 亚洲AV精品无码国产一区 | 国产亚洲精品久久久久久久软件 | 亚洲色欲国产AV精品综合 | 扒开美女嫩bbb | 午夜影视不用充钱的免费 | 免费精品国偷自产在线在线 | 狠狠色狠狠色综合系列 | 亚洲国产在线播放在线 | 毛片手机在线看 | 国产精品永久免费视频 | 美女与男人对肌免费网站 | 水蜜桃亚洲一二三四在线 | 免费网站在线观看国产v片 免费完整版观看 | 99午夜高清在线视频在观看 | 超碰国产视频免费播放 | 3d在线看小舞被躁视频 | 国产成人精品区在线观看 | 国产精品伦理一二三区伦理 | 伊人久久综合网站 | 99riav9 精品香蕉免费大视频 | 国产精品永久免费 | 亚洲精品天堂在线 | 天美麻豆成人AV精品 | 久久re这里视频精品8 | 俄罗斯XXXXXL18 | 九色91精品国产网站 | 午夜无码片在线观看影院 | 污污内射久久一区二区欧美日韩 | 久久精品午夜一区二区福利 | 97影院理论午夜伦不卡偷 | 琪琪色原网20岁以下热热色原网站 | 色爱区综合激情五月综合激情 | 四虎影5151毛片在线看 | 亚洲一区成人 | 人与畜禽CROPROATION免费 人淫阁 |