Wrong number of records in Export Data after changing records per page

PHPMaker General Discussion (PHPMaker)
1

PHPMaker v2026.6.

Here are the steps to reproduce the issue:

  1. Open the generated demo2026 web application via browser, login by using user admin and password master,
  2. Go to Orders List page, by default, you will see only 10 records per page are displayed,
  3. Now let’s change that record per page, from 10 to 20, then you will see records per page are 20, so far so good,
  4. Just click Next button in pager section, so that you are in page 2, and number of records per page are still correct displayed 20, so far so good,
  5. Now here is the issue…, if you click on either Export to Excel, Export to Word, Export to HTML, Export to XML, or Export to CSV, then you will see that in the related files, the number of records that exported are still 10 instead of 20.
2

The latest template fixed the main issue.

Only a small issue found for Printer Friendly and Export to XML, since both use the same page with the List Page, then when you back from the Exported page to the List Page again, you will see the correct number of records per page for a while, but…, when you navigate to next page, then the records per page will be back from 20 to 10 again. This is due to the change in browser tab id so the session value stored for records per page is lost. You can either:

  • disable tab id for the session value (in src/DbTable.php) as follows:
// Records per page
public function getRecordsPerPage(): int
{
    return Session(PROJECT_NAME . "_" . $this->TableVar . "_" . Config("TABLE_REC_PER_PAGE")) ?? 0;
}

public function setRecordsPerPage(int $v): void
{
    Session(PROJECT_NAME . "_" . $this->TableVar . "_" . Config("TABLE_REC_PER_PAGE"), $v);
}

– OR –

  • if you don’t want to customize that code above, just disable tab id for entire project by simply put this following code in Global Code:

    Config("USE_TAB_ID", false);

Thanks to Support, once again. :+1: :+1: