Checking a query executed succesfully

[jjokham]

Checking a query executed succesfully

[colshrapnel]

You don't need that. This is not how the code is written in 2019.
You don't check for the query result but instead just assume it was a success.
That's all.

There are many outdated tutorials that tell you to check the query results but they are plain wrong, just ditch them away.

In a rare case when you need to handle an error, you can catch the exception, but most of time you shouldn't do it.
So in a nutshell just run your query and tell a user it was a success. that's all.

[paragonie-scott]

@colshrapnel is correct here.

The alternative answer is to do this:

class Foo
{
    /** @var EasyDB $db */
    private $db;

    /**
     * @return bool
     * @throws PDOException
     */
    function bar(): bool
    {
        $this->db->beginTransaction();
        
        // Do your queries here...
        $this->db->query(/* bar */);
        
        return $this->db->commit();
    }
}

[jjokham]

Thank you @colshrapnel and @paragonie-scott