PHP Classes

File: test.php

Recommend this page to a friend!
  Classes of Olavo Alexandrino   Generic Easy Pagination   test.php   Download  
File: test.php
Role: Example script
Content type: text/plain
Description: Example script
Class: Generic Easy Pagination
Pagination of arbitrary listings
Author: By
Last change:
Date: 20 years ago
Size: 1,753 bytes
 

Contents

Class file image Download
<?php require_once('YOU_PATH/adodb.inc.php'); ?>
<?php
require_once('YOU_PATH/class.GenericEasyPagination.php'); ?>
<?
///////////////////////////////////////////////////////////////////
// Define Constants
if ($_GET["page"]!=""): $page = $_GET["page"]; else: $page = 1; endif;
define ('RECORDS_BY_PAGE',5);
define ('CURRENT_PAGE',$page);


///////////////////////////////////////////////////////////////////
// Connection Of DataBase
$objConnection = &ADONewConnection('mysql');
$objConnection->Connect('localhost','root','','test');


///////////////////////////////////////////////////////////////////
// Select Records By "PageExecute Method"
$strSQL = " SELECT id_user,user_name FROM users ORDER BY user_name";
$objConnection->SetFetchMode(ADODB_FETCH_ASSOC);
$rs = $objConnection->PageExecute($strSQL,RECORDS_BY_PAGE,CURRENT_PAGE);


///////////////////////////////////////////////////////////////////
// Display Records
if (!$rs->EOF)
{
   
$recordsFound = $rs->_maxRecordCount;
    echo
"RecordsLits:<br><br>";
    while(!
$rs->EOF)
    {
        echo
"<strong>User Name:</strong> ".$rs->fields["user_name"]." (<strong>id</strong>: ".$rs->fields["id_user"].")<br>";
       
$rs->moveNext();
    }
   
   
///////////////////////////////////////////////////////////////////
    // Pagination
   
$GenericEasyPagination =& new GenericEasyPagination(CURRENT_PAGE,RECORDS_BY_PAGE,"eng");
   
$GenericEasyPagination->setTotalRecords($recordsFound);
    echo
"<br>";
    echo
"<strong>Records found: </strong>".$recordsFound;
    echo
"<br>Records ";
    echo
$GenericEasyPagination->getListCurrentRecords();
    echo
"<br>";
    echo
$GenericEasyPagination->getNavigation();
    echo
"<br>";
    echo
$GenericEasyPagination->getCurrentPages();
    echo
"<br>";

}
?>