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) NOT NULL default '',
This doesn't need to be a varchar
. I feel like it should just be in the php base
files.
-Original Message-
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
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)
?php // I got this somewhere. It works.
// This code is released
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
]]
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)
?php // I got this somewhere. It works.
// This code is released under the same license as
PHP. (http://www.php.net
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 you