Classes and database access

Anon

Howdy all,
Its been driving me crazy trying to figure this out. All i want to do is use a class function to access a database and do my query's often returning a boolean.
The problem is i cant get the function to work with mySql functions
ie:
$result = mysql_query($sql, $this->dbh);
this line will not work keeps giveing
Warning: 0 is not a MySQL link index in DBManager.inc on line 38

any ideas? Please
maybe a line of sample code :o)

thanks a mill

jim

Anon

How are you setting your class? I often do what you have described using a constructor function class variables like so:

class test {
var $db;

function test() {
$dbhost = "";
$dbuser = "";
$dbpass ="";
$this->db = mysql_connect($dbhost, $dbuser, $dbpass);
}

function some_query() {
mysql_query($query, $this->db);
}

}

Anon

Louie,
Hey, thanks i got the answer I was looking for from viewing your code!

Hope you dont mind but since I seems very few on this board use OOP, Im gonna pick Your brain :0) Hope you dont mind,
Ok im making a DBManager class to handle the DB connections and simply want to allow the using classes to inherit the methods (functions) from that class. they only way i can stop the parser from complaining is using the include("DBManager") at the top of the class page and then i still does not recognize the methods (functions) from the parent class?

any ideas?

thanks in advance

peter

Anon

Well if you take the phplib example for instance and you have

include("basesclasses.php");

class DB extends DB_Sql {
var $Host = "localhost";
var $Database = "test";
var $User = "user";
var $Password = "password";
}
In baseclasses.php you have a class
class DB_Sql {

/ public: connection parameters /
var $Host = "";
var $Database = "";
var $User = "";
var $Password = "";

function1() {
//Some code
}
function2() {
//Some code
}

}

you should be able to instantiate a new class of DB like $db = new DB;
And you should be able to call the methods of DB_SQL through $db->function1();

Hope that helps