NAME

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

SYNOPSIS

use CGI::Session qw/-api3/;
$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,
    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", you will also need to specify TableName attribute as the first argument to new():

    use CGI::Session qw/-api3/;
    
    $session = new CGI::Session("driver:MySQL", undef, 
						{Handle=>$dbh, TableName=>'my_sessions'});

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