PHP 데이터베이스 연결 스캐폴딩: 재사용 및 유지 관리가 가능한 연결 코드를 빠르게 생성

use Zend\Db\Adapter\Adapter;

$adapter = new Adapter([
    'driver' => 'Pdo',
    'dsn' => 'mysql:host=localhost;dbname=testdb',
    'username' => 'username',
    'password' => 'password',
]);

$result = $adapter->query('SELECT * FROM users');

class UserController {

    protected $adapter;

    public function indexAction()
    {
        $result = $this->adapter->query('SELECT * FROM users');
        return $result;
    }

    public function updateAction()
    {
        $result = $this->adapter->query('UPDATE users SET name = "New Name" WHERE id = 1');
        return $result;
    }
}

class UserController {

    protected $adapter;

    public function __construct(Adapter $adapter)
    {
        $this->adapter = $adapter;
    }

    public function indexAction()
    {
        $result = $this->adapter->query('SELECT * FROM users');
        return $result;
    }

    public function updateAction()
    {
        $result = $this->adapter->query('UPDATE users SET name = "New Name" WHERE id = 1');
        return $result;
    }
}