27/02
2015
Classes for Paging
A class for implementing paging, (*1)
A very light and simple class that implement paging with mySql., (*2)
PHP 5 >= 5.3.0
First instantiate a paging object like $paginering = new \phpe\paginering\CPaginering(); Count ever item in your SQL table eg, "SELECT * FROM VFullViewMovies". Then wirte your SQL query, eg "SELECT * FROM VFullViewMovies WHERE genre = action LIMIT ".$_GET['hits']." OFFSET ".(($_GET['page'] - 1) * $_GET['hits']).", (*3)
Then set $paginering->setTotalRows($_GET['hits'], $_GET['page'], count($AllTableItems));, (*4)
You will then get the html code with: $paginering->GetPageNav(); $paginering->GetNbrOfHitsPerPage();, (*5)