Re: [PHP] green bean question on singleton php5

[Jochem Maas]

julian schreef:

Hi,

I am implementing this

try comparing this rewrite with your version:


abstract class dbaccess {
  static $db = null;

  private static function init() {
    if (dbaccess::$db))
        return;

    dbaccess::$db = new mysqli("localhost",USER,PASSWD,DB);
    if(mysqli_connect_errno())  
        throw new Exception('cannot connect to DB');
  }

  public static function getDB() {
        self::init();
        return dbaccess::$db;
  }
}

try {
        $db = dbaccess::getDB();
        $db->query("SELECT `foo` FROM `bar` WHERE `qux`=1");
} catch (Exception) {
        die($e->getMessage());
}

class dbaccess{
  static $db=null;
  static $othervar=33;

private function dbaccess(){

    dbaccess::$db= new mysqli("localhost",USER,PASSWD,DB);
    if(mysqli_connect_errno()){
      echo "no way";
    }
  }

public static function GetDb(){

  if(dbaccess::$db==null){

dbaccess is a static class, you should not be constructing it here it!

  dbaccess::$db= new dbaccess();
  }
  return  dbaccess::$db;

}

}


$db=dbaccess::GetDE();

$db->query(..................);

will fail...with Call to undefined method dbaccess::query()

apparently $db is of type dbaccess... and thus has not does not have query implemented....

any hhelp appreciated.....

JCG

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php