CGI::Session::MySQL3pm

Usage

    use CGI::Session;
    $session = new CGI::Session("driver:MySQL", undef, {Handle=>$dbh});

Overview

CGI::Session::MySQL is a CGI::Session driver to store session data in MySQL table. To write your own drivers for CGI::Session refere CGI::Session manual.

Storage

To store session data in MySQL database, you first need to create a suitable table for it with the following command:

    CREATE TABLE sessions (
        id CHAR(32) NOT NULL UNIQUE,
        a_session TEXT NOT NULL
    );

You can also add any number of additional columns to the table, but the above "id" and "a_session" are required.

If you want to store the session data in other table than "sessions", before creating the session object you need to set the special variable $CGI::Session::MySQL::TABLE_NAME to the name of the table:

    use CGI::Session;

    $CGI::Session::MySQL::TABLE_NAME = 'my_sessions';
    $session = new CGI::Session("driver:MySQL", undef, {Handle=>$dbh});