What is the PDO equivalent of:
mysqli_stat($dbConn); P.S. I use it to (get a message to) make sure I am connected
- @witherwind it is not a duplicate. I am looking for a connection status method. The other question is looking to TEST a connection.Omar Juvera– Omar Juvera2014-02-06 06:40:58 +00:00Commented Feb 6, 2014 at 6:40
Add a comment |
4 Answers
I cannot get credit for this answer. Someone posted the answer, but he/she latter deleted the entry.
Here's the (saved archived) answer to your question:
$status = $conn->getAttribute(PDO::ATTR_CONNECTION_STATUS); 1 Comment
Russ
Then you get credit for saving it from oblivion (and helping me out). :)
$pdo->getAttribute(PDO::ATTR_CONNECTION_STATUS) always return "127.0.0.1 via TCP/IP" even if i stop mysqld, to use:
if ($pdo->getAttribute(PDO::ATTR_SERVER_INFO)=='MySQL server has gone away') { $pdo=new PDO('mysql:host=127.0.0.1;port=3306;dbname=mydb;charset=UTF8', 'root', '', array(PDO::ATTR_PERSISTENT=>true)); } 
1 Comment
kevinc
In my environment (PHP 8.1) the call to getAttribute on a "gone away" connection throws an exception. So something like this: try{ $x = $db->getAttribute(PDO::ATTR_SERVER_INFO); echo "OK"; } catch(Exception $e) { echo "need new connection"; }
you can use
$name = $conn->getAttribute(PDO::ATTR_DRIVER_NAME); 
1 Comment
Omar Juvera
$status = $conn->getAttribute(PDO::ATTR_CONNECTION_STATUS);PDO::getAttribute - Retrieve a database connection attribute
