如何在TYPO3中实现远程数据库分页？TYPO3 7前端数据展示求助

Hey there! Let's break down how to solve your two key challenges with TYPO3 7: displaying database content (since cag_tables won't work) and handling pagination for remote database data.

1. Displaying Database Content (Alternative to cag_tables) #

Since cag_tables only supports TYPO3 6.0, here are your best options for TYPO3 7:

Option 1: Build a Custom Extbase Extension (Most Flexible) #

TYPO3 7 fully supports Extbase, which is the recommended way to create custom, maintainable functionality. Here's a quick workflow:

• Use the Extension Builder tool (built into TYPO3 7) to generate a basic extension structure. Define your target database table as a model, then set up a controller to fetch data.
• In your controller action, use Extbase's Query API to pull records:

  $query = $this->yourCustomRepository->createQuery();
  $records = $query->execute();
  

• Pass the $records variable to your Fluid template, then render the content with Fluid loops:

  <f:for each="{records}" as="record">
    <div class="record-item">
      <h3>{record.title}</h3>
      <p>{record.description}</p>
    </div>
  </f:for>
  

This approach follows TYPO3 best practices and gives you full control over styling and data filtering.

Option 2: Use Legacy Database API (Quick & Simple) #

If you don't want to set up a full Extbase extension, you can use TYPO3's legacy database API (still fully functional in TYPO3 7) in a custom plugin:

• Create a basic plugin via the TYPO3 backend, then add code to fetch data directly:

  // Fetch all records (add WHERE clauses as needed)
  $query = 'SELECT * FROM your_database_table WHERE 1';
  $result = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows($query);
  

• Pass the $result array to your template and render it with simple loops. Just remember to sanitize any user input if you add dynamic filters!

Option 3: Find a TYPO3 7-Compatible Extension #

Check the TYPO3 Extension Repository (filter for TYPO3 7 compatibility) for pre-built tools. Search terms like "database table view" or "list display" might turn up extensions like db_list that work with your version.

2. Pagination for Remote Database Data #

TYPO3's built-in pagination tools are tied to local database connections, so you'll need a manual approach for remote DBs. Here's how to do it:

Step 1: Connect to the Remote Database #

Use PDO for a secure, flexible connection to your remote database:

try {
    $pdo = new PDO(
        'mysql:host=remote-db-host;dbname=remote-db-name;charset=utf8',
        'your-username',
        'your-password',
        [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
    );
} catch (PDOException $e) {
    die('Remote DB connection failed: ' . $e->getMessage());
}

Step 2: Implement Pagination Logic #

• Get pagination parameters: Fetch the current page from the URL and define items per page:

  $currentPage = (int)$_GET['page'] ?: 1;
  $itemsPerPage = 10; // Adjust based on your needs
  

• Calculate total records: First, get the total number of items to determine page count:

  $countStmt = $pdo->prepare('SELECT COUNT(*) FROM remote_table_name');
  $countStmt->execute();
  $totalItems = $countStmt->fetchColumn();
  $totalPages = ceil($totalItems / $itemsPerPage);
  

• Fetch paginated data: Calculate the offset and pull only the items for the current page:

  $offset = ($currentPage - 1) * $itemsPerPage;
  $dataStmt = $pdo->prepare('SELECT * FROM remote_table_name LIMIT :offset, :limit');
  $dataStmt->bindParam(':offset', $offset, PDO::PARAM_INT);
  $dataStmt->bindParam(':limit', $itemsPerPage, PDO::PARAM_INT);
  $dataStmt->execute();
  $paginatedData = $dataStmt->fetchAll(PDO::FETCH_ASSOC);
  

Step 3: Render Pagination Controls #

Add navigation links to your Fluid template using the pagination variables:

<div class="pagination">
    <f:if condition="{currentPage} > 1">
        <a href="?page={currentPage - 1}" class="pagination-link">Previous</a>
    </f:if>
    <f:for each="{0..totalPages}" as="_" iteration="pageIteration">
        <f:if condition="{pageIteration.cycle} > 0">
            <a href="?page={pageIteration.cycle}" 
               class="pagination-link {f:if(condition: '{pageIteration.cycle} == {currentPage}', then: 'active')}">
                {pageIteration.cycle}
            </a>
        </f:if>
    </f:for>
    <f:if condition="{currentPage} < {totalPages}">
        <a href="?page={currentPage + 1}" class="pagination-link">Next</a>
    </f:if>
</div>

Pass $currentPage and $totalPages to your template to make this work.

Key Notes #

• Always use prepared statements (like the PDO examples) to prevent SQL injection, especially when handling user input from the URL.
• Add indexes to your remote database table to speed up count and fetch operations, especially for large datasets.

内容的提问来源于stack exchange，提问作者Evhenii Vasylenko