TYPO3 / TYPO3.CMS

     * @param string $table

     * @return int

     */

    public static function getPidOfUid($uid, $table)

    {

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

        $queryBuilder->getRestrictions()->removeAll();

        $pid = $queryBuilder

            ->select('pid')

            ->from($table)

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

            ->execute()

            ->fetchColumn();

        return (int)$pid;

    }

    /**

     * Gets the TCA of the table used in the current context.

     * @param int $uid Record uid

     * @return int|false PID value (unless the record did not exist in which case FALSE is returned)

     */

    public function getPID($table, $uid)

    {

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

        $queryBuilder->getRestrictions()

            ->removeAll();

        $queryBuilder->select('pid')

            ->from($table)

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

        if ($row = $queryBuilder->execute()->fetch()) {

            return $row['pid'];

        }

        return false;

    }

    /**

     * Executing dbAnalysisStore