Hello,
what I would do is build the instance of your mysql class in the constructor
of the user class
class User{
var $db;
// constructor
function User(){
$this->db = new Mysql(True);
}
// function that show how to use the Mysql class in the User class
function foo(){
$this->db->sql_query("SELECT user FROM banned_users");
}
} // end class
hope it help,
py
----- Original Message -----
From: "Paul - Zenith Tech Inc" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 09, 2001 11:26 AM
Subject: [PHP] Classes Question
> I'm hoping somebody has the answer to this!
>
> I have 3 pages, one a normal PHP page, and 2 which are classes.
>
> One class, is a MySQL class I have written to connect/update users, etc
> And the other is the manage users on the system.
>
> Is there a way I can get the "users" class to talk to the "mysql" class?
>
> I have this code to make a new instance of the MySQL class (the True means
> use persistent connections) and a new instance of the users class
>
> $db = new MySQL(True);
> $users = new Users();
>
> I am then using this code to check the list of banned users
>
> $users->CheckBannedUser("spacetowns",$db);
>
> In the CheckBannedUser function, I have this
>
> $db->sql_query("SELECT user FROM banned_users");
>
> But that does not work, (it works fine when used from the standard PHP
page)
>
> Is it not possible to do what I am trying to do?
> Or am I doing it all wrong?
>
> Many thanks,
> Paul
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
