try catch块中未捕获的错误[重复]

Question

This question already has an answer here:

• Fatal error: Call to a member function fetch_assoc() on a non-object [duplicate] 4 answers

I am trying to write "universal" function to execute SQL query and return JSON and handle error within. And during process there is something I don't understand - why try catch block doesn't handle error. (Later I will improve logic - question is NOT about that, but purely about error handling).

Here is my code:

public
function sqlToJSON($query, $type = array(), $params = array())
{
    try {
        $data = array();
        $stmt = $this->mysqli->prepare($query);
        if (count($type) > 0 && count($params) > 0) {
            call_user_func_array(array($stmt, "bind_param"), array_merge(array($type), $params));
        }
        $stmt->execute();
        $result = $stmt->get_result();
        while ($row = $result->fetch_assoc()) {
            $data[] = $row;
        }
        $stmt->free_result();
        $stmt->close();
        return array('result' => 'success', 'error' => null, 'data' => $data);
    } catch (Exception $e) {
        $this->sqlError = 'Caught exception: ' . $e->getMessage();
        return array('result' => 'failed', 'error' => $e->getMessage(), 'data' => null);
    }
}

How I call this function:

    $q = 'INSERT INTO receivers (receiver_name, owner) VALUES (UPPER(?), ?)';
    $params = array(&$receiverName, &$clientEmail);
    $this->sqlToJSON($q, 'ss', $params);

This gives following expected error:

Uncaught Error: Call to a member function fetch_assoc() on boolean in ...

What I don't understand why catch block is not executed in this case?

</div>

Answer 1

In php errors are not exceptions. If you want to catch them, write your own error_handler. http://php.net/manual/en/function.set-error-handler.php