Jump to content

Database Interaction


Gurzi

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/103340-database-interaction/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.