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
Requires
- php: >=5.3.0
This package is not auto-updated.
Last update: 2024-11-04 17:04:20 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.