How to do pagination of table which is fetched from MS SQL ?

I will show you what i usually do, others might have better solutions.

First we save the results from the query on a variable:

$results = your_query_function(arg);

Then we count the number of results:

$number_of_results = count($results);

Then we need to decide how many results per page so we can know how many pages are needed:

//in this case i choose 10 results per page
$pages = ceil($number_of_results / 10);

Now here is the tricky part, you need to know in which page you are so you can get the correct results displayed, page 1 will show 1 to 10, page 2 11 to 20 and so forth.

What i do is to have a variable with the page number, usually through a get. Like this:

//keep im mind that this should be better sanitized
$page = htmlspecialchars($_GET['page']);

So now we know the page we are in, time to get the correct results:

//Set the starting point where we are going to slice the array
$start = $page * 10;
//starting point of the array according to page
$results_to_display = array_slice($number_of_results, $start, 10);

So now we have the correct results in the correct page so you just need to do a loop to display them

At the end we need to create the pagination, i do a for loop:

for($i=0;$i<$pages;$i++){
 echo '<li class="yourCoolClass"><a href="'yoururl?page=' . $i . '">' . ($i+1). '</a></li>';
}