Re: [PHP] Custom Session usind MySQL

2003-11-18 Thread Greg Donald
On Wed, 19 Nov 2003, Manisha Sathe wrote:

>I want the session to be accessed from different websites, so i got the
>answer in this forum only to make use of customised session with mysql.
>
>I searched the web and came to know that 'session.save_handler' of php.ini
>needs to be as 'user' but instead, on my server it is 'files'. As server is
>a shared server so i may not be able to change it, what can i do to resolve
>this ?
>

Basically you just need to override the default session handler and 
provide your own session functions that will use a MySQL table instead of 
/tmp.  Try this:

http://destiney.com/pub/php_db_sessions.tar.gz


-- 
Greg Donald
http://destiney.com

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Custom Session usind MySQL

2003-11-18 Thread John W. Holmes
Manisha Sathe wrote:

yes, website is on same machine, but if there is to and fro from 2 websites,
then for both ways i need to pass it ? what will happen to session time
limit ? if i go website1 then go to another website2 then after 30 mins i
come back to website1 (session timeout 30mins) then what will happen ? Any
sample code would be appreciated.
Nothing will happen as you'll be using the same session file so it will 
not be cleaned up. What don't you try reading the page for 
session_set_save_handler() and start from there...

--
---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals – www.phparch.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] Custom Session usind MySQL

2003-11-18 Thread Manisha Sathe
yes, website is on same machine, but if there is to and fro from 2 websites,
then for both ways i need to pass it ? what will happen to session time
limit ? if i go website1 then go to another website2 then after 30 mins i
come back to website1 (session timeout 30mins) then what will happen ? Any
sample code would be appreciated.

if at all i decide to go for database then do i need  'session.save_handler'
as 'user' ?

manisha


> Manisha Sathe wrote:
>
> > I want the session to be accessed from different websites, so i got the
> > answer in this forum only to make use of customised session with mysql.
> >
> > I searched the web and came to know that 'session.save_handler' of
php.ini
> > needs to be as 'user' but instead, on my server it is 'files'. As server
is
> > a shared server so i may not be able to change it, what can i do to
resolve
> > this ?
>
> Are both websites on the same machine? If so, you can just use a common
> session.save_path and pass the session_id when changing servers.
>
> If the websites are on different machines, then you'll need to use a
> database for sessions and ensure the database is accessible by each site.
>
> --
> ---John Holmes...
>
> Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
>
> php|architect: The Magazine for PHP Professionals – www.phparch.com

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Custom Session usind MySQL

2003-11-18 Thread Marek Kilimajer
Manisha Sathe wrote:
I want the session to be accessed from different websites, so i got the
answer in this forum only to make use of customised session with mysql.
I searched the web and came to know that 'session.save_handler' of php.ini
needs to be as 'user' but instead, on my server it is 'files'. As server is
a shared server so i may not be able to change it, what can i do to resolve
this ?
Thanks in advance
Manisha
You have to use session_set_save_handler() to register your session 
handling functions. One thing I would point out is that you need to lock 
the session storage, in this case one row in a table. As mysql cannot 
lock a row, only whole table, I would sugest you use GET_LOCK and 
RELEASE_LOCK mysql functions (with session id as the lock name) to 
implement session locking.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] Custom Session usind MySQL

2003-11-18 Thread John W. Holmes
Manisha Sathe wrote:

I want the session to be accessed from different websites, so i got the
answer in this forum only to make use of customised session with mysql.
I searched the web and came to know that 'session.save_handler' of php.ini
needs to be as 'user' but instead, on my server it is 'files'. As server is
a shared server so i may not be able to change it, what can i do to resolve
this ?
Are both websites on the same machine? If so, you can just use a common 
session.save_path and pass the session_id when changing servers.

If the websites are on different machines, then you'll need to use a 
database for sessions and ensure the database is accessible by each site.

--
---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals – www.phparch.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[PHP] Custom Session usind MySQL

2003-11-18 Thread Manisha Sathe
I want the session to be accessed from different websites, so i got the
answer in this forum only to make use of customised session with mysql.

I searched the web and came to know that 'session.save_handler' of php.ini
needs to be as 'user' but instead, on my server it is 'files'. As server is
a shared server so i may not be able to change it, what can i do to resolve
this ?

Thanks in advance
Manisha

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php