we want to have the ability to perform db queries/actions with the db across multiple pages.
the pconnect supposedly allowed an app to use the same connection if one was available. so an app would establish the connection on page 1, and page 2 could use the same db connection... this is required as i understand it if you're going to do transactional processing, as once the connect dies, the actions being performed are rolled back if you haven't done a "commit"... -bruce -----Original Message----- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 1:45 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] db transactions across multiple pages... bruce wrote: > i can't be the only one to need to do this!!!! > > since it appears that php5/mysqli no longer supports pconnect, how does this > get done??? > > it almost seems that there needs to be a small intermediate server/app that > php would talk to, that would in turn talk with the mysql server. this app > would essentially make the connection, and maintain the connection with the > mysql db/server. the php app could then be free to make any required calls > with the mysql db, knowing that there's a persistent connection available > from the intermediate server. > > in essence, the intermediate server would basically be a container for db > connections... > > comments/criticisms/etc... > > -bruce I'm not sure I understand what it is exactly you want to do. Is it that you want to open a connection to the db on page one, and have that connection remain open on pages two, three, etc.? If that's the case, I don't think (I could be wrong, never used pconnect) pconnect ever did this. My understanding is that PHP will close _all_ db connections when the page is finished executing, no matter how that connection was opened. If this is what you want to do, why do you need the connection to remain open after a page executes? No queries are going to be run after execution stops. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
