Slim 3.0 + DBAL 最小应用

Question

<?php
use Psr\Http\Message\ServerRequestInterface;
use Psr\Http\Message\ResponseInterface;

require __DIR__ . '/../vendor/autoload.php';

$container = new \Slim\Container;

$container['db'] = function ($container) {
  $config = new \Doctrine\DBAL\Configuration();
  $connectionParams = array(
      'dbname' => 'slim',
      'user' => 'root',
      'password' => 'password',
      'host' => 'localhost',
      'driver' => 'pdo_mysql',
  );
  $conn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);

  return $conn;

};

$app = new \Slim\App($container);
$app->get('/', function (ServerRequestInterface $request, ResponseInterface $response) {

    $db = $this->get('db');
    $queryBuilder = $db->createQueryBuilder();

    /*
    $sql = "select * from users where id=?";
    $stmt = $db->prepare($sql);

    $stmt->bindValue(1, 1);

    $stmt->execute();
    $result = $stmt->fetchAll();
    dump($result);die();
    */

    $queryBuilder->select('*')
                ->from('users')
                ->where('id = ?')
                ->setParameter(0, 1);
    $result = $queryBuilder->execute()->fetchAll();
    dump($result);die();


    $body = $response->getBody();
    $body->write('Hello');

    return $response;
});
$app->run();