Phpsession database _ PHP Tutorial

Source: Internet
Author: User
Phpsession is stored in the database. It is very easy to store the sesison in the phpsession database. it is used to perform CRUD operations on the database based on session_id. the session_set_save_handler method is mainly used to store the database from the php session.

It is very easy to save sesison to the database. it is used to perform CRUD operations on the database based on session_id. session_set_save_handler is used to customize the session execution method,

First create a data table


CREATE TABLE `sessions` ( `session_id` varchar(255) NOT NULL, `session_expires` int(11) DEFAULT NULL, `session_data` text, PRIMARY KEY (`session_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

Then encapsulate the tool class used to operate the session:
 LifeTime = get_1__var ("session. gc_maxlifetime "); $ dbHandle = mysql_connect (" localhost "," root "," root "); $ dbSel = mysql_select_db (" mysession ", $ dbHandle); if (! $ DbHandle |! $ DbSel) return false; $ this-> dbHandle = $ dbHandle; return true;} function close () {$ this-> gc (ini_get ('session. gc_maxlifetime '); return @ mysql_close ($ this-> dbHandle);} function read ($ sessID) {$ res = mysql_query ("SELECT session_data AS d FROM sessions WHERE session_id = '$ sessID' AND session_expires> ". time (), $ this-> dbHandle); if ($ row = mysql_fetch_assoc ($ res) return $ row ['D']; return "";} fu Nction write ($ sessID, $ sessData) {$ newExp = time () + $ this-> lifeTime; $ res = mysql_query ("SELECT * FROM sessions WHERE session_id = '$ sessID'", $ this-> dbHandle); if ($ res) {mysql_query ("UPDATE sessions SET session_expires = '{$ newExp}', session_data = '{$ sessData}' WHERE session_id = '{$ sessID }'", $ this-> dbHandle); if (mysql_affected_rows ($ this-> dbHandle) return true;} else {mysql_query ("INSERT INT O sessions (session_id, session_expires, session_data) VALUES ('{$ sessID}', '{$ newExp}', '{$ sessData }')", $ this-> dbHandle); if (mysql_affected_rows ($ this-> dbHandle) return true;} return false;} function destroy ($ sessID) {mysql_query ("delete from sessions WHERE session_id = '$ sessID'", $ this-> dbHandle); if (mysql_affected_rows ($ this-> dbHandle) return true; return false;} function gc ($ sessMaxLife Time) {mysql_query ("delete from sessions WHERE session_expires <". time (), $ this-> dbHandle); return mysql_affected_rows ($ this-> dbHandle) ;}# test the session. it is found that the database does not store data only session_id, and session_expires. In fact, session_data exists, but we cannot see $ session = new session (); session_set_save_handler (array (& $ session, "open"), array (& $ session, "close"), array (& $ session, "read"), array (& $ session, "write"), array (& $ session, "destr Oy "), array (& $ session," gc "); session_start (); $ session-> write (session_id (), json_encode (array ("name" => "gxx", "pass" => "123"); echo $ session-> read (session_id ();?> Illustrations are not supported here ..
Database data:

S430j9t480ocbovq6a7a0rlk22 1435054078

Session query data:
JSON
  • Name "gxx"
  • Pass "123" should not be blinded by things ....

Http://www.bkjia.com/PHPjc/1022402.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/1022402.htmlTechArticlephp session database this sesison saved to the database is very simple, is according to session_id on the database CRUD operations, mainly used, session_set_save_handler this method, from...

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.