php-pdoGet last query error with PHP PDO
$error = $pdo->errorInfo();ctrl + c$errorwill contain error details | $pdoPDO connection object |
errorInforeturns details of last error happened | |
Usage example
<?php
$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');
$pdo->query('WRONG');
$error = $pdo->errorInfo();
print_r($error);output
Array
(
[0] => 42000
[1] => 1064
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WRONG' at line 1
)
More of Php Pdo
- How to install PHP PDO for Mysql in Ubuntu 22.04
- Bind current datetime with PHP PDO
- Set execution timeout with PHP PDO
- Get current database name with PHP PDO
- Fetch single column value with PHP PDO
- Connect to MariaDB using PHP PDO
- How to get results after PHP PDO statement execute()
- How to bind table name in PHP PDO
- Escape string with PHP PDO
- Insert JSON into table with PHP PDO
See more codes...