-------- Original Message --------
Subject: RE: Custom PHP session handler (MS SQL) and register_shutdown_function()?
Date: Thu, 14 Aug 2003 17:12:41 +0100
From: James Cox
To: 'Tony Bibbs'
The list is now [EMAIL PROTECTED] ...
-----Original Message-----
From: Tony Bibbs [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 3:32 PM
To: [EMAIL PROTECTED]
Subject: Custom PHP session handler (MS SQL) and register_shutdown_function()?
I just spend quite a few hours tracking down an issue that I thought was with my custom session handler (uses MS SQL Server 2000 via PEAR::DB) but it turns out it was related to register_shutdown_function.
We have a simple script called db_init.php that has two functions, doConnect() and doDisconnect(). We called register_shutdown_function('doDisconnect') but apparrently this is called before ending the user session which, as you might guess, kills my database connection and prevents my session write function from working. My hunch is that this is working as designed but I wanted to make sure. If so, my next guess is you all will probably recommend that I call doDisconnect() from my session close method instead of using register_shutdown_function, right?
Finally, in troubleshooting this, I learned that if your connection dies before you do the session write using MS SQL Server 2000, it kills an apache child process and you get no response back. Using the same scenario with *MySQL* at least the mysql driver returns gracefully. I know this is a bit obscure but, in my opinion the mssql driver should work the same way (if possible) otherwise debugging is a real PITA.
I'm willing to provide sample code if needed.
--Tony
-- PHP Internals - PHP Runtime Development Mailing List To unsubscribe, visit: http://www.php.net/unsub.php
