PHP class, getting outside db connection

Asked Oct 12 '15 at 13:44

Active Oct 12 '15 at 14:00

Viewed 21 times

I have never looked into classes at all so I'm just learning right now.

But like always I got troubles before I've even started -.-

class news { 
    public $countNews; 
    public $db;

    public function __construct() { 
        global $_database;
        $this->$db = $_database; 
    }
    public function countNews() { 
        return $this->$db->query("SELECT * FROM ".PREFIX."news ORDER BY date DESC")->num_rows; 
    }
}

This is my code right now, on this example im trying to count news. but it doesn't go to well if i say it like that.

My error right now is:

Notice: Undefined variable: db in news.class.php on line 11

Anyone that knows what I'm doing wrong and maybe can point me in the right direction?

edited Oct 12 '15 at 13:50

Machavity

30,841
27
92
100

asked Oct 12 '15 at 13:44

Tommy

1

remove the `$`-sign - it is just `$this->db...` – Philipp Oct 12 '15 at 13:46
2

have a look at: http://stackoverflow.com/questions/14920216/php-fatal-error-cannot-access-empty-property/14920231 – Philipp Oct 12 '15 at 13:47
Thanks so much @Philipp you really saved me there :D – Tommy Oct 12 '15 at 13:48

PHP class, getting outside db connection

0 Answers0