The PHP normally stores the session in archives on the webserver. Marking this option, you’ll modify the way how PHP manipulates these files, storing them in databases.
To keep the information from the development sessions on Scriptcase, Access the menu (Config ->Admin). On the System Configuration mark the option where you utilize the database session as (SIM), right after, clique on the button “Actualize”.
When you finish this stage, the Scriptcase will create a form on the database where the Scriptcase itself was installed. It’s called ‘sc_tbses’ where the Scriptcase will, from now on, store that information on that form.
Utilizing database session ( production:
Utilizing the Scriptcase on production, it is necessary to have in your database a form to keep all sessions of the published application.
Bellow a script of a Create on MySQL:
CREATE TABLE `sc_tbsess` (
`sess_id` varchar(32) NOT NULL default ”,
`sess_last_access` varchar(32) default NULL,
PRIMARY KEY (`sess_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Connection(PROD): Accomplished connection on production name
Form Name: Inform the name of the form where you will keep all the session information
Scheme Name: Inform the name of the Schema from the database ( Postgres, SQLServer etc)
* Indicates the session utilized on the Application.
Session Register on DataBase.