The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
 / 
CGI-Session-3.94
River stage two • 43 direct dependents • 56 total dependents
7 ++
/ CGI::Session::MySQL

NAME

CGI::Session::MySQL - MySQL driver for CGI::Session

SYNOPSIS

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

For more examples, consult CGI::Session manual

DESCRIPTION

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});

COPYRIGHT

Copyright (C) 2001, 2002 Sherzod Ruzmetov. All rights reserved.

This library is free software and can be modified and distributed under the same terms as Perl itself.

AUTHOR

Sherzod Ruzmetov <sherzodr@cpan.org>. All the bug reports should be sent to the author to sherzodr@cpan.org>

SEE ALSO