[SOLVED] Class within a class

[SetToLoki]

hi I am creating a new class and I want to use my previously connected mysql class inside of it, being able to reference the mysql inside the new class I am creating.

 

example of what I tried to do

 

<?php
class user {
 private $user = "";
 private $userlevel = "";

 private $db;
 public function _construct()
 {
 	global $db_host, $db_user, $db_pass, $db_name;
 	$this->db = new MySQL($db_host, $db_user, $db_pass, $db_name);
 }

        function test()
        {
                $sql = "SOME SQL CODE";
                $results = $this->db->query($sql);
 	$rows = $this->db->fetch_assoc($results);	
        } 
}
?>

[gevans]

Hey,

 

global $db_host, $db_user, $db_pass, $db_name;

 

Instead of setting the variables as global, you should pass them, in this case, via the constructor for use with the MySQL class.

 

You didn't state if there was a problem.

[SetToLoki]

sorry my error was

Fatal error: Call to a member function query() on a non-object

 

when I tried to do it my way, yeah I probably shouldn't do it as globals is an old habit I need to break

[gevans]

Does your MySQL have any error checking? What if it fails? Perhaps it's not instantiating.

[gevans]

Actually, just saw it,

 

_construct()

 

For the constructor to run automatically on instantiation you require two underscores;

 

__construct()

[SetToLoki]

Actually, just saw it,

 

_construct()

 

For the constructor to run automatically on instantiation you require two underscores;

 

__construct()

 

how embarrassing for me , sometimes I guess just look to hard and make it all complex when the answer is obvious, thanks my good man/lady!

[gevans]

Man