PHP Classes

PHP Pagination Links: Display links to browse pages of entry listings

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 196 All time: 8,520 This week: 455Up
Version License PHP version Categories
pagination-links 1.0.1MIT/X Consortium ...5HTML, Databases
Description 

Author

This class can display links to browse pages of entry listings.

It can take as parameter the total number of entries in a listing, the limit number of entries to display per page and the number of the current listing page.

The class can generate links to browse to the other pages of the listings.

The format of the link URLs, show the first and last links, show links a page numbers are configurable options.

Picture of Miraz Mac
  Performance   Level  
Name: Miraz Mac <contact>
Classes: 13 packages by
Country: Bangladesh Bangladesh
Age: 30
All time rank: 201529 in Bangladesh Bangladesh
Week rank: 288 Up5 in Bangladesh Bangladesh Up
Innovation award
Innovation award
Nominee: 5x

Example

<?php

/**
 * Sample Use of PaginationLinks with PDO and SQLite
 * Works with other databases like MySQL, MSSQL etc. too!
 *
 * @package PaginantionLinks
 */

require_once '../src/Pagination.php';

use
MirazMac\Pagination\Pagination;

// Database file path
$db_file = __DIR__ .'/demoDataBase.sqlite';

// Connect to database using PDO
$db = new PDO('sqlite:'.$db_file);

// Current page number
$current_page = (int)@$_GET['page'];

// Number of items/rows per page
$items_per_page = 10;

// Fetch Number of total items from database
$sql = "SELECT COUNT(id) AS total_count FROM demoTable";
$query = $db->prepare($sql);
$query->execute();

$total_items = $query->fetch()['total_count'];

// Create pagination instance
$pagination = new Pagination($total_items, $current_page);
$pages = $pagination->parse();

// Get offset number
$start = $pagination->offset();
// Query the database to fetch paginated rows
$sql = "SELECT * FROM `demoTable` LIMIT $start, $items_per_page";
$query = $db->prepare($sql);
$query->execute();

while (
$row = $query->fetch()) {
    echo
'<pre>';
    echo
$row['id'].'.';
    echo
$row['name'];
    echo
'</pre>';
}

echo
'<hr/>';

echo
$pagination->renderHtml();


Details

Pagination

Generate PHP pagination links with ease.


  Files folder image Files (6)  
File Role Description
Files folder imageexamples (1 file)
Files folder imagesrc (2 files)
Accessible without login Plain text file composer.json Data Auxiliary data
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file README.md Doc. Documentation

  Files folder image Files (6)  /  examples  
File Role Description
  Accessible without login Plain text file PDOExample.php Example Example script

  Files folder image Files (6)  /  src  
File Role Description
  Plain text file Pagination.php Class Class source
  Plain text file PaginationLinks.php Class Class source

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 83%
Total:196
This week:0
All time:8,520
This week:455Up