Using classes with a database

[cydeways06]

I am going to be writing my first big application using classes instead of just functions. I understand OOP quite well but am confused when you through in databases. Are you supposed to connect to the database inside of each class or is there a way to share the database connection. I am also going to be learning to use PEAR during this process if that simplifies the process anyway. Any help or documents to read would be helpful. Thanks

Mike
[e-mail]

[tha_mink]

It depends where you make your connection. You can open and close the database connection within your classes or you can make a global connection on each page and pass that to your classes. I would go with the latter. Make a connection(using pear), set it to get results in object form and write a function in your class that sets the db connection. OR write your member functions to take the $db object as an arguement.