下一页的结果没有分页 [英] Next page results are not getting in pagination

问题描述

SEARCH.PHP

SEARCH.PHP

@session_start();
include 'connections.php';
$button = $_POST['submit'];
$search = $_POST['searchvalue']; 
$name = $_POST['name'];
if(strlen($search)<=1)
{
echo "Search term too short";
}
else{
echo "You searched for $search <hr size='1'></br>";

$construct = "SELECT * FROM books WHERE category = '$name'  AND (title LIKE '%$search%' or author LIKE '%$search%')";                                             
                                             
$run = mysql_query($construct);

$foundnum = mysql_num_rows($run);

if ($foundnum==0)
echo "Sorry, there are no matching result for $search.</br></br>1.";
else
{
echo "$foundnum results found !<p>";
}
$per_page = 2;
$start = $_GET['start'];
$max_pages = ceil($foundnum / $per_page);


if($start)
$start= ($start- 1) * $per_page;
else
$start=0;

   $query_with_limit = $construct . ' LIMIT ' . mysql_real_escape_string($start) .',' . mysql_real_escape_string($per_page);
    $getquery = mysql_query($query_with_limit);

while($runrows = mysql_fetch_assoc($getquery))
{
echo '<div class="news_box">
								<a href="#">';
								if($runrows ['cover_page_img']=="")
								{
									echo '<img class="news_image" src="'.INDEX_URL.'images/book_open.jpg" alt="image" width="90" height="90"/>';
								}
								else{
									echo '<img class="news_image" src="'.INDEX_URL.'images/BookCoverImgs/'.$row['cover_page_img'].'" alt="image" width="90" height="90"/>';
								}
								echo '							
								</a>
							<h3><a href="#">'.$runrows ['title'].'</a></h3>
								<p> '.substr($runrows ['edition'],0,150).'.......</p>
								<div class="more float_r"><a href="#">Read more</a></div>
							<div class="cleaner"></div>
							</div>';

}

$prev = $start - $per_page;
$next = $start + $per_page;
                       
$adjacents = 3;
$last = $max_pages - 1;
  
if($max_pages > 1)
{  
//previous button
if (!($start<=0))
echo " <a href='search.php?searchvalue=$search&submit&start=$prev'>Prev</a> ";   
          
//pages
if ($max_pages < 7 + ($adjacents * 2))   //not enough pages to bother breaking it up
{
$i = 0;  
for ($counter = 1; $counter <= $max_pages; $counter++)
{
if ($i == $start){
echo " <a href='search.php?searchvalue=$search&submit=$i'>$counter</a> ";
}
else {
echo " <a href='search.php?searchvalue=$search&submit&start=$i'>$counter</a> ";
} 
$i = $i + $per_page;                
}
}
elseif($max_pages > 5 + ($adjacents * 2))    //enough pages to hide some
{
//close to beginning; only hide later pages
if(($start/$per_page) < 1 + ($adjacents * 2))       
{
$i = 0;
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($i == $start){
echo " <a href='search.php?searchvalue=$search&submit=$i'>$counter</a> ";
}
else {
echo " <a href='search.php?searchvalue=$search&submit=$i'>$counter</a> ";
}
$i = $i + $per_page;                                      
}
                          
}
//in middle; hide some front and some back
elseif($max_pages - ($adjacents * 2) > ($start / $per_page) && ($start / $per_page) > ($adjacents * 2))
{
echo " <a href='search.php?searchvalue=$search&submit=0'>1</a> ";
echo " <a href='search.php?searchvalue=$search&submit&start=$per_page'>2</a> .... ";
 
$i = $start;                
for ($counter = ($start/$per_page)+1; $counter < ($start / $per_page) + $adjacents + 2; $counter++)
{
if ($i == $start){
echo " <a href='search.php?searchvalue=$search&submit&start=$i'>$counter</a> ";
}
else {
echo " <a href='search.php?searchvalue=$search&submit&start=$i'>$counter</a> ";
}  
$i = $i + $per_page;               
}
                                  
}
//close to end; only hide early pages
else
{
echo " <a href='search.php?searchvalue=$search&submit=0'>1</a> ";
echo " <a href='search.php?searchvalue=$search&submit&start=$per_page'>2</a> .... ";
 
$i = $start;               
for ($counter = ($start / $per_page) + 1; $counter <= $max_pages; $counter++)
{
if ($i == $start){
echo " <a href='search.php?searchvalue=$search&submit&start=$i'>$counter</a> ";
}
else {
echo " <a href='search.php?searchvalue=$search&submit&start=$i'>$counter</a> ";  
}
$i = $i + $per_page;             
}
}
}
          
//next button
if (!($start >=$foundnum-$per_page))
echo " <a href='search.php?searchvalue=$search&submit&start=$next'>Next</a> ";   
}  
echo "</center>";
}
 ?>

如果我在每页设置2条记录我在搜索结果后每页得到2条记录，但是如果我点击下一步按钮我没有在下一页获得记录，而是我得到SEARCH VALUE TOO SHORT页面中的第一条if条件，请任何人帮助我，我做错了..

If I set 2 records per page I am getting 2 records per page after search results, but If I click next button I am not getting the records in next page, instead I am getting "SEARCH VALUE TOO SHORT" the first if condition in the page, please anyone help me what I am doing wrong..

推荐答案

按钮 =

button =

_POST [' submit'];

_POST['submit'];

search =

search =

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