/** * get a limitted amount of search results for a requested page * @return array Array containing a limitted (one page) amount of search results */ public function getSearchResultByMySQL() { $queryParts = $this->getQueryParts(); // log query if ($this->conf['logQuery']) { $query = $GLOBALS['TYPO3_DB']->SELECTquery($queryParts['SELECT'], $queryParts['FROM'], $queryParts['WHERE'], $queryParts['GROUPBY'], $queryParts['ORDERBY'], $queryParts['LIMIT']); TYPO3\CMS\Core\Utility\GeneralUtility::devLog('Search result query', $this->pObj->extKey, 0, array($query)); } $this->searchResults = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows($queryParts['SELECT'], $queryParts['FROM'], $queryParts['WHERE'], $queryParts['GROUPBY'], $queryParts['ORDERBY'], $queryParts['LIMIT'], 'uid'); $result = $GLOBALS['TYPO3_DB']->sql_query('SELECT FOUND_ROWS();'); if ($result) { $data = $GLOBALS['TYPO3_DB']->sql_fetch_row($result); $GLOBALS['TYPO3_DB']->sql_free_result($result); $this->numberOfResults = $data[0]; } }