kavalanche/sql-session-handler

There is no license information available for the latest version (v1.0.1) of this package.

SQL session handler for PHP

v1.0.1 2024-02-03 21:55 UTC

This package is auto-updated.

Last update: 2024-09-03 23:25:18 UTC


README

SQL session handler for PHP

Usage

  1. Require kavalanche/sql-session-handler.

     composer require kavalanche/sql-session-handler
    
  2. Create instance of Kavalanche\SqlSessionHandler\SqlSessionHandler and inject your database handle (PDO) into it.

     $SqlSessionHandler = new Kavalanche\SqlSessionHandler\SqlSessionHandler($db);
     session_set_save_handler($SqlSessionHandler);
     session_start();
    

Database structure

CREATE TABLE `session` (
  `id` char(32) CHARACTER SET ascii NOT NULL,
  `timestamp` int(10) unsigned NOT NULL,
  `data` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Configuration

You can change session table name in config/sql-session-handler.yaml placed in the root of your application.

Default value is:

session-table-name: session