db transactions across multiple pages...

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 -----Original Message----- From: bruce [mailto:bedouglas@earthlink.net] Sent: Friday, July 30, 2004 11:33 AM To: holmes072000@charter.net; php-general@lists.php.net Subject: RE: RE: [PHP] php mysql--mysqli persistent connections... never worked with them.... but i'm getting close in an app that i believes requires them... i'm going to need to do transactional processing across multiple pages for a test app. i was looking at the mysqli functions which work for the rollback/commit which is ok. but it's my understanding that once the page closes, the db connection is lost, which would trigger a rollback of any db queries/processing currently in process. however, if i had a persistent connection, then the connection should be open, and the rollback shouldn't be triggered, and the app could proceed with the db processing, followed by a commit! at least this was the plan, until i couldn't find the persistent hook within mysqli... what am i missing..?? -bruce -----Original Message----- From: John Holmes [mailto:holmes072000@charter.net] Sent: Friday, July 30, 2004 11:09 AM To: bedouglas@earthlink.net; php-general@lists.php.net Subject: Re: RE: [PHP] php mysql--mysqli persistent connections... > php/mysql supported persistent connections.. Have you ever used persistant connections. I don't think they work the way you are thinking. Persistant connections rarely had any benifit except in certain server configurations. ---John Holmes... UCCASS - PHP Survey System http://www.bigredspark.com/survey.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php