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

2002-11-18 Thread Adam Nelson
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

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

2002-11-18 Thread Peter Beckman
. 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

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

2002-11-18 Thread Adam Nelson
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

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
]; [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 using multiple servers, a DB-based

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

2002-11-18 Thread Peter Beckman
]] 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

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 you