fbf/mysql-reconnect

A PDO wrapper that reconnects automatically and re-issues queries on receiving MySQL server timeout errors

v0.1.0 2013-10-14 12:45 UTC

This package is not auto-updated.

Last update: 2024-12-16 17:34:29 UTC


README

A PDO wrapper that reconnects automatically and re-issues queries on receiving MySQL server timeout errors

Usage

$config = array(
	'driver' => 'mysql',
    'host' => 'localhost',
    'database' => 'mydb',
    'user' => 'username',
    'pass' => 'password',
);

$db = new Fbf\MysqlReconnect\Db($config);

$sql = "SELECT * FROM posts WHERE id = :id";

$data = array('id' => 1);

$sth = $db->query($sql, $data);

$post = $sth->fetchObj();

How it works

Uses __call() magic method to pass off methods called to the PDO connection object, so you can call whatever you like on $db and it will pass it off to PDO. Inside the magic method we catch timeout exceptions and then reconnect before re-issuing the query.