CODEWITHSUNDEEP
phpdatabaseclass-design
aaronfarr
aaronfarr

Reputation: 676

The best way to share database connection between classes

I would like to be able to hide my database connection from print_r so I am using a static variable. I have a base class and a few object classes. Ideally they would all share the same database connection. What is the best way of sharing this? The way I have it set up now "works" but it just doesnt feel right. Must be a better way of doing this. (logically the classes shouldnt inherit one another)

class base {

  private static $db;

  function __construct() {

    self::$db = new DB(); // our database class
    $foo = new Foo( self::$db ); // some other class that needs the same connection

  }

}

class Foo {

  private static $db;

  function __construct( $db ) {
    self::$db = $db;
  }

}

Upvotes: 4

Views: 2377

Answers (1)

Headshota
Headshota

Reputation: 21449

you can have a static method in your database class wich will return an instance of itself.

$db = DB::getInstance();

moreover you can implement a singleton pattern. you can read about it here.

PHP Patterns

The main idea is that you save your DB object in static property and then in getInstance check if it's set you return it or create new one, constructor should be made private so that the Object can't be created anywhere else but in getInstance.. this ensures that there is always one Instance of DB object.

Upvotes: 7

Related Questions