分页问题 [英] Problem in pagination

问题描述

你好，
我面临一个分页问题.
实际上我已经成功完成了分页，但是问题出在where子句
我在WHERE子句中使用了SELECT查询.使用输入字段.
现在的问题是在选择该分页的页面时，我必须再次选择在where子句中使用的输入字段.
这是我的代码:

Hello,
I am facing one problem of pagination.
Actually I did pagination successfully,but problem is getting by where clause
I used SELECT query with WHERE clause.Using input field.
Now the problem is that "while choosing the page of that pagination I have to again choose that input fields which used in the where clause.
Here is my piece of code :

<?php
   $i = 0;

                if(!empty($_POST['select2']))
                {
        foreach ($_POST['select2'] as $selectedOption)
            {
                $options[$i++] = $selectedOption;
            }
                }

if (isset($_GET['pageno'])) {
   $pageno = $_GET['pageno'];
} else {
   $pageno = 1;
}
      $sql ="select DISTINCT date,mobno,city,state,type,telecaller,time FROM import";
    $query  = mysql_query($sql);
      $query_data = mysql_num_rows($query);

$numrows = $query_data;
$rows_per_page = 10;
$lastpage      = ceil($numrows/$rows_per_page);
$pageno = (int)$pageno;
if ($pageno > $lastpage) {
   $pageno = $lastpage;
}
if ($pageno < 1) {
   $pageno = 1;
}
$limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;
            $sql = "select date,mobno,city,state,type,telecaller FROM import WHERE time IN(";
        $num = count($options);
        for ($i=0; $i<$num-1; $i++)
        {
        $sql .= "'".$options[$i]."', ";
        }
        $sql .= "'".$options[$i]."')";
        $sql .= "GROUP BY mobno,telecaller ORDER BY date DESC $limit";
       // OR date1='$_POST[date]'
        //echo $sql . "<br>";
          $query  = mysql_query($sql);
            echo"<div id='pagination'>";
if ($pageno == 1) {
   echo " FIRST    PREV &nbsp &nbsp &nbsp ";
} else {
   echo " <a href='{$_SERVER['PHP_SELF']}?pageno=1'>FIRST</a> &nbsp &nbsp &nbsp ";
   $prevpage = $pageno-1;
   echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$prevpage'>PREV</a> &nbsp &nbsp &nbsp ";
}
echo"</div>";
echo"<div id='pagination1'>";
echo " ( Page <b>$pageno</b> of $lastpage ) &nbsp &nbsp &nbsp";
echo"</div>";
echo"<div id='pagination2'>";
if ($pageno == $lastpage) {
   echo " NEXT   LAST &nbsp &nbsp &nbsp";
} else {
   $nextpage = $pageno+1;
   echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$nextpage'>NEXT</a> &nbsp &nbsp &nbsp";
   echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$lastpage'>LAST</a> ";
}
echo"</div>";

推荐答案

i = 0 ; if(！empty(

i = 0; if(!empty(

_POST [' select2'] )) { foreach (

_POST['select2'])) { foreach (

_POST [' as

_POST['select2'] as

这篇关于分页问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！