Site Navigation Code
  Home arrow Site Navigation Code arrow Page numbers
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 numbers
By: Codewalkers
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 3
    2003-07-01

    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


    This script enables you to create page number links and previous / next links.
    It is useful when displaying search results or large amount of data.
    It also allows user to choose how many records to display per page.


    By : tebrino

    <?php
    /*
    This script enables you to create page number links and previous / next links.
    It is useful when displaying search results or large amount of data.
    It also allows user to choose how many records to display per page.
    To use it simply replace MySQL queries with your own. With small changes
    you can use it with any database server.
    To use it simply edit the config part and line marked with text &quot;EDIT ME&quot; and that's it. Enjoy.
    If you have any questions, comments, or if you find any bugs please feel free to contact me:
    Author: Ilir Fekaj
    Contact: tebrino@hotmail.com
    Website / live demo: http://www.freemidi.breezeland.com/page_numbers.php
    Created: July 01. 2003.
    Modified: July 02. 2003.
    Version: 1.0.1
    If you like it, use it, you can also give me a credit.
    */

    // config-------------------------------------
    $host = "localhost"; //your database host
    $user = "username"; // your database user name
    $pass = "password"; // your database password
    $db = "database_name"; // your database name

    $filename = "your_file_name.php"; // name of this file
    $option = array (5, 10, 25, 50, 100, 200);
    $default = 25; // default number of records per page
    $action = $_SERVER['PHP_SELF']; // if this doesn't work, enter the filename
    $query = "SELECT title, url FROM table_name ORDER BY title"; // database query. Enter your query here
    // end config---------------------------------

    $opt_cnt = count ($option);

    $go = $_GET['go'];
    // paranoid
    if ($go == "") {
    $go = $default;
    }
    elseif (!in_array ($go, $option)) {
    $go = $default;
    }
    elseif (!is_numeric ($go)) {
    $go = $default;
    }
    $nol = $go;
    $limit = "0, $nol";
    $count = 1;


    echo "<form name=\"form1\" id=\"form1\" method=\"get\" action=\"$action\">\r\n";
    echo "<select name=\"go\" id=\"go\">\r\n";

    for ($i = 0; $i <= $opt_cnt; $i ++) {
    if ($option[$i] == $go) {
    echo "<option value=\"".$option[$i]."\" selected=\"selected\">".$option[$i]."</option>\r\n";
    } else {
    echo "<option value=\"".$option[$i]."\">".$option[$i]."</option>\r\n";
    }
    }

    echo "</select>\r\n";
    echo "<input type=\"submit\" name=\"Submit\" id=\"Submit\" value=\"Go\" />\r\n";
    echo "</form>\r\n";

    $connection = mysql_connect ($host, $user, $pass) or die ("Unable to connect");
    mysql_select_db ($db) or die ("Unable to select database $db");


    // control query------------------------------
    /* this query checks how many records you have in your table.
    I created this query so we could be able to check if user is
    trying to append number larger than the number of records
    to the query string.*/
    $off_sql = mysql_query ("$query") or die ("Error in query: $off_sql".mysql_error());
    $off_pag = ceil (mysql_num_rows($off_sql) / $nol);
    //--------------------------------------------

    $off = $_GET['offset'];
    //paranoid
    if (get_magic_quotes_gpc() == 0) {
    $off = addslashes ($off);
    }
    if (!is_numeric ($off)) {
    $off = 1;
    }
    // this checks if user is trying to put something stupid in query string
    if ($off > $off_pag) {
    $off = 1;
    }

    if ($off == "1") {
    $limit = "0, $nol";
    }
    elseif ($off <> "") {
    for ($i = 0; $i <= ($off - 1) * $nol; $i ++) {
    $limit = "$i, $nol";
    $count = $i + 1;
    }
    }

    // Query to extract records from database.
    $sql = mysql_query ("$query LIMIT $limit") or die ("Error in query: $sql".mysql_error());

    while ($row = mysql_fetch_object($sql)) {
    // EDIT ME. Edit the line below to match your own table. Just replace $row->url with $row->your_table_column
    echo "$count. <a href=\"$row->url\">$row->title</a><br />\r\n"; // this is example, you may enter here anything you like
    $count += 1;
    }
    echo "<br /><br />\r\n";
    if ($off <> 1) {
    $prev = $off - 1;
    echo "[ &lt; <a href=\"$filename?offset=$prev&amp;go=$go\">prev</a> ] \r\n";
    }
    for ($i = 1; $i <= $off_pag; $i ++) {
    if ($i == $off) {
    echo "[<b> $i </b>] \r\n";
    } else {
    echo "[ <a href=\"$filename?offset=$i&amp;go=$go\">$i</a> ] \r\n";
    }
    }
    if ($off < $off_pag) {
    $next = $off + 1;
    echo "[ <a href=\"$filename?offset=$next&amp;go=$go\">next</a> &gt; ] \r\n";
    }

    echo "<br /><br />\r\n";
    echo "Page $off of $off_pag<br />\r\n";
    ?>
    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!


    NEW! IBM Enterprise Modernization Sandbox for System z

    IBM Enterprise Modernization solutions help organizations evolve core IT systems towards modern architectures and technologies—reducing the burden of maintenance and freeing up resources to develop new business requirements and capabilities. With the IBM Enterprise Modernization Sandbox for System z you can evaluate IBM Enterprise Modernization solutions focused on five key areas: Assets, Architectures, Skills, Processes and Infrastructures, and Investment. Each solution is based upon real customer experiences and offers a proven path to get you started with your modernization projects.
    FREE! Go There Now!


    Role of Integrated Requirements Management in Software Delivery

    As organizations integrate software into every aspect of business, they are constantly pressured to deliver faster, better, and cheaper results. Unfortunately, a “dis-integrated” software delivery approach reduces returns while increasing costs. This IBM Rational White Paper shows how Integrated Requirements Management aligns organizations around maximizing value and keeping pace with change.
    FREE! Go There Now!


    NEW! Achieving True Agility -- How process can change the behavior of your tools

    Achieving true agility is a never-ending effort. We will showcase how you can become agile incrementally, a few practices at the time.Which practices should any agile team strive to adopt? What additional practices should you consider based on your needs to scale? Adopting practices are however made much easier with the right tool support. What about if your tools adapt to your practices? We will take a look at how the Jazz technology can be leveraged to make your process change the behavior of your tools.
    FREE! Go There Now!


    NEW! IBM Rational AppScan Standard Edition V7.7

    Secure your Web applications with IBM Rational AppScan Standard Edition V7.7, previously known as Watchfire AppScan. This Web application security testing tool automates vulnerability assessments and scans and tests for common Web application vulnerabilities. Visit IBM developerWorks to download a free trial of IBM Rational AppScan Standard Edition V7.7.
    FREE! Go There Now!


    NEW! Run your first CICS application on a PC using TXSeries for Windows

    Learn the basics of the IBM Customer Information Control System (CICS). With a hands-on exercise, learn how to get your first CICS application up and running on your desktop using TXSeries V6.1 for Windows. The tutorial shows you how to download and install a free trial version of TXSeries V6.1.
    FREE! Go There Now!


    NEW! Maintaining QoS and Process Integrity in an SOA Environment

    This webcast outlines the best practices that must be instituted to gain the maximum benefit from SOA while maintaining high quality of service. Whether you are deploying new applications or managing and monitoring your existing infrastructure, learn how you can ensure high quality of services with SOA based solutions from IBM. All registrants who attend this live Web Seminar will receive complimentary access to a white paper titled “Maintaining QoS in an SOA Environment”.
    FREE! Go There Now!


    NEW! Try the IBM SOA Sandbox for Connectivity

    Visit IBM developerWorks to try the IBM SOA Sandbox for connectivity. The SOA Sandbox for connectivity provides a trial environment with the tooling and components to help you explore how to effectively connect your infrastructure and integrate all of the people, processes and information in your company. Use the hosted sandbox to explore SOA techniques that streamline connecting existing IT assets together, as well as learn how to connect them to new business logic.
    FREE! Go There Now!


    NEW! Section 508 of the U.S. Rehabilitation Act: Web accessibility compliance

    Because access to government information continues to be an area of concern for many U.S. citizens with disabilities, the U.S. government enacted Section 508 of the Rehabilitation Act in 2001 to ensure that government agencies create accessible Web content, enabling all citizens to access the information they need. A fully accessible Web site makes Web content accessible to all individuals, including those with disabilities, who may be accessing Web content via a variety of user agents. Common user agents include standard Web browsers, text-only browsers, assistive devices and mobile devices such as cell phones or personal digital assistants (PDAs).
    FREE! Go There Now!


    NEW! Try IBM Rational Asset Manager V7.0 online!

    You can now evaluate IBM Rational Asset Manager V7.0 online without installing or configuring it on your own system! Rational Asset Manager helps create, modify, govern, find, and reuse any type of development assets, including SOA and systems development assets. Rational Asset Manager helps you reduce software development costs and improve quality by facilitating the reuse of all types of software development-related assets. Visit developerWorks to learn more about this product and register to explore its capabilities online.
    FREE! Go There Now!


    NEW! Webcast: Application security testing and Web compliance

    Join the IBM Watchfire team for an informative discussion on techniques and best practices to proactively manage Web application security and how to effectively build application security testing into the software development lifecycle (SDLC). In this Software Delivery Platform webcast you will learn: How to better understand potential web application security vulnerabilities, best practices and how to effectively integrate application security testing into the software development lifecycle, the importance of detecting and removing software vulnerabilities during application development.
    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 5 Hosted by Hostway
    For more Enterprise Application Development news, visit eWeek