PHP Classes
elePHPant
Icontem

File: PaginationExample.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Sujay Bhowmick  >  Pagination  >  PaginationExample.php  >  Download  
File: PaginationExample.php
Role: Example script
Content type: text/plain
Description: Pagination example file
Class: Pagination
Result Set pagination with database abstraction
Author: By
Last change:
Date: 11 years ago
Size: 3,085 bytes
 

Contents

Class file image Download
<?php
include_once("PaginationFactory.php");
include_once(
"DatabaseQueriesFactory.php");
include_once(
"ConnectionManagerFactory.php");
include_once(
"DBTypes.php");

$resultPage = $_REQUEST["resultPage"];
 
/**
  * Get the corresponding ConnectionManager object w.r.t to database specified in DB_TYPE constant(DBTypes.php).
  * Factory Method.
  * One can use their own connection object. I used here ConnectionManager Class to connect to the database.
  * You can find the ConnectionManager Class at the following url http://www.phpclasses.org/browse.html/package/1429.html
  */
$objConnectionClass = ConnectionManagerFactory::getInstanceOf(DB_TYPE);

/**
 * Invoke the doConnection object to make a connection to the specified database
 */
$objConnectionClass->doConnection();

/**
 * Get the connectionHandle (Base Class Method).
 */
$conn = $objConnectionClass->getConnectionHandle();

/**
 * Select the database.
 */
$objConnectionClass->selectDatabase();

$selquery = "select * from alumini order by firstname";



/**
 * $edited = "F";
 * $selquery = "SELARTICLES"; //(Procedure name).
 * $params = array("@edited"=>array($edited=>SQLCHAR, false)); // (Procedure Parameters).
 */
$params = null;

/**
 * Get the corresponding DatabaseQueries object w.r.t to database specified in DB_TYPE constant(DBTypes.php).
 * Factory Method.
 */

/**
 * if $params in null it means the query is of type inline otherwise it is a procedure and provide the $params associative array
 * as follows:-
 * $params -- Associative array eg. array("@edited"=>array($edited=>SQLCHAR, false));
 * where -- @edited is input/output paramter,
 * -- $edited is the value of Input Parameter @edited,
 * -- SQLCHAR is a the MSSQL Constant for CHAR column type,
 * -- false indicates @edited is not an output parameter.
 * For Pagination we need to pass the result set and connection object as parameters. One can use their own component to get the
 * result set and connection object. In this example I used my own DatabaseQueries component to get the result set and execute queries.
 */
       
$objDatabaseClass = DatabaseQueriesFactory::getInstanceOf($selquery, $conn, $params, DB_TYPE);

/**
 * Call the executeQuery method.
 */
if(!$objDatabaseClass->executeQuery())
{
    die(
"Cannot query");
}

 
/* $result = your resultset fetched from database by calling base class method getResultSet(). */

$result = $objDatabaseClass->getResultSet();
 
/**
 * get the number of rows in a result set.
 */
$rowcount = $objDatabaseClass->getNumRows();

/**
 * Get the corresponding Pagination object w.r.t to database specified in DB_TYPE constant(DBTypes.php).
 * Factory Method.
 */

$objPagination = PaginationFactory::getInstanceOf($result, 1, $conn, $rowcount, $resultPage, DB_TYPE);

/**
 * Get the page data by calling getPageData() method.
 */
while($row = $objPagination->getPageData())
{
   
/* display your data */
}
   
/**
 * display the page navigation links (Base Class Method).
 */
echo $objPagination->getPageNav();

unset(
$objConnectionClass);
unset(
$objDatabaseClass);
unset(
$objPagination);
?>