PHP / PDO: how to get the current connection status

Question

What is the equivalent of PDO:

mysqli_stat($dbConn); 

PS I use it (to get a message), make sure I'm connected

Answer 1

I can not get a loan for this answer. Someone sent a response, but he / she deleted the entry.

Here (saved archived) answer your question:

 $status = $conn->getAttribute(PDO::ATTR_CONNECTION_STATUS); 

Answer 2

you can use

 $name = $conn->getAttribute(PDO::ATTR_DRIVER_NAME); 

Connections and Connection Management
PDO :: getAttribute

Answer 3

PDO::getAttribute - Get the database connection attribute

http://www.php.net/manual/en/pdo.getattribute.php

Answer 4

$ pdo-> getAttribute (PDO :: ATTR_CONNECTION_STATUS) always returns "127.0.0.1 over 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)); } 

Answer 5

This code can be used to test your PDO connection.

  /* PDO connection start */ try { $conn = new PDO("mysql:host=$server; dbname=$sdosmsDB", $username, $password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); /* PDO::ERRMODE_EXCEPTION, PDO::ERRMODE_SILENT, and PDO::ERRMODE_WARNING */ $conn->exec("SET CHARACTER SET utf8"); } catch(PDOException $e) { die( 'Database Connection failed: ' . $e->getMessage()); } /* PDO connection end */