Silex + Doctrine DBAL

silex-doctrine-dbal.php

<?php

// ..

$app->register(new Silex\Provider\DoctrineServiceProvider(), [
    'db.options' => [
        'driver' => 'pdo_mysql',
        'host' => 'localhost',
        'port' => 3306,
        'dbname' => 'database_name',
        'user' => 'root',
        'password' => 'password'
    ]
]);

// ..

$params = [':authorId' => 1];
$sql = 'SELECT * FROM articles WHERE author_id = :authorId';

return $app['db']->fetchAll($sql, $params);

// .. composer.json

/*

{
    "require": {
        "silex/silex": "2.2.*",
        "doctrine/dbal": "2.6.*"
    }
}

*/