What is the best PHP mssql pagination class?: Example mssql pagination with php

I would like to perform queries to a Microsoft SQL server and retrieve the results to be displayed in a paginated listing.

by Stefan Kientzler package author 370 - 3 years ago (2020-08-16) Comment

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

$dsn = "sqlsrv:Server=YourSQLServer;Database=YourDatabase";
$pdo = new PDO($dsn, "Username", "Password");
foreach ($pdo->query("SELECT * FROM tUser") as $row) {
    $pdf->Row($row);
}

by Manuel Lemos 23295 - 3 years ago (2020-08-15) Comment

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.