|All requests||>||What is the best PHP mssql pagination...||>||Request new recommendation||>||Featured requests||>||No recommendations|
by DONGGYUN KIM - 2 years ago (2020-08-13)
I would like to perform queries to a Microsoft SQL server and retrieve the results to be displayed in a paginated listing.
With simple DB access (like Manuel, I also recommend doing this via PDO ...) and with this package, you can define any PDF reports that list the retrieved data according to your requirements. You can define the page format (portrait, landscape, size), column headings, and the columns you want to display. If necessary, the display of the total (including subtotal / transfer) can be defined for numeric columns.
Just look at the example that is included in the package and replace the 'dataloop' with something like
Nowadays is better to use the PDO extension for instance with a package like this to display paginated results to a many databases including Microsoft SQL server.