Undefined Variable in PHP?

Question

This is my function:

public function showDataall($result) 
    {
        $q = $this->conn->prepare($result) or die("failed!");
        $q->execute();
        while ($r = $q->fetch(PDO::FETCH_ASSOC)) 
        {
            $data[] = $r;
        }
        return $data;
    }

This function perfectly work in old xampp but new xampp return a Notice:

Undefined variable: data in /opt/lampp/htdocs/live/demo/model/config.php on line 152

The code you show does not look like it is from `config.php` — RiggsFolly, May 12 '16 at 10:35

score 3 · Answer 1 · edited May 12 '16 at 10:43

Declare variable before using it :

If your query returns no data, your current code will never actually create the $data array, and therefore when you try and return it, this error will happen.

public function showDataall($result) 
    {
        $q = $this->conn->prepare($result) or die("failed!");
        $q->execute();
        $data = array();
        while ($r = $q->fetch(PDO::FETCH_ASSOC)) 
        {
            $data[] = $r;
        }
        return $data;
    }

Undefined Variable in PHP?

1 Answers1