Login   Register  
PHP Classes
elePHPant
Icontem

File: examples/mysql.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Mark Rolich  >  Generic Pager  >  examples/mysql.php  >  Download  
File: examples/mysql.php
Role: Example script
Content type: text/plain
Description: Example of mysql pagination
Class: Generic Pager
Browse listings of entries split in multiple pages
Author: By
Last change:
Date: 2012-02-28 00:18
Size: 1,320 bytes
 

Contents

Class file image Download
<?php
include '../Pager.php';

$itemsPerPage = 10;
$currentPage = (isset($_GET['p']) && $_GET['p'] != '') ? (int)$_GET['p'] : 1;

$dbh = new PDO('mysql:host=localhost;dbname=pager_test', 'root', '');

$countStmt = 'SELECT count(*) as cnt FROM data';
$sth = $dbh->prepare($countStmt);
$sth->execute();

$res = $sth->fetch();

$totalCount = $res['cnt'];

$pager = new Pager($totalCount, $currentPage);

$offset = $pager->getOffset();

if ($offset != -1) {
    $pageStmt = 'SELECT country, cc_alpha2, cc_alpha3, cc_num FROM data LIMIT '
    . $offset . ', ' . $itemsPerPage;

    $sth = $dbh->prepare($pageStmt);
    $sth->execute();

    $pageData = $sth->fetchAll(PDO::FETCH_ASSOC);
} else {
    $pageData = array();
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
  "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>Pager - MySQL example</title>
    <link rel="stylesheet" type="text/css" href="example.css">
</head>
<body>
<?php if (!empty($pageData)) { ?>

<table class="data">
<?php foreach ($pageData as $data) { ?>
<tr><td><?php echo implode('</td><td>', $data); ?></td></tr>
<?php } ?>
</table>

<?php } else { ?>
<div>No records found</div>
<?php } ?>

<?php echo $pager; ?>
</body>
</html>