PHP Classes

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

Recommend this page to a friend!
  All requests RSS feed  >  What is the best PHP mssql pagination...  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

What is the best PHP mssql pagination class?

Edit

Picture of DONGGYUN KIM by DONGGYUN KIM - 3 years ago (2020-08-13)

Example mssql pagination with php

This request is clear and relevant.
This request is not clear or is not relevant.

+3

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

Ask clarification

2 Recommendations

PHP PDF Table using FPDF: Generate PDF documents with tables displaying data

This recommendation solves the problem.
This recommendation does not solve the problem.

+1

Picture of Stefan Kientzler by Stefan Kientzler package author package author Reputation 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);
}


PHP PDO database class: Access databases using PDO

This recommendation solves the problem.
This recommendation does not solve the problem.

0

Picture of Manuel Lemos by Manuel Lemos Reputation 23325 - 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.


Recommend package
: 
: