Gurzi Posted April 28, 2008 Share Posted April 28, 2008 <?php include("class.factorydatabase.php"); Class ligadb{ private static $lconnection = false; private static $type = "MYSQLPROD"; private function __construct(){} public static function getInstance(){ if( self::$connection === false){ self::$connection = FactoryDatabase::getDatabaseConnection(self::$type); } return self::$connection; } } ?> This is my Singleton class that works with Factory pattern ( FactoryDatabase file ) and now i'm developing one class for set/get categories(products) and i need to make some inserts/selects in the database. Wich is the most professional method to work with the database in the class ? Shall i include the ligadb.php in every file and create an instance of that class? Something like this <?php include_once("class.ligadb.php"); Class Category { private $connection; public function __construct(){ $connection = ligadb::getInstance(); } public function setCategory(){ $this->connection->execute(" INSERT BLABLABLABLA"); } }?> Is this the right way to accomplish the goal ? Help Link to comment https://forums.phpfreaks.com/topic/103340-database-interaction/ Share on other sites More sharing options...
koen Posted May 1, 2008 Share Posted May 1, 2008 This category class asks the connection upon construction. I would wait with this until necessary. A $this->getConnection() method could do this. Link to comment https://forums.phpfreaks.com/topic/103340-database-interaction/#findComment-530929 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.