一区二区久久-一区二区三区www-一区二区三区久久-一区二区三区久久精品-麻豆国产一区二区在线观看-麻豆国产视频

PHP獨(dú)立Session數(shù)據(jù)庫(kù)存儲(chǔ)操作類(lèi)分享

直接上代碼:
復(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

主站蜘蛛池模板: 婷婷久久精品 | 国产高清网址 | 成年黄网站色视频免费观看 | 米奇色网| 国产在线看不卡一区二区 | 国产亚洲精品观看91在线 | 巨大欧美黑人xxxxbbbb | 亚洲欧洲国产经精品香蕉网 | 国产亚洲欧美另类久久久 | 特黄视频| 青青热在线精品视频免费 | 精品在线观看国产 | 亚洲国产成人久久 | 伊人网中文字幕 | 色老板免费在线 | 韩国资源视频一区二区三区 | 在线观看精品视频一区二区三区 | 美女黄区| 国产精品久久久亚洲 | 国产美乳在线观看 | 亚洲综合色婷婷久久 | 自偷自偷自亚洲首页精品 | 免费成年人在线观看视频 | 91麻豆文化传媒有限公司 | 4hu四虎永久免在线视 | 国产亚洲精品国产福利在线观看 | 五月天天堂网 | 麻豆国产| 成人精品视频一区二区在线 | 99精品热线在线观看免费视频 | 免费国产一区 | 98香蕉草草视频在线精品看 | 成人在线午夜 | 在线小视频国产 | 一区二区亚洲视频 | 青草99 | 亚洲欧美手机在线观看 | 爽天天天天天天天 | 亚洲经典激情春色另类 | 日日摸人人看97人人澡 | 国产一区二区三区不卡观 |