ADOdb Lite Thumbnail Logo

ADOdb Lite Session Test Program
Select your Database Type
Select Encryption
Select Compression
Database Name
Database User Name
Database User Password
Database Host

This program will test the ADOdb Lite Session Handling Code. The program will attempt to create the database if it does not exist. If you see Could not connect to the database. then you will need to create a database or use an existing database to perform this test.

If you are testing a database other than MySql, MySqli or MySqlt then you will need to create a database table called 'sessions' with three fields.

Field 1 = id - int(11) auto_increment
Field 2 = SessionID - VARCHAR(64)
Field 3 = session_data - longtext or text
Field 4 = expiry - int(11)
Field 5 = expireref - VARCHAR(64)

Here is what the MySql create table query looks like.

CREATE TABLE IF NOT EXISTS `sessions` (
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
SessionID VARCHAR(64),
Data TEXT DEFAULT '',
expiry INT(11),
expireref VARCHAR(64) DEFAULT '',
INDEX (SessionID),
INDEX expiry (expiry)
)

If you are testing on MySql, MySqli or MySqlt the table will be created automatically.