Receive Firebird Exception message in PHP

Question

My script PHP is not receiving the message from exceptions which are generated by Firebird. I have a class that connects to BD, runs sql and disconnects.

Debugging the script, I saw that the exception is being generated as the script is interrupted, but the message is not being received by PHP. To receive the exception am using ibase_errmsg(). The function of the class responsible for the execution of the sql is this:

function sql($host, $user, $pass, $query, $charset){
$this->connect($host, $user, $pass, $charset);
if ($this->conectou) {
    try {
        if ($this->result=ibase_query($query)){
            $this->disconnect($type);               
            return $this->result;
        } else {
            $errmsg = ibase_errmsg();
            //Debug
            echo $errmsg; //Nada esta mostrando aqui!!!
            $this->disconnect($type);
            throw new Exception($errmsg);
        }
    }
    catch (Exception $e) {
        echo $e->getMessage();
    }
  }
}

At first I thought the problem might be in ibase_errmsg(), but, the most intriguing is that running the same script with Apache, Exception is shown normally.

• Server: Debian
• Firebird: 2.5 superclassic
• Web Server: Nginx
• PHP: 5.4.45
• PHP process: php-fpm

Answer 1

Starting from version 5.0 of PHP the function ibase_query returns the number of lines if it is INSERT, DELETE and UPDATE, as explained in https://secure.php.net/manual/en/function.ibase-query.php#refsect1-Function.Ibase-query-returnvalues

Then you’d better use an ID like === or !== and to debug better I always recommend to use var_dump instead of echo so for example:

$this->result = ibase_query($query);

if ($this->result !== false) {
    $this->disconnect($type);               
    return $this->result;
} else {
    $errmsg = ibase_errmsg();

    //Debug
    var_dump($errmsg); //Nada esta mostrando aqui!!!

    $this->disconnect($type);
    throw new Exception($errmsg);
}