Need help in Database connection OOP way.

[raheelwp]

Hello users,

I just joined this forum and it seems i will get some help here

Problem is that i have a database class which holds a connect() method.
Following is the code:

[php]
public function connect($host, $user, $password, $database) {
$this->Host = $host;
$this->User = $user;
$this->Password = $password;
$this->Database = $database;

    $this->Connection = mysql_connect($this->Host,  $this->User,  $this->Password)
            or die('<h1>'.  mysql_error().'</h1>');
    
    if($this->Connection){
        //Selecting the database.
        $this->DbSelected = mysql_select_db($this->Database,  $this->Connection)
                or die('<h1>'.mysql_error().'</h1>');

// if($this->DbSelected){
// echo “connected”;
// }
}
[/php]

I made a config.php file …
[php]
require_once ‘inc.database.php’;
$Database = new Database();
$Database->connect(“localhost”, “aih786_raheel”, “raheel786”, “aih786_basicblog”);
[/php]

Now the problem is that i am including my config.php file on every page of my application and every time it will be creating Database object again and again which i think is not a good practice… I tried to make the connect methods static but its giving me errors which i don’t understand. I need help how to avoid making object again and again… any other approach which i can use to have my connect() method on every page without mulitple connections attempts and multiple object creation.

Thanks and Regards,

Raheel