pdo mysql ping_如何ping MySQL数据库并使用PDO重新连接

I am using MySQL PDO for handling database querying and all. But most of the time, the MySQL connection is gone away. So i am looking in the PDO that will check if the db connection is exists or not and if it is not exit, then i need to connect the database to continue the query execution.

I am new to the MySQL pdo and i do not know how to handling this situation. It would be better if anybody suggest on this.

解决方案

I tried to find a solution for the same problem and I found the next answer:

class NPDO {

private $pdo;

private $params;

public function __construct() {

$this->params = func_get_args();

$this->init();

}

public function __call($name, array $args) {

return call_user_func_array(array($this->pdo, $name), $args);

}

// The ping() will try to reconnect once if connection lost.

public function ping() {

try {

$this->pdo->query('SELECT 1');

} catch (PDOException $e) {

$this->init(); // Don't catch exception here, so that re-connect fail will throw exception

}

return true;

}

private function init() {

$class = new ReflectionClass('PDO');

$this->pdo = $class->newInstanceArgs($this->params);

}

}

Somebody else was thinking to use PDO::ATTR_CONNECTION_STATUS, but he figured out that: "$db->getAttribute(PDO::ATTR_CONNECTION_STATUS) keeps replying “Localhost via UNIX socket” even after stopping mysqld".