PERMANENT db-connection

hoffi77

I've written my own class with a database abstraction layer. Everytime I need a database connection (in a new php file) I have to make an Instance of this class which means I have to reconnect to the database everytime, too.

Is it possible to instatiate this class once and pass it through several php objects (files) ? Or is there another way to get a permanent database connection ?

thx in advance

[deleted]

Use "pconnect" instead of "connect"
Check the manual for more info.

calevans

Yes, it's possible, if you design your classes correctly to have an object representing a database connection. This object could then be passed to each object on a page that needs a database connection and then destroyed when you are done. This means that for any given page, you will only use 1 database connection.

As Vincent stated, make sure you use pconnect instead of just connect so you will also get connection pooling benefits.

Cal

Cal
http://www.calevans.com

hoffi wrote:

Is it possible to instatiate this class once and pass it through several php objects (files) ? Or is there another way to get a permanent database connection ?

thx in advance

kparker

No, not at all. You guys are missing the point of pconnect. Of course you can't open a connection and keep it open between pages, because http itself doesn't create an ongoing tcp connection with the server. pconnect() simply allows the apache/php back end to keep and resuse connections as a performance enhancement, to avoid the overhead of opening the mysql connection each and every time. But you still have to call pconnect() every single time you load a new php page. That new page is going to be blissfully unaware of which particular back end had handled the previous page's dbms query, and for all you know it's already handling someone else's page...

[deleted]

I think we have a bit of a misunderstanding going on here.

I was under the impression that hoffi meant "can I get a link identifier in one PHP object or file and re-use it in another object or file"
Indeed that could mean using it in PHP objects and include files, but it could also mean using it across pages.

Pconnect creates a "permanent" or at least apperently permanent database connection between the PHPengine and the database.

This does mean that you have to call pconnect() to fetch the identifier for that connection, but there is no new connection made every time you call pconnect(). (unless there aren't enough connections available)

So yes, it's possible to create database connections that are "permanent" and yes, you can re-use that link-identifier in several files during the same request,
but no, it's not possible to use connect() in one page, fetch a link identifier, pass that on to the next page, and continue to work with that link-identifier.