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";
$query = mysql_query($sql);
echo"<div id='pagination'>";
if ($pageno == 1) {
echo " FIRST PREV       ";
} else {
echo " <a href='{$_SERVER['PHP_SELF']}?pageno=1'>FIRST</a>       ";
$prevpage = $pageno-1;
echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$prevpage'>PREV</a>       ";
}
echo"</div>";
echo"<div id='pagination1'>";
echo " ( Page <b>$pageno</b> of $lastpage )      ";
echo"</div>";
echo"<div id='pagination2'>";
if ($pageno == $lastpage) {
echo " NEXT LAST      ";
} else {
$nextpage = $pageno+1;
echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$nextpage'>NEXT</a>      ";
echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$lastpage'>LAST</a> ";
}
echo"</div>";