Get error - Fatal Error: Call to a member function fetch_array() on boolean

Asked May 16 '16 at 15:39

Active May 16 '16 at 15:39

Viewed 29 times

When I am executing the following code I get the error code described in the header:

function getBrands($b_showAll) {
    global $mysql;

    if($b_showAll==true) {
        $query = $mysql->query("SELECT * FROM producer");
    }

    else {
        $query = $mysql->query("SELECT * FROM producer WHERE (active = 1)");
    }

    $result = array();
    while($row = $query->fetch_array()) {
        $brand = new brand();
        $brand->name = $row['name'];
        $brand->logo = $row['logo'];
        $brand->active = $row['active'];
        array_push($result, $brand);
    }   
    return $result;
}

How to solve this problem?

asked May 16 '16 at 15:39

Tobias Lukoschek

I guess your query is not returning any results – Pardeep Poria May 16 '16 at 15:43
`$query` is likely failing and returning FALSE. From the code posted, it is difficult to say why. – WillardSolutions May 16 '16 at 15:43
To solve this error you have to get the error from Mysql – Your Common Sense May 16 '16 at 15:43
By the way, you can create an object at once, like `while ($brand = $query->fetch_object('brand')) {$result[] = $brand;}` – Your Common Sense May 16 '16 at 15:45
And consider using PDO, as it will make your code just one line, `$result = $pdo->query($sql)->fetchAll(PDO::FETCH_CLASS,'brand');` – Your Common Sense May 16 '16 at 16:02

Get error - Fatal Error: Call to a member function fetch_array() on boolean

0 Answers0