phpe / cpaging

v1.0 2015-02-16 14:24 UTC

Requires

• php: >=5.3

MIT

• Philip Persson

• paging

Published on Packagist.org on 2015-02-17 16:58 UTC

README

A class for implementing paging

About

A very light and simple class that implement paging with mySql.

PHP 5 >= 5.3.0

Introduction

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'])."

Then set $paginering->setTotalRows($_GET['hits'], $_GET['page'], count($AllTableItems));

You will then get the html code with: $paginering->GetPageNav(); $paginering->GetNbrOfHitsPerPage();