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 have

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

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 point

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 Book. Among other

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 about this

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

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

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 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