Scriptcase Learning how to use Session on Database

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,
`sess_data` text,
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.

Visit our blog and check out more articles like this one! Discovery the Scriptcase.