Try/Catch Pdoexception does not work when error occurs

Question

I created the following method to execute my querys:

public function setQuery($query) {
    try {
        $stmt = self::$conn->prepare($this->limpaQuery($query));
        return $stmt->execute();
    } catch (PDOException $Exception) {
        var_export($query);
        die();
    }
}

It works perfectly, but when I run a wrong query it shows the following error:

Fatal error: Uncaught Exception 'Pdoexception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column...

What I don’t understand is why it doesn’t take Pdoexception, I wanted every query that doesn’t run to be displayed.

Height

/**
 * Conexao
 */
public function openConection() {
    try {

        //Verifica se uma instancia já existe
        if (!isset(self::$conn)) {
            //String de conexão
            self::$conn = new PDO("mysql:host=$this->servername;dbname=$this->banco", $this->username, $this->password);

            // set the PDO error mode to exception
            self::$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        }

        //Mensagem de status
        $this->status = "Conectado no host $this->servername, no banco dbname=$this->banco com o usuário $this->username";
    } catch (PDOException $e) {
        //Mensagem de status
        $this->status = "Falha ao tentar conectar: \n" . $e->getMessage();
    }
}

Answer 1

You need to set the setting PDO::ATTR_ERRMODE for PDO::ERRMODE_EXCEPTION.

$conn = new PDO($host, $usuario, $senha);
$conn->setAttribute(PDO::ATTR_ERRMODE, $conn::ERRMODE_EXCEPTION);

Answer 2

I found the problem, he was interpreting the Pdoexception as connected Pdoexception because of the namespace.

namespace conexao;

So I imported the Pdoexception.

use PDOException;

Source: https://stackoverflow.com/questions/39826052/pdo-catch-pdoexception-error