RE: [PHP-DB] php sessions using mysql (or any db)

2002-11-18 Thread Peter Beckman
r Beckman [mailto:[EMAIL PROTECTED]] > > Sent: Monday, November 18, 2002 12:01 PM > > To: Adam Nelson > > Cc: [EMAIL PROTECTED]; 'Rasmus Lerdorf' > > Subject: RE: [PHP-DB] php sessions using mysql (or any db) > > > > > > >//

RE: [PHP-DB] php sessions using mysql (or any db)

2002-11-18 Thread Adam Nelson
ECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] php sessions using mysql (or any db) Hi, Just wondering, which is the better method: 1. Using PHP sessions ($_SESSION['var'] = "val";) 2. Using mySQL-based sessions (as described in this thread) I know if you're usin

RE: [PHP-DB] php sessions using mysql (or any db)

2002-11-18 Thread Adam Royle
Hi, Just wondering, which is the better method: 1. Using PHP sessions ($_SESSION['var'] = "val";) 2. Using mySQL-based sessions (as described in this thread) I know if you're using multiple servers, a DB-based session would be handy. Any comments, anyone? Adam

RE: [PHP-DB] php sessions using mysql (or any db)

2002-11-18 Thread Adam Nelson
it out. > -Original Message- > From: Peter Beckman [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 18, 2002 12:01 PM > To: Adam Nelson > Cc: [EMAIL PROTECTED]; 'Rasmus Lerdorf' > Subject: RE: [PHP-DB] php sessions using mysql (or any db) > > >

RE: [PHP-DB] php sessions using mysql (or any db)

2002-11-18 Thread Peter Beckman
ill doesn't work. In perl, this would have > been done already. I can't be the first person to try running sessions > on a database. Does anyone have a session.inc file that would be > appropriate for me. I feel like it should just be in the php base > files. > > > > -Original M

RE: [PHP-DB] php sessions using mysql (or any db)

2002-11-18 Thread Adam Nelson
--- > From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 15, 2002 4:59 PM > To: Adam Nelson > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] php sessions using mysql (or any db) > > > > CREATE TABLE `SessionsTable` ( > > `SID` varchar(32)

Re: [PHP-DB] php sessions using mysql (or any db)

2002-11-15 Thread Rasmus Lerdorf
> CREATE TABLE `SessionsTable` ( > `SID` varchar(32) NOT NULL default '', This doesn't need to be a varchar. The sid will always be 32 chars, so make it a char(32) > `expiration` int(11) NOT NULL default '0', I would suggest using a "timestamp" type here so MySQL will handle updating it for

[PHP-DB] php sessions using mysql (or any db)

2002-11-15 Thread Adam Nelson
Cannot get code to work for session management on a database. Does anyone have tips. It appears that the data goes into the table, but I can't get it out. session_start just initializes the data in the value column.: SessionsTable definition --- CRE