FFS... Scope of my database object

[Foo]

I've created an object to represent my database connection. It has various function like HasError() and Query(), all the usual gubbins.

But I'm using other objects, and I can't access this object and its functions from within these object's functions.

Is there a way of making my database object global? It would be useful to be able to do it WITHOUT having to declare it as global again within each function/object.

Thanks In Advance.

[Shrike]

There are a couple of approaches. Firstly you could access the DB object statically (object::method() ) or instantiate the DB object from within each class. Perhaps a neater approach would be to use a 'base' class which each class can extend and so have access to the SQL object.

class db {
  function Query($query){
    ....
  }
}
class Base {
  var $sql;
  function base(){
    $this->sql = new db();
  }
}
class SomeOtherClass extends Base {
  function someOtherClass(){
    parent::base();
    $this->sql->Query("A query");
  }
}
class YetAnotherClass extends Base {
  function yetanotherClass(){
    parent::base();
    $this->sql->Query("A query");
  }
}

[sijis]

shrike, question.

would the db class file have to be included (include_once ='file.php'; type of thing) into the base class?

another question, would it even be a good idea to extend db onto base

class base extends db {
...
}

the reason i ask is because i've created a typical db class and i'm not exactly sure what's the best method of using it with other classes. is it best to extends the class with db or just include the class file and use $this-var = new db();
maybe there is another solution.

thanks.

[Shrike]

I would personally use it as a standalone class (whether instantiated or used statically) because extending classes tends to limit their usefullness.