Initialise the database connection and perform actions on the database using a seperate class. You can pass your functions (methods) values returned from your database calls to manipulate. This is commonly called a 'database abstaction layer' Theres a good database abstraction class in this magazine by a guy called marco talbini http://www.phparch.com/ Else lookup PEAR:MB or adodb library on teoma.com or similar. -----Original Message----- From: Philip Zee [mailto:pzee@creativecgi.com] Sent: Wednesday, 22 January 2003 4:27 PM To: Subject: Using Objects with Databases Hello all, I am trying to create a class, say User. Each user has an entry in the database table called user. Each function, including the constructor, will be calling the database to do something. Is it better to initialize the database connection inside each function or is it better to initialize the connection at the beginning of the class? What's the best practice on this? Any help or example is appreciated. Thanks, Philip -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
