Re: [PHP] Custom Session usind MySQL
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
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
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
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
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
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