Have an account? Sign in
Login  Register  Facebook
pagination problem
The Pagination script works like a charm. However, this example has the following variables predefined :
tablename (records), $limit).
I need this information to be obtained from a form in the previous page using post method.
Here is my index.php:

$host = $_POST["subcat"];
$date = $_POST["txtDate"];
$tables = "table_".$host."_".$date;
$database = $_POST["cat"];
$limit = $_POST["pagesize"];

        if ($database=="pix")
                $device = "db_pix";
                $device = "db_swt";

//connect to mysql

        mysql_connect("", "root", "") or die (mysql_error());
        mysql_select_db($database) or die(mysql_error());

    //get the function
    include_once ('function.php');

        $page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]);

        $startpoint = ($page * $limit) - $limit;

        //to make pagination
        $statement = "$tables ORDER BY datetime ASC";
<!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" xml:lang="en" lang="en">

        <meta http-equiv="content-type" content="text/html; charset=utf-8" />
        <link href="css/pagination.css" rel="stylesheet" type="text/css" />
        <link href="css/grey.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
        .records {
            width: 1300px;
            margin: 5px;
            padding:2px 5px;
            border:1px solid #B6B6B6;

        .record {
            color: #474747;
            margin: 5px 0;
            padding: 3px 5px;
     border: 1px solid #B6B6B6;
            cursor: pointer;
            letter-spacing: 2px;
        .record:hover {

        .round {
                -khtml-border-radius: 8px;
                -webkit-border-radius: 8px;

            width: 510px;
        p.createdBy a {color: #666666;text-decoration: none;}


    <div class="records round">
            //show records
            $query = mysql_query("SELECT * FROM {$statement} LIMIT {$startpoint} , {$limit}");

                while ($row = mysql_fetch_assoc($query)) {
            <div class="record round"><?php echo "{$row['datetime']}==={$row['level']}==={$row['message']}";?></div>

        echo pagination($statement,$limit,$page);

I am beginner is PHP and i am really confused how to do this.
Started: October 13, 2011 Latest Activity: June 14, 2018 pagination form

please first make sure from the post data by var_dump it
October 13, 2011

I believe, i didnt explain the issue correctly. The first page works good but when i click the next button it shows a empty page. I added the var_dump and it shows me the values correctly in the first page. however, the next page does not work. it gives me a empty page. I am able to understand that the variable values are not getting passed to functions.php. But unfortunately, i dont know how to do it.
October 13, 2011

4 Answers
Para Q Es El Medicamento Cephalexin <a href=http://cialiviag.com>canadian cialis</a> Priligy Ritardante Cytotec Voie Oral

Posted: Ellgaibra
In: June 14, 2018

generic cialis soft tabs 20mg
<a href="http://lzdwqokfs.com/">generic cialis soft tabs online</a>
cialis 20mg tablets
<a href="http://lzdwqokfs.com/">generic cialis release</a>
cialis soft tabs 40mg
generic viagra and cialis

Posted: Thomascor
In: April 26, 2018

thank you. After a long research with my limited php knowledge. i found that i have to add the variables in pagination function call in index.php and add the same in function.php and use GET method.

I can post my edited php files if somebody needs an example.

Posted: shbobj
In: October 19, 2011

I know this is kind of old but if I could take a look ay those edited php files it would be great. Thanks
March 25, 2012

can i see the examples of your edited file. i am also having the same problem. thanks.
June 12, 2012

try to echo this in the second page echo
echo "SELECT * FROM {$statement} LIMIT {$startpoint} , {$limit};
and tell me the result

Posted: MacOS
In: October 13, 2011

Edited: MacOS
In: October 13, 2011

Your Answer

xDo you want to answer this question? Please login or create an account to post your answer