How to view query error in PDO PHP?

Spread the love

Sometimes, we want to view query error in PDO PHP.

In this article, we’ll look at how to view query error in PDO PHP.

How to view query error in PDO PHP?

To view query error in PDO PHP, we can use the errorInfo method.

For instance, we write

if (!$st->execute()) {
    print_r($st->errorInfo());
}

to check if the $st statement failed to execute by checking if execute returns false.

If it does, then we call errorInfo to get the error and print it with print_r.

Conclusion

To view query error in PDO PHP, we can use the errorInfo method.

Leave a Reply

Your email address will not be published.