MyPDO
MyPDO is a wrapper that adds a few features missing from vanilla PDO:
- Explicit disconnection
- Automatic reconnection (no more 2006 MySQL server has gone away)
- Nested transactions
- Methods chainability
- Hidden password from the stack trace (in case of error)
- Helpers methods (e.g. ping()
), (*1)
Important: MyPDO is designed for MySQL only., (*2)
This class will not add higher logic to PDO (such as data mapping, etc.). It is only intended to add low-level features., (*3)
, (*4)
Basic example
This class is intented to be a drop-in replacement for PHP's default PDO. There is nothing special to do, just use MyPDO
class instead of PDO
and you're good to go., (*5)
Complete doc is available in the wiki., (*6)
Requirements
Installation
The recommended way is to install the lib through Composer., (*7)
Just add this to your composer.json
file (change the version by the release you want, or use dev-master
for the development version):, (*8)
{
"require": {
"rlanvin/php-mypdo": "1.*"
}
}
Then run composer install
or composer update
., (*9)
Now you can use the autoloader, and you will have access to the library:, (*10)
<?php
require 'vendor/autoload.php';
Alternative method
You can just download src/MyPDO.php
and src/MyPDOStatement.php
(if you want to use prepared statements) and require them., (*11)
Documentation
Complete doc is available in the wiki., (*12)
Contribution
Feel free to contribute! Just create a new issue or a new pull request., (*13)
License
This library is released under the MIT License., (*14)