TYPO3 v9 has reached its end-of-life September 30th, 2021 and is not maintained by the community anymore. Looking for a stable version? Use the version switch on the top left.

You can order Extended Long Term Support (ELTS) here: TYPO3 ELTS.

Accessing the Database

The TYPO3 database should always be accessed using the QueryBuilder of doctrine. The TYPO3\CMS\Core\Database\ConnectionPool class can be used to create a \TYPO3\CMS\Core\Database\Query\QueryBuilder instance:

$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tablename');

See the Database Access API documentation for more details.