Where to Generate Database Connection within Classes

[zeodragonzord]

I'm writing an application with many classes.  Some of these classes interact with MySQL with methods doing specific things like inserting, updating, etc.  I use Pear MDB2.  Where is the best place to generate a MDB2 object?  Should I:

 

• create the MDB2 object in the constructor and assign it into the object variable to be used in each of its methods
  
• create the MDB2 object inside each method
  
• create the MDB2 object and pass it into the object in its constructor
  
• create the MDB2 object in a config file and use the global keyword to access it in each object
  

 

I originally had a singleton used inside each method but I don't like the idea that the singleton database connector is global.  Thanks.

[ignace]

create the MDB2 object and pass it into the object in its constructor