Call to member function, in a class. PHP

Asked May 16 '19 at 20:19

Active May 17 '19 at 00:08

Viewed 44 times

I'm receiving this error, I know there are multiple topics about this already but I couldn't find a proper solution for mine.

Uncaught Error: Call to a member function prepare() on null in C:\xampp\htdocs\ELO-Alfa\dev\app\helpers\db.inc.php:28

line 28:

    public function query($sql, $array = []){

        $this->dbQuery = $this->dbConnect->prepare($sql);
        $this->dbQuery->execute($array);

    }

This is the function that calls the query

    public function getDay(){

        global $db;

        $db->query('SELECT * FROM day');

        $day = $db->getAll();

        foreach($day as $days):?>

            <th><?= $days['day_name'] ?></th>

        <?php endforeach;

    }

And this the echo


<?= $agenda->getDay();?>

connection

    public function connection(){

        try{
            $this->dbConnect = new PDO('mysql:host:' . $this->dbHost . ';dbname:' . $this->dbName,
                $this->dbUser,
                $this->dbPass);
        }catch(PDOException $e){
            echo 'Connection error: ' . $e->getMessage();
            return false;
        }
        return true;
    }
    ```

edited May 17 '19 at 00:08

nathancy

42,661
14
115
137

asked May 16 '19 at 20:19

Jeroen Hoekstra

Maybe `$this->dbConnect()->prepare($sql);` ? Not sure without seeing it. – AbraCadaver May 16 '19 at 20:25
@AbraCadaver dbQuery is NULL, yea I have changed it to that, but still the same – Jeroen Hoekstra May 16 '19 at 20:28
Then `$this->dbConnect()` is not returning an object. – AbraCadaver May 16 '19 at 20:30
I have updated my code, I included the connection function. – Jeroen Hoekstra May 16 '19 at 20:32
5

I don't see the `connection()` function called anywhere in your code. It needs to be called before any `query()` else `dbConnect` will be `null`. – Jiri Tousek May 16 '19 at 20:34
1

Possible duplicate of [Reference - What does this error mean in PHP?](https://stackoverflow.com/questions/12769982/reference-what-does-this-error-mean-in-php) – miken32 May 16 '19 at 20:37
@JiriTousek Nevermind got it, thanks – Jeroen Hoekstra May 16 '19 at 20:39

Call to member function, in a class. PHP

0 Answers0