Multiple Database Configuration about bjyprofiler HOT 2 CLOSED

// config/autoload/global.php
<?php return array(
    'db' => array(
        'driver' => 'Pdo',
        'dsn' => 'mysql:dbname=spinfo_blog;host=localhost',
        'username'       => 'root',
        'password'       => '123456',
        //other adapters...
        'adapters' => array(
            'user-db-driver' => array(
                'driver'         => 'Pdo',
                'dsn'            => 'mysql:dbname=spinfo_users;host=localhost',
                'username'       => 'root',
                'password'       => '123456',
            ),
            'image-db-driver' => array(
                'driver'         => 'Pdo',
                'dsn'            => 'mysql:dbname=spinfo_images;host=localhost',
                'username'       => 'root',
                'password'       => '123456',
            )
        )
    ),
    'service_manager' => array(
        'factories' => array(
            'Zend\Db\Adapter\Adapter' => 'Zend\Db\Adapter\AdapterServiceFactory',
        ),
        // to allow other adapters based on the adapters config.
        'abstract_factories' => array(
            'Zend\Db\Adapter\AdapterAbstractServiceFactory'
        )
    )
);

<?php
//config/autoload/bjyprofiler.local.php
$prepareAdapter = function($dbParams) {
    $adapter = new BjyProfiler\Db\Adapter\ProfilingAdapter($dbParams);

    if (php_sapi_name() == 'cli') {
        $logger = new Zend\Log\Logger();
        // write queries profiling info to stdout in CLI mode
        $writer = new Zend\Log\Writer\Stream('php://output');
        $logger->addWriter($writer, Zend\Log\Logger::DEBUG);
        $adapter->setProfiler(new BjyProfiler\Db\Profiler\LoggingProfiler($logger));
    } else {
        $adapter->setProfiler(new BjyProfiler\Db\Profiler\Profiler());
    }

    if (isset($dbParams['options']) && is_array($dbParams['options'])) {
        $options = $dbParams['options'];
    } else {
        $options = array();
    }
    $adapter->injectProfilingStatementPrototype($options);
    return $adapter;
};

return array(
    'service_manager' => array(
        'factories' => array(
            'db' => function (\Zend\ServiceManager\ServiceManager $sm) use ($prepareAdapter) {
                $config = $sm->get('Config');
                $dbParams = $config['db'];

                return $prepareAdapter($dbParams);
            },
            'user-db-driver' => function (\Zend\ServiceManager\ServiceManager $sm) use ($prepareAdapter) {
                $config = $sm->get('Config');
                $dbParams = $config['db']['adapters']['user-db-driver'];

                return $prepareAdapter($dbParams);
            },
            'image-db-driver' => function (\Zend\ServiceManager\ServiceManager $sm) use ($prepareAdapter) {
                $config = $sm->get('Config');
                $dbParams = $config['db']['adapters']['image-db-driver'];

                return $prepareAdapter($dbParams);
            }
        ),
    ),
);