File: readme.md

Recommend this page to a friend!

Classes of NoobSaiboT TheFreakative (iTs)

readme.md

File:	`readme.md`
Role:	Documentation
Content type:	`text/markdown`
Description:	Documentation
Class:	Simple PHP Pagination Class Display paginated database table records
Author:	By NoobSaiboT TheFreakative (iTs)
Last change:	fixed a typo :D
Date:	6 years ago
Size:	`1,907 bytes`

Download

Simple Pagination Class

This is a simple class that implements pagination when connected to a mysql databse via PDO.

- Include the class - Set the name of your table, number of items per page - edit the ouputted html however you want and voila !

It is really easy to set up. No hassle or stress.

Requirements

To work properly, the class needs:

PHP 5 and above, (tested on PHP 7 but should work flawlessly on PHP 5)
Web server with PHP and mySQL installed

Installation

This class requires PHP 5 + to run.

Download and extract (https://github.com/sayopaul/paginationclass).

Set your config.php file

<?php
	//set your database comnfiguration here. Ensure to fill in the username and password if there is any.
	define("DSN","mysql:host=dbhost;dbname=dbname");
	define("USER","username");
	define("PASS","password");

After that, you create a new PDO object with the config details

<?php
		//!important ---- require the config file and the Pagination class
		require "config.php";
		include "Pagination.class.php";
		//initialize PDO connection and save object to $db
		try{
			$db=new PDO(DSN,USER,PASS);
		}catch(PDOException $e){
			echo "could not connect because of " .$e ;
		}
		//pass the pdo object,the number of listings per page, and the table name to the class. 
		$paginate = new Pagination($db,5,"customers");
		//call the paginate methods
		$test =$paginate->paginate();
		//print out the returned result
		echo $test;

There's a test file using bootstrap that shows a proper example