Re: [PHP-DB] PHP Sessions

2005-04-14 Thread Mignon Hunter
>>> "Ian McGhee" <[EMAIL PROTECTED]> 04/14/05 04:23AM >>> Hi All, I have been looking into PHP sessions and I have noticed you can actually use a database for storing the sessions instead of flat files I will be using MS SQL for the database can any one give be a clue as to how I would go ab

Re: [PHP-DB] PHP Sessions

2005-04-14 Thread Bastien Koert
article on phpbuilder.com http://www.phpbuilder.com/columns/ying2602.php3?aid=19 bastien From: Maerlyn <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: Re: [PHP-DB] PHP Sessions Date: Thu, 14 Apr 2005 11:40:01 +0200 Hi, you might consider buying Peter Moulding's PHP Black

Re: [PHP-DB] PHP Sessions

2005-04-14 Thread Simon Rees
On Thursday 14 April 2005 10:23, Ian McGhee wrote: > I have been looking into PHP sessions and I have noticed you can > actually use a database for storing the sessions instead of flat files I > will be using MS SQL for the database can any one give be a clue as to > how I would go about this or po

Re: [PHP-DB] PHP Sessions

2005-04-14 Thread Balwant Singh
i also want to buy this book. but could not find it in India. If anybody help me out. with best wishes balwant On Thu, 2005-04-14 at 15:10, Maerlyn wrote: > Hi, > > you might consider buying Peter Moulding's PHP Black Book. Among other > things it tells much about DBs, sessions and storing ses

Re: [PHP-DB] PHP Sessions

2005-04-14 Thread Maerlyn
Hi, you might consider buying Peter Moulding's PHP Black Book. Among other things it tells much about DBs, sessions and storing sessions in databases. I already used it's codes, and I found it very useful. Maerlyn Ian McGhee wrote: > Hi All, > > > > I have been looking into PHP sessions and I h

Re: [PHP-DB] php sessions

2005-02-15 Thread The Disguised Jedi
you could put in a database an action field, and have a function check the action on every page. If the action says certain things, like KILL or REVALIDATE, then have it perform certain actions. For the first, I'd output an error page that says something like "Your session was killed by administr

RE: [PHP-DB] php sessions

2005-02-15 Thread Bastien Koert
The only way to be able to track user sessions would be to use a db, for the functionality that you want. Move your entire sessoion handling to the db (see here for an article on this:http://www.phpbuilder.com/columns/ying2602.php3?aid=19 ) You can track user ids, session ids, ip addresses

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