Assalamu’alaikum

New version of Ry’s paging Class which is ver 0.6 now release.

This version is now support SQLserver database…. how to use Ry’s Paging Class see ry’s paging class ver0.5 for php & mysql

But here, when you call generate variable function you need to give more attribute
$pagination=new pagination;
$var=$pagination->generatevariable(item per page,“your sql string”,“database type”);

For the database type you can choose whether to use sql or mysql

Of course you also need to know how paging work for sql server here the sql syntax example for implementing limit on sql server
$myprojectString=”select top “.$limitperpage.” ID from tablename where ID not in(select top “.$var[0].” ID from tablename)”;

–> $var[0] is generated by function generatevariable() the rest is just the same with how to use Ry’s Paging Class ver0.5

For the class you can download here

If you find any error or new modification please report to me. Hopefully we can develop some future work together

Enjoy!!!

Wassalamu’alaikum