pagination error

232 New Member

this is my search page on which i am getting two parameters from previous page but the problem is that as soon as i click any other next pages my sql query fails as it doesnt get these two parameters
kindly help

Expand|Select|Wrap|Line Numbers

 <?php

    session_start();   
 
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

   <title></title>

   <meta name="generator" content="Microsoft FrontPage 5.0" />

   <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

   <meta name="description" content="" />

   <meta name="keywords" content="" />

   <meta name="author" content="" />

<link rel="stylesheet" href="../include/style.css" type="text/css" />

</head>

<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
 
<?php require("../include/header.php"); ?>

<?php require("../include/left.php"); ?>
 
 <div class="heading"> 

    welcome all

   </div>

     <div class="text"> 

    <?php

    //Include the PS_Pagination class

    include('../include/ps_pagination.php');
 
    //Connect to mysql db

    $conn = mysql_connect('localhost','root','');

    if(!$conn) die("Failed to connect to database!");

    $status = mysql_select_db('ncpul1', $conn);

    if(!$status) die("Failed to select database!");

$colv=$_POST["colv"];

$coln=$_POST["coln"];

echo "Search result for $coln------>$colv<br>";

    $sql="SELECT * FROM institute WHERE ".$coln." like '%".$colv."%' order by centrecode asc";
 
    /*

     * Create a PS_Pagination object

     * 

     * $conn = MySQL connection object

     * $sql = SQl Query to paginate

     * 10 = Number of rows per page

     * 5 = Number of links

     * "param1=valu1&param2=value2" = You can append your own parameters to paginations links

     */

    $pager = new PS_Pagination($conn, $sql, 10, 5, "param1=valu1&param2=value2");
 
    /*

     * Enable debugging if you want o view query errors

    */

    $pager->setDebug(true);
 
    /*

     * The paginate() function returns a mysql result set

     * or false if no rows are returned by the query

    */

    $rs = $pager->paginate();

    if(!$rs) die(mysql_error());

    while($row = mysql_fetch_assoc($rs)) {

        echo $row['address'],"<br />\n";

    }

    echo "<br />\n";

    echo "<br />\n";

    echo"<div align='center'>";

    //Display the full navigation in one go

    echo $pager->renderFullNav();
 
    echo "<br />\n";

    echo"</div>";
 
?>

   </div>
 
<?php require("../include/right.php"); ?><?php require("../include/footer.php"); ?>
 
</body>

</html>

this is pagination file code(ps_paginat ion.php)

Expand|Select|Wrap|Line Numbers

 <?php

/**

 * PHPSense Pagination Class

 *

 * PHP tutorials and scripts

 *

 * @package        PHPSense

 * @author        Jatinder Singh Thind

 * @copyright    Copyright (c) 2006, Jatinder Singh Thind

 * @link        http://www.phpsense.com

 */
 
// ------------------------------------------------------------------------
 
class PS_Pagination {

    var $php_self;

    var $rows_per_page = 10; //Number of records to display per page

    var $total_rows = 0; //Total number of rows returned by the query

    var $links_per_page = 5; //Number of links to display per page

    var $append = ""; //Paremeters to append to pagination links

    var $sql = "";

    var $debug = false;

    var $conn = false;

    var $page = 1;

    var $max_pages = 0;

    var $offset = 0;
 
    /**

     * Constructor

     *

     * @param resource $connection Mysql connection link

     * @param string $sql SQL query to paginate. Example : SELECT * FROM users

     * @param integer $rows_per_page Number of records to display per page. Defaults to 10

     * @param integer $links_per_page Number of links to display per page. Defaults to 5

     * @param string $append Parameters to be appended to pagination links 

     */
 
    function PS_Pagination($connection, $sql, $rows_per_page = 10, $links_per_page = 5, $append = "") {

        $this->conn = $connection;

        $this->sql = $sql;

        $this->rows_per_page = (int)$rows_per_page;

        if (intval($links_per_page ) > 0) {

            $this->links_per_page = (int)$links_per_page;

        } else {

            $this->links_per_page = 5;

        }

        $this->append = $append;

        $this->php_self = htmlspecialchars($_SERVER['PHP_SELF'] );

        if (isset($_GET['page'] )) {

            $this->page = intval($_GET['page'] );

        }

    }
 
    /**

     * Executes the SQL query and initializes internal variables

     *

     * @access public

     * @return resource

     */

    function paginate() {

        //Check for valid mysql connection

        if (! $this->conn || ! is_resource($this->conn )) {

            if ($this->debug)

                echo "MySQL connection missing<br />";

            return false;

        }
 
        //Find total number of rows

        $all_rs = @mysql_query($this->sql );

        if (! $all_rs) {

            if ($this->debug)

                echo "SQL query failed. Check your query.<br /><br />Error Returned: " . mysql_error();

            return false;

        }

        $this->total_rows = mysql_num_rows($all_rs );

        @mysql_close($all_rs );
 
        //Return FALSE if no rows found

        if ($this->total_rows == 0) {

            if ($this->debug)

                echo "Query returned zero rows.";

            return FALSE;

        }
 
        //Max number of pages

        $this->max_pages = ceil($this->total_rows / $this->rows_per_page );

        if ($this->links_per_page > $this->max_pages) {

            $this->links_per_page = $this->max_pages;

        }
 
        //Check the page value just in case someone is trying to input an aribitrary value

        if ($this->page > $this->max_pages || $this->page <= 0) {

            $this->page = 1;

        }
 
        //Calculate Offset

        $this->offset = $this->rows_per_page * ($this->page - 1);
 
        //Fetch the required result set

        $rs = @mysql_query($this->sql . " LIMIT {$this->offset}, {$this->rows_per_page}" );

        if (! $rs) {

            if ($this->debug)

                echo "Pagination query failed. Check your query.<br /><br />Error Returned: " . mysql_error();

            return false;

        }

        return $rs;

    }
 
    /**

     * Display the link to the first page

     *

     * @access public

     * @param string $tag Text string to be displayed as the link. Defaults to 'First'

     * @return string

     */

    function renderFirst($tag = 'First') {

        if ($this->total_rows == 0)

            return FALSE;
 
        if ($this->page == 1) {

            return "$tag ";

        } else {

            return '<a href="' . $this->php_self . '?page=1&' . $this->append . '">' . $tag . '</a> ';

        }

    }
 
    /**

     * Display the link to the last page

     *

     * @access public

     * @param string $tag Text string to be displayed as the link. Defaults to 'Last'

     * @return string

     */

    function renderLast($tag = 'Last') {

        if ($this->total_rows == 0)

            return FALSE;
 
        if ($this->page == $this->max_pages) {

            return $tag;

        } else {

            return ' <a href="' . $this->php_self . '?page=' . $this->max_pages . '&' . $this->append . '">' . $tag . '</a>';

        }

    }
 
    /**

     * Display the next link

     *

     * @access public

     * @param string $tag Text string to be displayed as the link. Defaults to '>>'

     * @return string

     */

    function renderNext($tag = '&gt;&gt;') {

        if ($this->total_rows == 0)

            return FALSE;
 
        if ($this->page < $this->max_pages) {

            return '<a href="' . $this->php_self . '?page=' . ($this->page + 1) . '&' . $this->append . '">' . $tag . '</a>';

        } else {

            return $tag;

        }

    }
 
    /**

     * Display the previous link

     *

     * @access public

     * @param string $tag Text string to be displayed as the link. Defaults to '<<'

     * @return string

     */

    function renderPrev($tag = '&lt;&lt;') {

        if ($this->total_rows == 0)

            return FALSE;
 
        if ($this->page > 1) {

            return ' <a href="' . $this->php_self . '?page=' . ($this->page - 1) . '&' . $this->append . '">' . $tag . '</a>';

        } else {

            return " $tag";

        }

    }
 
    /**

     * Display the page links

     *

     * @access public

     * @return string

     */

    function renderNav($prefix = '<span class="page_link">', $suffix = '</span>') {

        if ($this->total_rows == 0)

            return FALSE;
 
        $batch = ceil($this->page / $this->links_per_page );

        $end = $batch * $this->links_per_page;

        if ($end == $this->page) {

            //$end = $end + $this->links_per_page - 1;

        //$end = $end + ceil($this->links_per_page/2);

        }

        if ($end > $this->max_pages) {

            $end = $this->max_pages;

        }

        $start = $end - $this->links_per_page + 1;

        $links = '';
 
        for($i = $start; $i <= $end; $i ++) {

            if ($i == $this->page) {

                $links .= $prefix . " $i " . $suffix;

            } else {

                $links .= ' ' . $prefix . '<a href="' . $this->php_self . '?page=' . $i . '&' . $this->append . '">' . $i . '</a>' . $suffix . ' ';

            }

        }
 
        return $links;

    }
 
    /**

     * Display full pagination navigation

     *

     * @access public

     * @return string

     */

    function renderFullNav() {

        return $this->renderFirst() . '&nbsp;' . $this->renderPrev() . '&nbsp;' . $this->renderNav() . '&nbsp;' . $this->renderNext() . '&nbsp;' . $this->renderLast();

    }
 
    /**

     * Set debug mode

     *

     * @access public

     * @param bool $debug Set to TRUE to enable debug messages

     * @return void

     */

    function setDebug($debug) {

        $this->debug = $debug;

    }

}

?>

Nov 11 '09 #1

Subscribe Reply

2593

Markus

6,050

Recognized Expert Expert

Lines 34 and 35 should really be using the GET array - modify your search form to use method="get", and modify lines 34 and 35 accordingly.

If you look at the pagination class, it allows you to pass in some arbitrary data that will be appended to the links the pagination provides - this is where you should give it the GET data (coln, colv, etc.)

Nov 11 '09 #2

kkshansid

232

New Member

@Markus
thank you for your valuable information its working now

Nov 12 '09 #3

Similar topics

2405

I need pagination

by: leegold2 | last post by:

Hi, I have been looking around for a way to paginate php/mysql table output. There are a lot of hits when I google it. But unfortunately what I have tried either does not work or is imho just arcane code. So I am looking for a simple, clearly explained, and working pagination code snip that I can adapt, or a modular solution. I'd prefer something you have tried yourself and know it works. The simpler the better. Thanks very much.

PHP

2328

Pagination Problem

by: Chris H | last post by:

I am having a problem with pagination, basically the problem is happening in the "PREV / NUMBERS / NEXT" links, it appears as if the reason is becasue the increment and decrement operators aren't functioning or the $page variable isnt working in that part of the code... Below is the link to the working but broken page.. as well as the main part of my code... Hopefully someone can explain why the operators arent working or maybe see what i...

PHP

2782

Gallery Pagination Result Problem

by: ste | last post by:

Hi there, Further to my recent posts where I've received excellent help from Rik and Jerry, I've ended up with an image gallery on my website that displays images in a table, 3 images per row. This works great and opens all images in the database when I open the url mywebsite/gallery.php, or I can choose certain images (by category) by going to url's like mywebsite/gallery.php?category=landscape Although the above worked perfectly...

PHP

2134

Pagination

by: assgar | last post by:

Hello I have a search page where you select the letter of the alphabet and the person's information who's name beginning with that letter is displayed. This function is placed on the web page to search and display the information. Everything works except one thing. The problem is if there are 3 pages page one is OK, but when you select next to go to page two the information on page two is no displaying.

PHP

3382

Store multiple selection from pagination info into single array

by: assgar | last post by:

Hi I was using a schroll bar to display multiple rows of dynamically created from database records. The scrolling was not displaying the data properly so I have decided to use pagination. The problem I am having is, if I select one item on page #1 and another on page #5 only the last item selected on page #5 is stored in the array. How can I store selections from multiple pages into one array?

PHP

6851

pagination using XSL

by: shalini jain | last post by:

Hi, I want to know how can we do pagination using XSL. There are number of tutorials available on pagination using PHP but nothing with XSL. i am really stuck with my code. Below is the code that i have written for pagination but it displays the link of all the pages at one go i.e. if i have 8 pages showing 10 results per page than it shows links for all 8 pages. Previous 1-10 11-20 21-30 31-40 41-50 51-60 61-70 71-80 Next i want to...

XML

2778

Help on pagination please

by: gnawz | last post by:

I have a pagination function I am using in a file called functions.php as below<? //Pagination functions function getPagingQuery($sql, $itemPerPage = 10) { if (isset($_GET) && (int)$_GET > 0) { $page = (int)$_GET; } else { $page = 1; } // start fetching from this row number $offset = ($page - 1) * $itemPerPage; return $sql . " LIMIT $offset, $itemPerPage"; } /* Get the links to navigate between...

PHP

3575

Pagination - First page works great, next pages are blank

by: ArizonaJohn | last post by:

Hello, The code below works great. The user enters a name into an HTML form, the code looks up a table with that name, and then that table is displayed. I am trying to use pagination with it, and the pagination almost works. The first page of the pagination works fine, but when I click on one of the links for one of the next pages, the page is blank. I have seen people mention this problem, and they have been told that a variable is...

PHP

1807

pagination error

by: omerbutt | last post by:

hi i have made a simple pagination but it is creating problem , the problem is that if there are any products under the category that is clicked in the left menu then the page works fine but if it does not have any product listed under that category then the page halts no eror is diplayed and the page halts at the line $total = mysql_result($result, 0, 0) or die(mysql_error()); the working example can be seen here link here is the full...

PHP

9568

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9404

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10168

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10008

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9959

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8833

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7381

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5279

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3532

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP