jamiecressey / php-mysql-session-handler
MySQL PHP Session Handler
Installs: 658
Dependents: 0
Suggesters: 0
Security: 0
Stars: 14
Watchers: 2
Forks: 15
Open Issues: 0
Requires
- php: >=5.4.0
Suggests
- jayc89/php-mysql-pdo-database-class: Quick and effective MySQL PDO class
This package is not auto-updated.
Last update: 2024-11-23 19:37:33 UTC
README
This repository contains a custom PHP session handler using MySQL as a backend. The class has been tested successfully using PHP-FPM and HHVM. To get started, it is recommended, although not required, this class is used in conjunction with PHP-MySQL-PDO-Database-Class.
How to Install
using Composer
Create a composer.json file in your project root:
{ "require": { "jamiecressey/php-mysql-session-handler": "dev-master" } }
Then run the following composer command:
$ php composer.phar install
How to use
CREATE TABLE IF NOT EXISTS `sessions` ( `id` varchar(32) NOT NULL, `timestamp` int(10) unsigned DEFAULT NULL, `data` mediumtext, PRIMARY KEY (`id`), KEY `timestamp` (`timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
require 'vendor/autoload.php'; $handler = new \JamieCressey\SessionHandler\SessionHandler(); // Pass DB details to create a new MySQLi connection $handler->setDbDetails('localhost', 'username', 'password', 'database'); // OR alternatively, inject an existing MySQLi resource // $db = new Db(); // See: https://github.com/jamiecressey/php-mysql-pdo-database-class // $handler->setDbConnection($db); $handler->setDbConnection($db); $handler->setDbTable('sessions'); session_set_save_handler($handler, true); session_start();
Authors
License
MIT Public License