[El Forum]

[eluser]jorx[LINUX][/eluser]
hi guyz!!! I'm saving session data to mysql db---- is it possible to add custom data to the session array?!!!!!

[El Forum]

[eluser]Thorpe Obazee[/eluser]
Did you try $this->session->set_userdata('key', 'value');?

[El Forum]

[eluser]jorx[LINUX][/eluser]
yes...


i had use this sample query from the user guide

Code:

CREATE TABLE IF NOT EXISTS  `ci_sessions` (
session_id varchar(40) DEFAULT '0' NOT NULL,
ip_address varchar(16) DEFAULT '0' NOT NULL,
user_agent varchar(50) NOT NULL,
last_activity int(10) unsigned DEFAULT 0 NOT NULL,
user_data text NOT NULL,
PRIMARY KEY (session_id)
);

do i have to add an additional table(s) for the custom data?

[El Forum]

[eluser]riko0na[/eluser]
bargainph

"Most programmers are lazy. If you're like me, you're lazy too." from pinoytech.org

hehe..lol

[El Forum]

[eluser]Thorpe Obazee[/eluser]
[quote author="jorx[LINUX]" date="1247493965"]yes...


i had use this sample query from the user guide

Code:

CREATE TABLE IF NOT EXISTS  `ci_sessions` (
session_id varchar(40) DEFAULT '0' NOT NULL,
ip_address varchar(16) DEFAULT '0' NOT NULL,
user_agent varchar(50) NOT NULL,
last_activity int(10) unsigned DEFAULT 0 NOT NULL,
user_data text NOT NULL,
PRIMARY KEY (session_id)
);

do i have to add an additional table(s) for the custom data?[/quote]

That table is mostly what you'll need. No additional tables.

[El Forum]

[eluser]bigtony[/eluser]
The custom sesssion variables are put into the 'user_data' text field of the ci_sessions table.

[El Forum]

[eluser]jorx[LINUX][/eluser]
thankz guyz!!!!!!