PHP/PDO: How to get the current connection status

Question

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, Feb 06 '14 at 06:40

Omar · Accepted Answer · 2017-03-26T08:18:31.410

23

~~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);

edited Mar 26 '17 at 08:18

answered Feb 06 '14 at 06:47

Omar

11,783
21
84
114

4

Then you get credit for saving it from oblivion (and helping me out). :) – Russ May 26 '16 at 07:57

score 6 · Answer 2 · answered Aug 03 '15 at 11:31

$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));
}

score 5 · Answer 3 · edited Jun 02 '14 at 13:06

5

you can use

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

Connections and Connection management
PDO::getAttribute

edited Jun 02 '14 at 13:06

Bill the Lizard

398,270
210
566
880

answered Feb 06 '14 at 06:21

Ferrakkem Bhuiyan

2,741
2
22
38

3

`$status = $conn->getAttribute(PDO::ATTR_CONNECTION_STATUS);` – Omar Feb 06 '14 at 06:42

score 1 · Answer 4 · answered Feb 06 '14 at 06:16

1

PDO::getAttribute - Retrieve a database connection attribute

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

answered Feb 06 '14 at 06:16

Tan Hong Tat

6,671
2
27
25

PHP/PDO: How to get the current connection status

4 Answers4

Linked