Login   Register  
PHP Classes
elePHPant
Icontem

File: examples/pdo_prepared_2.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  >  Extended Generic Pager  >  examples/pdo_prepared_2.php  >  Download  
File: examples/pdo_prepared_2.php
Role: Example script
Content type: text/plain
Description: Example of PDO prepared pagination
Class: Extended Generic Pager
Paginate data listings from arrays, CSV or MySQL
Author: By
Last change:
Date: 2 years ago
Size: 599 bytes
 

Contents

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

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

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

$id 1;
$country 'A%';

$dataOptions = array(
    
'handle' => $dbh,
    
'query' => 'SELECT * FROM data WHERE id > :id AND country LIKE :country',
    
'params' => array(':id' => $id':country' => $country)
);

$pager = new PagerMySQL($pageNum);
$data $pager->getData($dataOptions);

$pagerNav $pager->render();

$pageTitle 'Pager - PDO prepared example';
include 
'example.tpl.php';
?>