TYPO3 / TYPO3.CMS

     * @param int $uid

     * @return string

     */

    public static function getDomainName($uid)

    {

        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)

            ->getQueryBuilderForTable('sys_domain');

        $domain = $queryBuilder

            ->select('domainName')

            ->from('sys_domain')

            ->where($queryBuilder->expr()->eq('pid', $queryBuilder->createNamedParameter($uid, \PDO::PARAM_INT)))

            ->setMaxResults(1)

            ->orderBy('sorting')

        ->execute()

        ->fetch();

        return is_array($domain) ? htmlspecialchars($domain['domainName']) : '';

    }

    /**

     * Creates a node with the given record information

     * @param int $id Page id

     * @return string Domain name

     */

    protected function getFirstSysDomainRecordForPage($id)

    {

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

        $queryBuilder->setRestrictions(GeneralUtility::makeInstance(FrontendRestrictionContainer::class));

        $row = $queryBuilder

            ->select('domainName')

            ->from('sys_domain')

            ->where(

                $queryBuilder->expr()->eq(

                    'pid',

                    $queryBuilder->createNamedParameter($id, \PDO::PARAM_INT)

                )

            )

            ->orderBy('sorting')

            ->setMaxResults(1)

            ->execute()

            ->fetch();

        return rtrim($row['domainName'], '/');

    }

    /**

     * simple function to initialize possible external parsers