Database Interaction

[Gurzi]

<?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

[koen]

This category class asks the connection upon construction. I would wait with this until necessary. A $this->getConnection() method could do this.