How to access PDO instance created with DI in dependencies.php

Question

How do I get the PDO connection in my model class that was created in dependicies.php?

I have Controller and Model classes.

My route:

$app->group('/users', function (Group $group) {
  $group->get('', [UsersController::class, 'getAll'], function (Request $request, Response $response) {
     return $response;
  });
});

My Controller:

namespace App\Application\Controllers;

use Psr\Http\Message\ResponseInterface as Response;
use Psr\Http\Message\ServerRequestInterface as Request;
use App\Application\Models\UsersService;

class UsersController
{

  private $_usersSvc;

  public function __construct()
  {
    $this->_usersSvc = new UsersService();
  }

  public function getAll(Request $request, Response $response)
  {
    $uri = $request->getUri();
    parse_str($uri->getQuery(), $params);
    $result = $this->_usersSvc->getAll($params);
    $response->getBody()->write(json_encode($result));

    return $response;
  }

My DI setup in dependencies.php

return function (ContainerBuilder $containerBuilder) {
    $containerBuilder->addDefinitions([
        LoggerInterface::class => function (ContainerInterface $c) {
            $settings = $c->get(SettingsInterface::class);

            $loggerSettings = $settings->get('logger');
            $logger = new Logger($loggerSettings['name']);

            $processor = new UidProcessor();
            $logger->pushProcessor($processor);

            $handler = new StreamHandler($loggerSettings['path'], $loggerSettings['level']);
            $logger->pushHandler($handler);

            return $logger;
        },
        PDO::class => function (ContainerInterface $c) {
            $settings = $c->get('settings');
            $db = [
              'dbname' => $settings['db']['name'],
              'user'   => $settings['db']['username'],
              'pass'   => $settings['db']['password'],
              'host'   => $settings['db']['host']
            ];
      
            $connection = new PDO("mysql:host=" . $db['host'] . ";port=3306;dbname=" . $db['dbname'], $db['user'], $db['pass']);
            $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            $connection->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
      
            return $connection;
          },        
    ]);
};

My Model Class

namespace App\Application\Models;

use App\Application\Models\DataObjects;
use Psr\Log\LoggerInterface;
use Psr\Container\ContainerInterface;
use DateTime;
use PDO;

class UsersService extends DataObjects
{
    protected $db;

    public function __construct()
    {   

    }

    public function getAll($params)
    {
        $orderBy = (isset($params['sortdesc']) && empty($params['sortdesc']) === false) ? $params['sortdesc'] . ' DESC' : null;
        if ($orderBy === null) {
            $orderBy = (isset($params['sortasc']) && empty($params['sortasc']) === false) ? $params['sortasc'] . ' ASC' : '';
        }

        return $this->loadAll($orderBy);
    }
}

How to access $connection instance from dependencies.php in my model class?

_Side note:_ I haven't used Slim v4, but that route looks a bit strange. Shouldn't you have either a reference to a controller class (like your `[UserController::class, 'getAll']` or a closure as the second argument, not both at the same time as different arguments? — M. Eriksson, Jan 27 '22 at 22:04
`UserService::__connstruct()` should accept a parameter of type `PDO` (the type that resolves to the `$connection` you are referring to). Something like `function __construct(PDO $connection) { $this->connection = $connection;}`. Also, I think M. Eriksson's point about route callback definition is valied. — Nima, Jan 28 '22 at 16:55

How to access PDO instance created with DI in dependencies.php

0 Answers0