herrera-io/silex-pdo

A simple PDO service provider.

PDO Service Provider

![Build Status], _(*1)

A simple PDO service provider., _(*2)

Summary

A stupid simple PDO service provider. I cannot get any more clear than this., _(*3)

Installation

Add it to your list of Composer dependencies:, _(*4)

$ composer require "herrera-io/silex-pdo=1.*"

Usage

use Herrera\Pdo\PdoServiceProvider;
use Silex\Application;

$app = new Application();
$app->register(
    new PdoServiceProvider(),
    array(
        'pdo.dsn' => 'pdo_mysql:dbname=test;host=127.0.0.1',
        'pdo.username' => 'username', // optional
        'pdo.password' => 'password', // optional
        'pdo.options' => array( // optional
            PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'UTF8'"
        )
    )
);

$pdo = $app['pdo'];

You can also use the PdoTrait to add a prepare method to your application:, _(*5)

use Herrera\Pdo\PdoTrait;
use Silex\Application;

class MyApp extends Application
{
    use PdoTrait;
}

You will still need to register the service provider., _(*6)

If debugging is enabled and Monolog is available, a logging version of PDO will be used to log queries and their execution time., _(*7)