Site Navigation Code
  Home arrow Site Navigation Code arrow Page Lister Class
Codewalker Forums 
  Tutorials  
Database Articles  
Miscellaneous  
Navigation Usability  
PEAR Articles  
Programming Basics  
Server Administration  
XML Tutorials  
  Reviews  
Database Book Reviews  
Linux Book Reviews  
Miscellaneous Reviews  
PHP Book Reviews  
PHP Software Reviews  
Server Admin Reviews  
SQL Tool Reviews  
  Code Gallery  
Content Management Code  
Contest Code  
Counters Code  
Database Code  
Date Time Code  
Discussion Board Code  
Email Code  
File Manipulation Code  
GUI Code  
Link Farm Code  
Miscellaneous Code  
Search Code  
Site Navigation Code  
User Management Code  
Mobile Linux 
App Generation ROI 
IBM® developerWorks 
Download TestComplete 
Forums Sitemap 
Weekly Newsletter 
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
SITE NAVIGATION CODE

Page Lister Class
By: Codewalkers
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 1
    2002-01-18

    Table of Contents:

    Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Limit the number of returns you get from a MySQL Query and printout navigation links to each of the pages. This was adapted from and performs exactly like nsfmc's in-line code

    By : flight553

    <?php

    /*
    mysql_pager.php
    class by operator@superprivate.com 2001/02/02 12:00
    based on in-line code written by marcos(@)generic.cx on 2000/08/29
    distributed under the Gnu Public License

    just require the class and make a new object, passing in:
    the mysql_query() result,
    the variable $page,
    and the number of results per page you want.
    example at the bottom of this file

    There's $10/month PHP4-MySQL hosting with SSH, telnet, gpg, perl at http://missoulaweb.com

    */

    class mysql_pager {

    // define properties
    var $page;
    var $result;
    var $results_per_page = 3;
    var $total_pages;

    /*
    Define the methods

    1st method is the constructor, which has the same name
    as the class and is called on every instantiation of the class

    pass in the query result handle, current page number and integer how many results per page
    like: $f->mysql_pager($result, 1, 15);
    */

    function mysql_pager( $result, $current_page, $results_per_page ) {

    if(!$result){ # Bogus Query, or mysqld isn't running...
    echo "<div align=center>Either the database is down, or the query was invalid.</div>\n";
    return;
    }

    $this->result = $result;

    if(!$current_page || $current_page < 0)
    $this->page = 1;
    else $this->page = $current_page;

    if(!empty($results_per_page))
    $this->results_per_page = $results_per_page;

    $numrows = @mysql_num_rows($this->result);
    if(!$numrows) {
    echo "<div align=center>No results for that query.</div>\n";
    return;
    }

    $this->total_pages = ceil($numrows / $this->results_per_page);
    # how many pages you WILL get.
    } // end constructor function

    function print_paged_results() {
    /*
    echo "Current Page: ". $this->page ."<br>".
    "Results per Page: ". $this->results_per_page ."<br>";
    */
    echo "<table border=0 align=center>\n";
    $start = ($this->page - 1) * $this->results_per_page;
    mysql_data_seek($this->result, $start); #Moves the pointer to right row

    $x = 0;
    for($i = 1; $i <= $this->results_per_page && $row = @mysql_fetch_array($this->result); $i++) {
    if($x++ & 1) $bgcolor = "#F2F2FF";
    else $bgcolor = "#EEEEEE";

    echo "<tr bgcolor=$bgcolor><td>". $row["lastactiondate"] . "</td></tr>";
    // edit this part to spit out whatever html you want

    } // end for loop

    echo "</table>\n";
    } // end function print_paged_results


    function print_navigation() {
    global $PHP_SELF;

    echo "<div align=center>";

    for($i = 1; $i <= $this->total_pages; $i++) { #loop to print << 1 2 3... $total_pages >>
    if($i == 1 && $this->page > 1) #Prints the << first to goto the previous page (not on page 1)
    echo "<a href=\"$PHP_SELF?page=".($this->page - 1)."\" onMouseOver=\"status='Previous Page';return true;\" onMouseOut=\"status=' ';return true;\">&#0171;&nbsp;</a>";

    if($i == $this->page) #Doesn't print a link itself, just prints page number
    echo "<font color=\"#ff3333\">&nbsp;$i&nbsp;</font>";

    if($i != $this->page) #Other links that aren't this page go here
    echo "<a href=\"$PHP_SELF?page=$i\" onMouseOver=\"status='Go to Page $i';return true;\" onMouseOut=\"status=' ';return true;\">&nbsp;$i&nbsp;</a>";

    if($i == $this->total_pages && $this->page != $this->total_pages) # Link for next page >> (not on last page)
    echo "<a href=\"$PHP_SELF?page=".($this->page + 1)."\" onMouseOver=\"status='Go to the Next Page';return true;\" onMouseOut=\"status=' ';return true;\">&nbsp;&#0187</a>";
    } // end for

    echo "</div>\n";
    } // end function print_navigation

    } // end class definition

    /*
    mysql_connect($server, $uname, $pass );
    mysql_select_db("$db");

    $result= @mysql_query("SELECT * FROM table");

    $p = new mysql_pager( $result, $page, 10 );
    // the variable $page will be created by the output and passed back
    // in as a GET var when you click any of the navigation links

    $p->print_navigation();
    $p->print_paged_results();
    $p->print_navigation();
    }
    */
    ?>
    DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

    More Site Navigation Code Articles
    More By Codewalkers

     

    IBM® developerWorks developerWorks - FREE Tools!


    IBM – Taking Web 2.0 to Work

    You'll get answers to many questions and more from David Barnes, Lead Evangelist for IBM Emerging Internet Technologies. David will discuss aspects of Web 2.0 that bring value to corporations, academia, and government. He'll also discuss IBM's vision around Web 2.0, including the importance of remixability and consumability. The discussion will culminate with examples of various IBM Software Group solutions you can use to get ahead of the Web 2.0 adoption curve.
    FREE! Go There Now!


    NEW! Addressing software-as-a-service challenges using Tivoli security and WebSphere solutions

    Building a software-as-a-service solution requires addressing a few key technical challenges. In this webcast, we'll focus on the role of IBM Tivoli Directory Server and WebSphere Portlet Factory in creating a Software as a Service solution. We will demonstrate how to use Tivoli Directory Server to prevent the user population of one tenant from accessing the virtual portal and portlet components of another tenant. We will also use the dynamic profile capability of WebSphere Portlet Factory to create multiple highly customized applications from one code base.
    FREE! Go There Now!


    NEW! Best Practices in Integrated Requirements Management

    Poor Requirements Management capabilities in an Enterprise have been linked to excessive project failures, escalating IT costs, and failure to deliver competitive advantage into the marketplace. Join Brianna M Smith from IBM Rational and learn about how successful organizations align IT and Business stakeholders through collaborative processes and tools for effective requirements management, and how an integrated approach across the IT lifecycle can provide unparalleled visibility and traceability to ensure that project teams are delivering on the business vision by "doing the right things" and "doing things right."
    FREE! Go There Now!


    NEW! Download DB2 Express-C 9.5

    Visit IBM developerWorks to download IBM DB2 Express-C 9.5, a no-charge version of DB2 Express 9 database server. DB2 Express-C offers the same core data server base features as other DB2 Express editions and provides a solid base to build and deploy applications developed using C/C++, Java, .NET, PHP, and other programming languages.
    FREE! Go There Now!


    NEW! Evaluate IBM Rational Software Analyzer V7.0

    Download a free trial version of IBM Rational Software Analyzer Developer Edition V7.0 to identify bug defects earlier in the software development cycle. Rational Software Analyzer is an extensible software development solution that reduces the expense of bug-fixes by enabling static analysis code reviews and bug identification very early in the development cycle.
    FREE! Go There Now!


    NEW! Improve your build process with IBM Rational Build Forge, Part 1: Create a continuous build and integration environment

    Learn how to implement a build management system that uses and extends your existing automation technologies. This tutorial shows, step-by-step, how to install and configure IBM Rational Build Forge to manage builds for Jakarta Tomcat from source code.
    FREE! Go There Now!


    NEW! Rational Modeling Extension for Microsoft.Net

    Rational Modeling Extension for Microsoft .NET enhances usability for code generation supporting a more intelligent refactoring. The latest enhancements enable organizations with Java and .NET systems and software development maintain architectural integrity across heterogeneous platforms.
    FREE! Go There Now!


    NEW! Trial download: IBM Rational Functional Tester V7.0.1

    Get a free trial download of the latest version of IBM Rational Functional Tester V7.0.1. Rational Functional Tester is an automated functional and regression testing solution for QA teams concerned with the quality of their Java, Microsoft Visual Studio .NET, and Web-based applications.
    FREE! Go There Now!


    NEW! Webcast: Calling All Testers! Find Application Vulnerabilities Early in the Development Process Where they are Easier to Fix and Less Risky to your Business

    In this webcast, IBM Rational will discuss the importance of Web application security and will share techniques and best practices to introduce application security testing into current QA processes including: understanding common security vulnerabilities and techniques to integrate security testing with defect tracking and remediation systems in an effort to safeguard sensitive online information.
    FREE! Go There Now!


    NEW! Webcast: Introducing the new Information Server and Solutions community: LeverageInformation

    User communities play an important role in communication and collaboration around products, solutions and other areas of special interest to members. Successful communities are able to provide the right mix of content and services to deliver a value proposition that resonates with each audience. Join Tom Inman, VP of Marketing for Information and Platform Solutions as he introduces the new LeverageINFORMATION community. During this webcast, learn about the value provided by the community and how customers and partners derive value from the community in addressing their own technical and business challenges.
    FREE! Go There Now!



    All FREE IBM® developerWorks Tools!

    SITE NAVIGATION CODE ARTICLES

    - Simple Menu System
    - Simply image viewer script
    - Simple File Lister
    - Dynamic Error Pages
    - BSoftEditor
    - Yahoo Status
    - Page numbers
    - PHP Search Navigator 1.0
    - Simple Page Navigation
    - An easy page browser ( prev 6 7 8 9 10 next )
    - AutoIndex PHP Script (Directory Indexer)
    - Bs_HtmlNavigation (Navigation and Sitemap cl...
    - Another Paging with Stage
    - Website Navigation via PHP
    - MySQL Paging Class





    © 2003-2009 by Developer Shed. All rights reserved. DS Cluster 2 Hosted by Hostway
    For more Enterprise Application Development news, visit eWeek