<?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);
?>
|
Download
