MySQL database connection in the constructor I'm an absolute beginner in PHP OOP in search of the "Holy Grail" of connecting to MySQL database once and reusing this connection for the whole site.

classes/db.php

&lt;?php
define('SERVER', 'localhost');
define('USERNAME', 'root');
define('PASSWORD', 'password');
define('DATABASE', 'cms');

class DB {
    function __construct(){
        $connection = @mysql_connect(SERVER, USERNAME, PASSWORD) or die('Connection error -&gt; ' . mysql_error());
        mysql_select_db(DATABASE, $connection) or die('Database error -&gt; ' . mysql_error());
    }
}
?&gt;


classes/users.php

&lt;?php
class Users {
    function __construct(){
        $db = new DB();
    }

    public function read(){
        $query = mysql_query("select use_id, use_name, use_email FROM users");
        while ($row = mysql_fetch_array($query)){
            $data[] = $row;
        }
        return $data;
    }
}
?&gt;


users.php

&lt;?php require_once('classes/db.php'); ?&gt;
&lt;?php require_once('classes/users.php'); ?&gt;
&lt;?php
$Users = new Users();
$users = $Users-&gt;read();
?&gt;
&lt;?php
if ($users) {
    echo '&lt;ul&gt;';
    foreach($users as $user){
        echo '&lt;li&gt;&lt;a href="mailto:' . $user['use_email'] . '"&gt;' . $user['use_name'] . '&lt;/a&gt;&lt;/li&gt;';
    }
    echo '&lt;/ul&gt;';   
}
?&gt;


My doubts are mostly on the Users class part:

function __construct(){
    $db = new DB();
}


It seems to be an easy way to have the connection available, but I read somewhere that instantiate the db connection in the constructor is a bad idea.  Can you explain why, and if there's a better way to have the db connection easily available in every class that needs it?

I read a similar question here, but I can't understand the abstraction/holding reference/singleton suggestion from the accepted answer, and the lack of a full practical example doesn't help me.
A better practice is passing a created DB instance to the Users class. Imagine that you have a Products class, an Orders class etc. Will all of their constructors create a separate MySQL connection? It doesn't look a good idea since all of them could use the same database connection. 

class Users {
    private $db;

    public function __construct($db) {
        $this-&gt;db = $db;
    }

    ....
}

class Products {
    private $db;

    public function __construct($db) {
        $this-&gt;db = $db;
    }

    ....
}

$db = new DB();
$users = new Users($db);
$products = new Products($db);